Forum Discussion

BenjaminGolden's avatar
BenjaminGolden
Qrew Cadet
6 years ago

Running Action/Automation with a Formula Trigger

So, to pre-summarize and make a long story short, I'm looking for a way to get an Automation, Action, or whatever method may work to create a new record when the result of a formula changes. I know th...
Formulas and functions
Quickbase Automations
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago
For a fully automated solution you can try this but I don't know for sure if it will work.  I have other non fully automated solutions as plan B.

Set up a saved table to table import  and an Automation run it daily to copy the formula date into a [last recorded formula date] field.  ie import the record into themselves merging on [Record ID#] filtered by where those two dates are not equal.

Then set up another Automation to create a Work order when the 
[last recorded formula date] changes.

Let me know if that works or does not work.

BenjaminGolden's avatar
BenjaminGolden
Qrew Cadet
6 years ago
Sounds pretty good to me. I'm going to be reworking a lot of aspects of the app in the meantime, but I'll most likely integrate something like what you described for when it comes down to creating schedules to order maintenance multiple times a day as opposed to every day or week or month. Thanks again!