Skip to main content

I have an Airtable that is populated from Jotform submissions. The Jotform has a configurable list that for someone to fill in their schedule for the week. The configurable list can’t be split in Jotform so I’m trying to split information in Airtable. I want all of the days of the week listed in the configurable list cell to be extracted in a Days Open column but can only figure out how to extract the first instance using regexextract. 

 

For example the configurable list will come in as:

Day Open: Monday, Opening Date: 2025-06-16, Closing Date: 2025-10-27, Start Time: 09:00 AM, End Time: 02:00 PM
Day Open: Saturday, Opening Date: 2025-08-09, Closing Date: 2025-08-30, Start Time: 10:00 AM, End Time: 04:00 PM 

and I want Monday, Saturday to show up in the days they are open. 

  1. If you want to stick with JotForm, the only way that you can do this without writing some sort of code is to use Make’s JotForm integrations alongside Make’s Airtable integrations.

    Check out my screenshot below for how you would set this up in Make.

    You’ll need to parse the JSON from JotForm’s configurable list widget, which will then break up the list into multiple “bundles” (i.e. records), so you can create multiple records in Airtable — one record for each bundle.

    If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you could instantly trigger a Make automation from Airtable.
     
  2. However, it is much easier & much simpler & much cheaper to leave JotForm altogether and do all of this with Fillout’s advanced forms for Airtable.

    That’s because Fillout communicates directly with Airtable and can easily do everything that you requested automatically.

    You simply need to setup Fillout to work with your linked record field in Airtable, and then when the form is submitted, each line is already broken up into separate records in Airtable.
     

    Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update existing Airtable records using a formcreate custom PDF files from a form submissionaccept payments on formspre-fetch dynamic data from an Airtable record, display Airtable lookup fields on forms, create new linked records on a formadd a login page to your form, perform math or other live calculations on your forms, collect signatures on a form, create multi-page forms with conditional paths, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.

    I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes — the 2nd video is directly related to what you’re looking to do:
    • Using Fillout to create an eSignature approval process with PDF file creation.
    • Using Fillout to create an order entry form with line items.

Hope this helps!

If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
 

 


Does this look right?

REGEX_REPLACE(
IF(FIND('Monday', Notes), 'Monday, ') &
IF(FIND('Tuesday', Notes), 'Tuesday, ') &
IF(FIND('Wednesday', Notes), 'Wednesday, ') &
IF(FIND('Thursday', Notes), 'Thursday, ') &
IF(FIND('Friday', Notes), 'Friday, ') &
IF(FIND('Saturday', Notes), 'Saturday, ') &
IF(FIND('Sunday', Notes), 'Sunday'),
'[,\\s]+$',
''
)

 


that’s the one! Worked perfectly thank you!