Hi @Jamie Reynolds 

Good question.

The screenshots from Airtable did not post, so please amend with those for context, thanks.

Add object brackets {} within the  array brackets e] like this:

output = t{array_3}]

TIP: You can save Zap Tasks by using 1 Code step instead of multiple Formatter steps.

Consider hiring a Zapier Expert to help with the Code: https://zapier.com/experts

Hi @Jamie Reynolds

Code is definitely the way to go here. 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. Airtable’s API reference is actually fairly easy to grasp with some light programming knowledge.

Having screenshots from both tables in your Airtable would be really helpful to provide further guidance.

For now, here’s some Javascript to get you started :)

// First, we convert the availableDates string from Airtable into an array.
const availableDates = inputData.availableDates.split(", ");


// Next, we convert the rentalDate into an easy to read string.
var rentalDate = new Date(inputData.rentalDate);
rentalDate = rentalDate.toString();


// Then we pull the month and day from the rental date and combine them together.
var rentalMonth = rentalDate.split(" ")e1]
var rentalDay = rentalDate.split(" ")e2]
var formattedDate = rentalMonth + "-" + rentalDay


// This loop determines whether the formattedDate is in your availableDates array.
// If there is a match, it removes it from the array.
// Otherwise, it does nothing, essentially mimicking your Filter by Zapier step.
for (var i = 0; i < availableDates.length; i++) {
  if (availableDatesai] == formattedDate) {
    // This code executes when the date is a match.
    availableDates.splice(i, 1);
    // Note: This does not automatically update your Airtable records.
    // You'll need to do that programatically by accessing Airtable's API.
    // Be sure to place all API calls above the word "break" below.
    // Assuming you do all data manipulation and API calls within this conditional statement, there will be no need for an output statement below, as you will simply update your Airtable base(s) from here.
    break;
  } else {
    //leave this blank to mimic the Filter by Zapier.
  }
}

Hey @Jamie Reynolds!

I think I’ve cracked it :)

Here’s the setup I’ve got for the part of the Zap up through updating Airtable, since that’s where you were stuck:

Trigger: Booqable
Action: Airtable — Find Record
Action: Formatter — Format Date (Into the Mar-23 format)
Action: Formatter — Lookup Table (“Convert” the date into the Record ID)
Action: Formatter — Replace  (In the field that returns all the record IDs of ‘months available’ search for the one from the Lookup Table step then replace it with nothing, which deletes it)
Action: Airtable — Update Record (map the field that now contains all the existing records minus the one that’s in the Booqable step)

Quick GIF Tour

NOTE: You’ll have to factor in the edge case where a dress has ONLY that one month in it, in which case Airtable requires exactly three spaces to be added in order to clear it.

One way to do this would be to add a Count field in Airtable, then you have two Zaps. One for when the Count is 1 and another for when the Count is greater than 1:

What I described above would be for greater than 1. When the count is 1, presumably the only month in there is the one you want to remove. You could add a Filter like this as well (after the date format step):

Whew, ok. Are you able to run with that to see if it works for your use case? Please let me know if you have any questions as you try this out :)

Hey everyone,

My apologies for my slow reply - I had a personal tragedy in January which took some time to recover from. 

I will be looking into this again in the coming days.

Thank you soooooo much for your help in advance

All the best,

Jamie