Field Unavailable in Automations Criteria
I'm trying to set up an automation with the trigger being, "when a 'Task' is modified and the 'Time Spent' field changes, yet is not blank." However, under "additional criteria" where I'm trying to sa...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendTry making a dummy helper field of the same type with a blank formula and use that to compare in he Automation Filter.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- I tried duplicating the field, but the duplicate doesn't show up in the dropdown list.
I tried making a new text field, which did show up in the list.
I tried changing the text field to a duration field, and it was no longer available. After changing the field type, the automation page displays an error:
time spent 3 (fid_1163_)Remove condition or a select different field
Apparently, it doesn't like working with duration fields. I'll just make another field that evaluates whether the time spent field was filled in and use that to filter the automation.
------------------------------
Ryan Farrington
Graphic designer, project manager, copywriter, engraver, internal Quick Base developer
rfarrington@experiencepinpoint.com
------------------------------- MarkShnier__YouOhhhh, yes I think I had the same problem with duration type fields. I think you were right that automations don't play nicely with duration fields.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
