Forum Discussion
MarkShnier__You
4 years agoQrew Legend
Automations only fire when a record is edited. They do not fire as the result of a formula field changing with the passage of time, or when summary or lookup fields change.
In order to trigger an Automation you would could do a saved table to table import scheduled to run each night (by a scheduled Automation). It could merge the table into itself themselves merging on Record ID and filtered to only include the required records and updating a date time field to the current date/ time or perhaps setting a checkbox field.
Then trigger your Automation to copy the records on that trigger.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
In order to trigger an Automation you would could do a saved table to table import scheduled to run each night (by a scheduled Automation). It could merge the table into itself themselves merging on Record ID and filtered to only include the required records and updating a date time field to the current date/ time or perhaps setting a checkbox field.
Then trigger your Automation to copy the records on that trigger.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------