Skip to main content
Solved

Formula to pull every day of the week in a cell

  • October 14, 2025
  • 3 replies
  • 46 views

Forum|alt.badge.img+2

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. 

Best answer by TheTimeSavingCo

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]+$',
''
)

 

3 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • 9808 replies
  • October 14, 2025
  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
 

 


TheTimeSavingCo
Forum|alt.badge.img+31
  • Brainy
  • 6450 replies
  • Answer
  • October 14, 2025

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]+$',
''
)

 


Forum|alt.badge.img+2
  • Author
  • New Participant
  • 1 reply
  • October 16, 2025

that’s the one! Worked perfectly thank you!