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 triggeri...
Pipelines
JimHarrison's avatar
JimHarrison
Qrew Champion
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 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
    ------------------------------
    • MichaelTamoush's avatar
      MichaelTamoush
      Qrew Captain
      2 years ago
      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
      ------------------------------
      • JimHarrison's avatar
        JimHarrison
        Qrew Champion
        2 years ago

        Table where you make the Webhook:
        https://domain.quickbase.com/db/<webhook table>?a=GenWebhookEdit&id=<webhook id>

        Do your filters:

        Endpoint URL:
        put the table dbid you want to check the box

        https://domain.quickbase.com/db/<check box table>

        Message header:
        QuickBase-Action : API_ImportFromCSV


        Message Body:
        <qdbapi>
        <usertoken></usertoken>
        <apptoken></apptoken>
        <records_csv>
        <![CDATA[
        %RepeatOn%
        [Record ID#],"yes"
        %RepeatOff%
        ]]>
        </records_csv>
        <clist>3.<field id of check box field></clist>
        </qdbapi>



        ------------------------------
        Jim Harrison
        transparency = knowledge + understanding : The Scrum Dudes
        ------------------------------