![find and replace airtable records zapier find and replace airtable records zapier](https://uploads-us-west-2.insided.com/zapier-ca/attachment/24c6d226-9c05-4f9a-bf55-0a260041b803.png)
Having screenshots from both tables in your Airtable would be really helpful to provide further guidance.įor now, here’s some Javascript to get you started :) // First, we convert the availableDates string from Airtable into an array.Ĭonst availableDates = (", ") Airtable’s API reference is actually fairly easy to grasp with some light programming knowledge. You can replace every step following the trigger with a single Code by Zapier step, including your Filter by Zapier step, each of your Filter by Zapier steps, and all of the various back and forth interactions with Airtable you’ll need to do. I have tried to thoroughly explain what I have done and the issue that I am facing, but please let me know if you have any questions! □Ĭode is definitely the way to go here. I am now well and truly stuck with this automation and the kind that I make a post here. Using Zapier’s spreadsheet function to look up the dress name in Table 2 and remove it from the Dates Available - i.e.This ended in disaster (see below screenshot): Using Javascript (which I have no experience in □) to try to remove the string from the array.I have added an additional column into Table 1 that contains a formula which adds the string description of the Dates Available, as these just appear as IDs in Zapier - which makes it hard to complete step 7 of my flow. You can see that the Dates Available column is a lookup column in another Table 2. Here is a screenshot of the Airtable Table 1 that I am interacting with in Zapier. This is where I am struggling for a solution :).I want to delete the Date string “Mar-23” from the Dates Available column, which contains multiple values, which I believe are contained in an Array: e.g.
![find and replace airtable records zapier find and replace airtable records zapier](https://uploads-us-west-2.insided.com/zapier-ca/attachment/64f494b1-2099-4b4b-9047-160a5ea10ffa.png)
Check if the Dates Available column in Airtable contains the Date string “Mar-23”.Action: combine the keyword and key number into a string, e.g.Action: pull out key numbers from the string, e.g 23.Action: pull out keywords from the string, e.g.Action: re-format the Date into a string, e.g.Action: Find the Record Name in Airtable that matches the Booqable Reserved Order Name.Here is an overview of the steps in the Rental Booking Automation Zap:
![find and replace airtable records zapier find and replace airtable records zapier](https://outfunnel.com/wp-content/uploads/2020/01/Airtable1.png)
The step that I am struggling with in this flow is step 3, which is where I need your help with this Zap. The dress’s availability is updated on Webflow so that the dress is no longer available for the booked period.The Zap triggers a sync between Airtable + Webflow’s CMS to update that dress’s availability.Booqable triggers a Zap which updates the dress’s availability in Airtable.The automation that I want to create will enable us to automatically update a dress’s rental period availability. The platform itself is built using the following: We use Zapier to automate a lot of our internal processes - and I am trying to setup a new automated process for a platform we are about to launch to help brides rent their perfect wedding dress.īrides will visit a marketplace where they can view dresses for rent, select a booking period and order the dress via our platform. I co-founded the business PS Bridal to help brides find their perfect wedding dress, for free. We don't need marketing automation as we have this all set up with Zapier and we use Sendy (a php mailer program) linked to a bunch of forms and landing pages.I am struggling with a challenge that I would love your help with! Any quotes, or system notes I feel comfortable adding via zapier.Be able to go down the list and call/email their client base My reps are difficult to get to add notes and I sometimes export lists to Sheets and have them Comment and Check off things but it's getting cumbersome. I guess what I am looking for is a simple CRM to just add notes. Zapier to automatically remind us of statuses like backorders, lapsed clients, etc.Zapier to automatically schedule Follow-ups in Google Tasks when my reps enter quotes in our Open Source shopping cart.What we do use right now is a comibination of a few things: Salesforce and Hubspot seem a bit out of our budget. We had Insightly before but it was honestly not good for us and product support was pretty bad (plus expensive).
![find and replace airtable records zapier find and replace airtable records zapier](https://www.bettnet.com/wp-content/uploads/2019/08/Screen-Shot-2019-08-29-at-12.05.51-PM.png)
I'm considering (again) Airtable for my 6 users.