Forum Discussion

MattMakris's avatar
MattMakris
Qrew Assistant Captain
3 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
3 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
3 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
    3 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
    ------------------------------
    • PrashantMaheshw's avatar
      PrashantMaheshw
      Qrew Captain
      3 years ago
      Jim , 

      If I may request you for a small video recording of Webhook setup you've done , it would help all others(and me) who would come across this comment. 

      You can use loom (or any screen recording tool) or I can get on a zoom call with you and we can do it together. 

      Information on web hook and QuickBase is so very limited .

      ------------------------------
      Prashant Maheshwari
      ------------------------------
      • JimHarrison's avatar
        JimHarrison
        Qrew Champion
        3 years ago
        sent dm to Prashant.

        ------------------------------
        Jim Harrison
        transparency = knowledge + understanding : The Scrum Dudes
        ------------------------------
    • SimonH's avatar
      SimonH
      Qrew Cadet
      3 years ago

      I had a similar need where i wanted notifications on a parent record fired when child activity records where added.

      Checkbox wouldn't work as I needed something that could fire repeatedly. So used a date/time field and a webhook to set the parent "Last Touched" field to the child's date created time. Here is a screenshot of the webhook.

      The term "touched" is borrowed from the unix command to touch a file and update it's modified date



      ------------------------------
      Simon H
      ------------------------------
      • PrashantMaheshw's avatar
        PrashantMaheshw
        Qrew Captain
        3 years ago

        Thanks Simon , love the clean approach !



        ------------------------------
        Prashant Maheshwari
        ------------------------------