NiceDuck
-
Posts
453 -
Joined
-
Last visited
-
Days Won
34
Community Answers
-
NiceDuck's post in Task to count number of entries per user over a shift - count, send report to person, flag outliers. was marked as the answer
You may want to try this:
-
NiceDuck's post in Changing data field to show look-up ID rather than original text was marked as the answer
You will need a task setup like this:
On this case, the values on the answers_lookup.Id is the values that actually on the Connector field. If I want the connector field to have the actual labels, then I will join them by the connector first and update the connector value.
-
NiceDuck's post in How to send email on certain date? was marked as the answer
You may want to try this setup as well:
Directly comparing a date/time value and timestamp is difficult since the timestamp includes hh:mm:ss so it is better to just check if the difference of days between the timestamp and then intended date/time is 0.
-
NiceDuck's post in Table Formula - Count the number of Saturdays between 2 dates was marked as the answer
Here it is on trigger.
-
NiceDuck's post in Conversion failed when converting the nvarchar value was marked as the answer
I just figured it out, turns out I have to add quotation to the 55555
https://cxxxxxxx.caspio.com/rest/v2/tables/demo_table1/records?q.select=Las_Name%2CGender%2Ctest_val&q.where=Test_pin%3D'55555'
Weird, it was working as expected before even without the quotation.
-
NiceDuck's post in Is there any way to make pie charts with separate fields for each series? was marked as the answer
This the Task I used to process those Data
-
NiceDuck's post in Creating and adding childrecords was marked as the answer
@BertM If the creation of child records will originate from creating parent record as well, you can use this trigger on the parent table.
If you dont have an update trigger on the parent table, this should work properly with @AtayBalunbalunan's trigger. Otherwise, you would have an cascading error.
@AtayBalunbalunan, thank you for the tip about getting the count, I did not know that you can get the count of records with just the 'expression field', I thought that a group function is required for that.
-
NiceDuck's post in Using Table Variables in Triggered Actions was marked as the answer
An Agent from Chat support gave me this doc. Its not official but I hope it helps
quack:
Table Variables .pdf
