Skip to main content
Question

multiple dates on one record - show as seperate record

  • March 9, 2026
  • 1 reply
  • 12 views
kieran_themotscharity
Forum|alt.badge.img+1

Hi!

I am looking for a workaround, where I can turn a single record with multiple dates into separate records with a single date… new records are created via FillOut. 
 

we’re a charity delivering some programmes over multi week periods. An employee completes the fill out form, puts the dates they’d like us to deliver the programme on, and then submits the form.

 

i can view all these dates via calendar view, but was hoping to view them via list view also but as they’re individual records it won’t work this way.

 

sorry this probably isn’t making much sense but hoping someone will understand where I’m coming from…

thanks!

    1 reply

    TheTimeSavingCo
    Forum|alt.badge.img+31

    Hmm, could you provide a screenshot of the data from the submission?  How we tackle this depends heavily on how your data’s formatted I’m afraid!

     

    Assuming you’ve got multiple date fields, you could try using a formula field to concatenate them into a unique value for each date and then using an automation to paste it into a linked field to another table

     

    This creates one unique record per date for that program, and I’ve set it up here for you to check out!

    And here’s the formula:

    IF(
      AND({Program name}, {Date 1}),
      {Program name} & "|" & 
      {Date 1}
    )
    & 
    IF(
      AND({Program name}, {Date 2}),
      ',' & {Program name} & "|" & {Date 2}
    )

     

    Adam, Airtable Consultant - thetimesaving.company
    Terms & ConditionsAccessibility statement