#Zapier airtable linked record how to
#Zapier airtable linked record update

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.

#Zapier airtable linked record update

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 have tried adding a step in Zapier that identifies the correct record in Airtable based on the ID before sending the record to Airtable, but I still have to link the tables via the Class Title because that is the primary field in the “Classes” table, so it just defaults to linking to the October class.I am struggling with a challenge that I would love your help with!

#Zapier airtable linked record how to

I have made a new hidden field in the Webflow form embed that passes this class slug/Airtable ID through Zapier and onto Airtable, however, I cannot figure out how to link a new class registration to a class from the “Classes” table IF the airtable ID from the form matches the Airtable ID from the record. I am thinking I am going to need to find someway to use the Airtable record ID to clarify which class to link to, as the CMS slug for each class in Webflow is that classes Airtable ID.

When someone tries to register for the August class, the class title is passed through through Zapier and onto Airtable, but the linked record field in the “Class Registrants” table is linking to the class in OCTOBER instead of the class in August, so the member is getting the wrong dates and information in the automated confirmation email. One class is in August and one is in October. This build and setup has been working fantastically so far, but I just ran into the error this morning with two classes that identical class titles (which is the primary field in the “Classes” table). This Class Title is automatically entered into a Linked Record field in the “Registrants” table that is connected to the “Classes” table, so the class title pulled from the form matches the class title in the “Classes” table and all the relevant information for the class is gathered as lookup fields to be used for an automated registration confirmed email. Each form has an html embed that pulls the Class Title from the CMS as a hidden field and passes it to Zapier and Airtable. The member enters their name and email through the form, which is then passed through Zapier and on to a “Class Registrants” table in Airtable. Each class is created in Airtable in our “Classes” table and published to our site via Zapier. We have a membership website built in Webflow where members can sign up for classes via a form on each class’s CMS page. If anyone has advice it’d be much appreciated. Having an issue with trying to link records conditionally with Webflow and Zapier integrated. This has been making my brain ache today.