Hi all, I use an airtable formula to calculate product prices. I want to use Zapier to automate the process of updating prices on my website when changes are made to prices.
As I understand, Zapier wants to use the a "Last Modified Time" field as the reference to know when to trigger the action. The problem I'm having is that I'm not finding a way to point the "Last Modified Time" field at the calculated price field because AFAIK that field cannot monitor computed fields.
The airtable documentation recommends pointing the "Last Modified Time" field at one of the editable fields used in the computed fields. This doesn't resolve my issue because Zapier seems to want to pull the value from the field being watched by the "Last Modified Time" field, not the computed field that I need it to.
After consulting the airtable documentation I'm starting to be convinced that the workflow I have in mind is not possible (I would be happy to be wrong about that). So I'm wondering if anyone has some experience and/or recommendations about how I can accomplish this workflow.
You mentioned Zapier, and while Zapier does offer webhooks, I would highly recommend taking a look at Make’s webhooks instead.
Make is cheaper, more powerful, and more customizable than Zapier, and it also offers custom webhook responses if you ever want to have someone click on a button in Airtable and see a response in a new web browser tab.