Zapier and airtable4/23/2024 ![]() ![]() I want to use Zapier to automate the process of updating prices on my website when changes are made to prices.Īs I understand, Zapier wants to use the a "Last Modified Time" field as the reference to know when to trigger the action. This solves our problem of handling multiple attachments, and this means that each time we re-run our image generation, we'll have a new image to select from rather than losing all of our existing images.Hi all, I use an airtable formula to calculate product prices. ![]() When we return that back to Airtable, it will reattach all of the images rather than only one. This is because Zapier treats the collection of Image Url attachments it receives from the Airtable trigger similar to a comma-separated list. We can do this by specifying all the images we want to attach in the Image attachment field.Įven though we're only including two URL fields here, this will work even if you have multiple attachments already in Airtable. Our workaround is to tell Airtable that we want it to attach our new image but also attach the images it already has stored in the field. Why do we do this? By default, Airtable will replace anything in the Image attachment field when you pass it new attachments, rather than keeping the old images and adding a new one. Then click in the Image field, and select Image URL from your Airtable trigger step and Image URL from your OpenAI action step with no spaces between them. ![]() In the next dropdown, choose the option (Boolean) Is true.Ĭlick the Refresh fields button to load the fields from Airtable. Immediately after the New or Updated Record in Airtable trigger, add a new action step and choose the Built-in Filter tool on the right. To prevent the Zap from running in a loop or before we've added all the information we need to our Airtable row, we'll add a Filter action step based on the Generate checkbox field in Airtable. We need a way to filter it so our Zap only runs when we want it to. Each time our Zap sends an image back to Airtable, it's seen as an update to our record, which will cause the Zap to run again. It also means that we'll have an issue with infinite loops. This means it may trigger while we are adding new records, but before we've added all the information we want DALL♾ to use for our image. This Zap will trigger any time an Airtable record is updated. If everything looks correct with your test results, it's time to set up your action step. Here's what my completed base looks like: Finally, be sure to check the Generate checkbox (more on this later). Upload a sample image as an attachment to the Image field, which will simplify development of our Zap. Fill out your own details for the Blog Post and Image Description fields. For this article, I'm using an example food blog post, and the image description I provide asks for an image of a few spice bowls on a countertop. Last Modified Time (Needed for the Zap to work properly)įinally, add in a row with image details so we can test the Zap. Image Description as a Single Line Text Field From your Airtable dashboard, click Create a base on the bottom left. You'll also need an Airtable account, which you can sign up for at You'll also need to create a base in Airtable for your hero images, if you don't already have one. Before you beginīefore we begin developing our Zap, you'll need an OpenAI account if you don't already have one. This workflow requires a multi-step Zap, which is available on a paid Zapier plan or during a free trial. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |