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.
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.
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.