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------------------------------

Jim ! This is something I never thought about !------------------------------Prashant Maheshwari------------------------------

Oh my gosh the web hook idea to a check box is brilliant. I have spots where I have 4 child tables, thus 4 pipelines to trigger based on each one. Instead, I can have 4 webhooks, and only 1 pipeline! Dang, wish i thought of that years ago lol.------------------------------Michael Tamoush------------------------------

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------------------------------

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------------------------------

Can you trigger on scalar fields in the "other" tables?------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

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

MarkShnier__You
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
    ------------------------------
PrashantMaheshw
Qrew Captain
2 years ago
I do something simlar on formula field but pipelines are run on a scheudle instead (every hour)

------------------------------
Prashant Maheshwari
------------------------------
- AustinK
  Qrew Commander
  2 years ago
  This is the solution here. As long as you don't need it to instantly have a date just do it on a schedule. Then you search for records in the table with your formula field and when everything lines up and the formula field is checked it can input a date. Just make sure you do some error checking like making sure the date is blank first. This is the way I do triggers off formula fields too.
JimHarrison
Qrew Champion
2 years ago
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
------------------------------
- PrashantMaheshw
  Qrew Captain
  2 years ago
  Jim ! This is something I never thought about !
  
  ------------------------------
  Prashant Maheshwari
  ------------------------------
  - JimHarrison
    Qrew Champion
    2 years ago
    Yeah, it took me a couple years to think about it myself.
    
    ------------------------------
    Jim Harrison
    transparency = knowledge + understanding : The Scrum Dudes
    ------------------------------

Forum Discussion

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