4/9/2024 0 Comments Airtable field update zapierThere are other issues with Zapier unrelated to Airtable e.g. Because if I am configuring a flow in Zapier and it’s just a copy of another workflow and I know it’s working, I don’t need to go through the steps of testing it with the data, because I know it’s working, so it should be just sufficient to run the test with the field whether there is any data in it or not. I would suggest Zapier makes similar change - show all (and only un-hidden) fields in the list in the action step and show the fields regardless whether that particular field has data in the record or doesn’t. Update a record in Integromat) much faster than before when it was showing list of all fields in existence in the Airtable table. This change made loading of the final Airtable step (e.g. Integromat in the recent update v 3 of their app for Airtable has limited the number of fields showing only to the ones that are not hidden. Then Zapier detected the changes in fields and started to show the updated list of fields.Īs I said, I would rather have Zapier show me in the Action step the complete and full list of fields I have configured in Airtable (at best perhaps show only the fields that are un-hidden, because if a field is hidden, I don’t need necessary to see it in the configuration step in Zapier). The way I found resolved the issue is to completely delete the test record with the data in the Airtable table and add a completely new record in the table. It’s strange, it looks like zap is cashing the airtable configuration or something and it doesn’t replace with fresh Artable data immediately.Īnd that happens even if I select the new set of data in the trigger step. That wouldn’t be such an issue, I can go and fill in some data.īUT the issue is even after adding that information into Airtable (and refreshing zap or even reloading it), the newly added fields are still not showing up in the zap action step and it can take sometime or maybe an hour or so for them to show up. I would rather prefer if it would show the fields whether it has some test data or not. If I am going through the process of setting up the zap and the Airtable table doesn’t have any appropriate data in it (…it usually happens if I miss to add some data in the table or it’s not in a view it should be…) then Zapier will not show the Airtable fields as existing (in the action step). It’s only been tested a few times - but it works like a charm … i’ll work a bit more on the triggering side of things… I’m only learning a bit of SQL currently - so I’m pretty sure you can get them two queries in one where you get data from two tables.One thing I find is an issue with Zapier is how it fails to refresh the test data while I am creating the zap workflow. The website’s database is updated :slightly_smiling_face: MYSQL = Find Row - Lookup value -> Meta ID from Step 5 MYSQL - Update Row -> meta id from STEP 5 // meta value from STEP 3 // Row -> Add search step and refer to step 6b // ID Column -> meta_idĦb. WHERE meta_key = “_sku” AND meta_value = “” AND meta_key = “technical_images” Ħa. WORDPRESS - Upload Media to Media Library SLACK - Test Trigger - Post “SKU” as message on a private slack channel (instant trigger)ĪIRTABLE - Find Record in Airtable - Looks up the SKU in right table Get you Wordpress MySQL db hooked up to zapier … this took a bit of time to figure out but after couple of quick exchanges with our hosting company all was good. Upon a trigger event, update the website’s MySQL db using Zapier.Ī. One of the most annoying things has been updating the technical images of the products to a better, newer version that might be uploaded to AT. We use Airtable to actually gather all the data with multiple stakeholders involved in the collection. We also use Advanced Custom Fields to manage special fields against products - including files. About 2k products overall, 50k “posts” including meta. Just a bit of background - we run a e-com website on wordpress. Don’t know if this is of any help to anyone - or if there something similar out there.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |