zapier airtable update records multiple times

#ZAPIER AIRTABLE UPDATE RECORDS MULTIPLE TIMES CODE#

Then we pull the month and day from the rental date and combine them together. Var rentalDate = new Date(inputData.rentalDate) Next, we convert the rentalDate into an easy to read string. 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.

#ZAPIER AIRTABLE UPDATE RECORDS MULTIPLE TIMES CODE#

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.

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: 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. I am struggling with a challenge that I would love your help with!

Zapier airtable update records multiple times