This post was split from the topic: How do I copy multiple record IDs from Zapier Tables into a new Spreadsheet template as new rows?
Thank you! Please can you advise what formula should go in this section?
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/a5d82c1c-6d85-4576-a95b-98fb16c2f135.png)
This post was split from the topic: How do I copy multiple record IDs from Zapier Tables into a new Spreadsheet template as new rows?
Thank you! Please can you advise what formula should go in this section?
Hi
Are you wanting to perform a similar search to the one asked about in the other topic? E.g. looking to search for all matches of a word in a specific field?
If so, then I’d have thought you could just set the Search by Field field to the relevant field in Airtable that would potentially contain the word. Then in the Search Value field you’d select the field from the trigger step that contains the word you want the Zap to search for and just leave the Search Formula field blank.
But if you’re looking to do a more complex search you can find out more about how to write a search formula here: Airtable > Write a search formula
Looking forward to hearing from you on this!
Hi! It is still not removing lines which are deleted from the google sheet. Should there be another step added? Successfully adding new lines or updating existing, but not removing those deleted.
Thanks for getting back to me
If so, there’s no “Deleted Row” trigger available for Google Sheets which would be ideal for this. But there is an existing feature request open for that to be added, so please confirm if that’s something you’re interested in using and I’ll get your vote added to that right away!
That said, I did come across a workaround for triggering on deleted spreadsheet rows that’s outlined here:
Essentially you’d add a column to the spreadsheet which has two options “Active” and “Delete”. Then when you select the Delete option for a row, the Zap will trigger, allowing it to run a Delete Spreadsheet Row (Google Sheets) action to remove that row. And you’d use a filter to make sure the Zap only continued if the column was set to “Delete”.
Then to remove the record from Airtable, you’d need to follow that action up with a Find Record (Airtable) action to find the relevant record, and use an Update Record (Airtable) action to mark it as being deleted - perhaps by adding a new column field like the one added to the Google Sheets spreadsheet. Then in Airtable you could filter out the records that are marked as “deleted” from your view.
Hope that helps. If I’ve misunderstood or you run into any trouble in setting that up do let me know. 🙂
is there a way to set up a video with someone from Zapier to run through? Thank you!
I’m so sorry for missing your message here previously
We have access to Designated Technical Support services available for folks on our Professional (100,000+ tasks), Teams and Company plans. You can learn more and enquire about that service here: https://zapier.com/l/support-services
Alternatively, there are a number of certified Zapier experts that you could reach out to for more personalised, 1:1 assistance. You can view the full list of experts and get in touch with them here: https://zapier.com/experts
That said, if you can share some further details and screenshots showing where you’re currently getting stuck on this I’m happy to help further. Looking forward to hearing from you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.