Forum Discussion

MattMakris's avatar
MattMakris
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 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
------------------------------
Pipelines

18 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    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's avatar
      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's avatar
        MarkShnier__You
        Qrew #1 Challenger
        2 years ago
        Can you trigger on scalar fields in the "other" tables?

        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------
  • PrashantMaheshw's avatar
    PrashantMaheshw
    Qrew Assistant Captain
    2 years ago
    I do something simlar on formula field but pipelines are run on a scheudle instead (every hour)

    ------------------------------
    Prashant Maheshwari
    ------------------------------
    • AustinK's avatar
      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's avatar
    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's avatar
      PrashantMaheshw
      Qrew Assistant Captain
      2 years ago
      Jim ! This is something I never thought about !

      ------------------------------
      Prashant Maheshwari
      ------------------------------
      • JimHarrison's avatar
        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
        ------------------------------