Skip to main content
Question

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

  • February 3, 2023
  • 0 replies
  • 647 views
MattMakris
Forum|alt.badge.img+7
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 triggering when the record is updated. These records are audits - when one is considered "complete" (the checkbox formula decides wether this is true or false), I need today's date/time to be written to a static text field.  

Any ideas here are appreciated, thanks!

------------------------------
Matt Makris
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
Forum|alt.badge.img+11
I do something simlar on formula field but pipelines are run on a scheudle instead (every hour)

------------------------------
Prashant Maheshwari
------------------------------
JimHarrison
Forum|alt.badge.img+18
  • JimHarrison
  • Registered
  • February 6, 2023
Quickbase needs the record to Save & Close. If the record change is on another table, a Webhook on the table where the Save & Close happens, writes to a check box on the table with the formula field.

------------------------------
Jim Harrison
transparency = knowledge + understanding : The Scrum Dudes
------------------------------
Terms & ConditionsAccessibility statement