I just solved a similar issue with a less elegant, brute force method. Here is the ERD of my issue.
The Formula Date field in the parent table changes based upon dates put into the child tables. There is a heirarchial logic as well going left to right across the child tables. So I put a text field in the parent table and have Pipelines in the child tables that clears and then writes to the text field at the top.
Now I have a change in the parent record from which I can control what should happen next.
------------------------------
Don Larson
------------------------------
Original Message:
Sent: 02-10-2023 20:59
From: Prashant Maheshwari
Subject: Is it possible to trigger a Pipeline when a formula field changes on record update?
Thanks Simon , love the clean approach !
------------------------------
Prashant Maheshwari
Original Message:
Sent: 02-10-2023 11:03
From: Simon H
Subject: Is it possible to trigger a Pipeline when a formula field changes on record update?
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
Original Message:
Sent: 02-06-2023 16:19
From: Jim Harrison
Subject: Is it possible to trigger a Pipeline when a formula field changes on record update?
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
Original Message:
Sent: 02-06-2023 15:25
From: Michael Tamoush
Subject: Is it possible to trigger a Pipeline when a formula field changes on record update?
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
Original Message:
Sent: 02-06-2023 14:33
From: Jim Harrison
Subject: Is it possible to trigger a Pipeline when a formula field changes on record update?
Yeah, it took me a couple years to think about it myself.
------------------------------
Jim Harrison
transparency = knowledge + understanding : The Scrum Dudes
Original Message:
Sent: 02-06-2023 12:20
From: Prashant Maheshwari
Subject: Is it possible to trigger a Pipeline when a formula field changes on record update?
Jim ! This is something I never thought about !
------------------------------
Prashant Maheshwari
Original Message:
Sent: 02-06-2023 09:46
From: Jim Harrison
Subject: Is it possible to trigger a Pipeline when a formula field changes on record update?
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
Original Message:
Sent: 02-03-2023 17:29
From: Matt Makris
Subject: 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
------------------------------