Forum Discussion

Qrew Cadet

2 years ago

Is it possible to trigger a Pipeline when a formula field changes on record update?

Is it possible to trigger a Pipeline when a formula field changes on record update? I've created a pipeline that is set to trigger when a checkbox formula goes from false to true. It's not triggeri...

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

2 years ago

no, you cannot trigger on a formula field. You will need to trigger on a scalar field(s) that cause the formula field to change.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

MattMakris
Qrew Cadet
2 years ago
Formula fields from other tables cause the formula field to change unfortunately. I tried doing this in form rules as well, but it doesn't seem to work either.

------------------------------
Matt Makris
------------------------------
- MarkShnier__You
  Qrew Legend
  2 years ago
  Can you trigger on scalar fields in the "other" tables?
  
  ------------------------------
  Mark Shnier (Your Quickbase Coach)
  mark.shnier@gmail.com
  ------------------------------
- EzraTorres
  Qrew Member
  2 years ago
  You can try triggering on those other tables, especially if they're related. For example, I have a pipeline that when the child status is updated to 'complete', the pipeline is triggered to check if all child records for that parent are 'complete', and if so run some further automation to update the parent record.
  
  ------------------------------
  Ezra Torres
  ------------------------------