![find and replace airtable records zapier find and replace airtable records zapier](https://cdn.airtable.document360.io/d0ee2ee4-3f78-47c7-b388-85e40be9fb89/Images/Documentation/ABA39194E6D007056F7CE6B037E127DB5D3BCBC829072BB46E0790F58393D2EA1608563308181Step2optionbsingleselect.png)
This post is sort of my 5 cents on one of many reasons why I don’t use Zapier with Airtable … (even after discounting the differences between the design and sophistication between the two solutions)… because the survey that Airtable recently sent didn’t provide a space to express any suggestions or ideas, and instrad it was perhaps to use the responses to it as customer success stories for their marketing department or something like that. Most my workflows are in Integromat except for a few in Zapier and Automate.io. with Google Drive Zapier doesn’t refresh the list of folders or it doesn’t add extension to files being uploaded etc.I didn’t see any issue with Integromat so I assume it’s only Zapier specific. There 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. What I cant figure out is how to delete (or change the record status to deleted) if I remove a variant from the list. Im using Zapier to loop through the list and create separate records in another table with the product information and variant selected. 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. I have a table with some products and a field with a list of variants.
![find and replace airtable records zapier find and replace airtable records zapier](https://uploads-us-west-2.insided.com/zapier-ca/attachment/31ec1732-2227-403f-add9-a4379741a04a_thumb.png)
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).
![find and replace airtable records zapier find and replace airtable records zapier](https://d33v4339jhl8k0.cloudfront.net/docs/assets/588bba722c7d3a784630623a/images/5d0bc9be0428637fd7c53ad4/file-Gccay3oFdJ.png)
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). Returning "True" or "False" will work just fine.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. I actually don't care if the phone number itself is returned.Airtable doesn't seem to support ISNUMBER so that will have to be removed.Here are some modifications/things I know that need to change:
![find and replace airtable records zapier find and replace airtable records zapier](https://images.ctfassets.net/lzny33ho1g45/1A4qJQsKZIfaiBp5STwiQO/6a462c67774270147df252dda9f2a8f7/send-emails-for-airtable-records-01_.png)
=IF(ISNUMMBER(SEARCH( ,"False")īasically, what I want to happen is for the search formula to look at a comma-separated list of phone numbers, see if the phone number from Ring Central is in that list and if so, return the number. Here is the formula in textual format if you want to play with it: Forewarning, I'm terrible with crafting formulas! These are text strings and not linked records as I know linked records are identified by ID. I am working on a Zap and trying to use a search formula to be able to find a phone number when there are multiple phone numbers in a cell.