Skip to main content
Question

Field Unavailable in Automations Criteria

  • October 5, 2020
  • 0 replies
  • 22 views

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 say, "'Time Spent' is not <<blank>>", the system refuses to include the field in the dropdown.

You can see in the attached image 'Time Spent' is second to the last in the list of "any of the following fields change." However, it's not in the dropdown below. Why would this be?

The 'Time Spent' field is searchable. It's a duration field.


Any insight is greatly appreciated!

------------------------------
Ryan Farrington
Graphic designer, project manager, copywriter, engraver, internal Quick Base developer
rfarrington@experiencepinpoint.com
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Try 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
------------------------------