Jun 27, 2019 01:29 PM
Hey guys,
I am setting up some database automations. Basically right now, I create the invoice record after they respond to an email. But I would like to trigger it off of status change. Basically when status = accepted, I would like to create a new invoice record. Does anyone know how I could achieve this with Zapier or another way? I was thinking doing a webhook or something along those lines.
Jun 27, 2019 08:49 PM
Welcome to the community, @Target_Socially! :grinning_face_with_big_eyes: First, set up a new grid view in the table containing your status field, and filtering it based on that field, so that only records marked as “Accepted” appear.
In Zapier, make a new zap that begins with the Airtable “New Record in View” trigger, pointing it to that view you just made. The next step will be the Airtable action, making a new record with whatever properties you wish for your invoice. Zapier will ignore any existing “Accepted” records, only triggering when a new one is added to that view.
Jun 28, 2019 07:21 AM
Thank you for the welcome and thank you for the response!
Definitely was not thinking in those lines, but it makes total sense! I will give that a go!