Hello!
I have a Typeform that is connected to an Airtable base.
There is one question that in the Typeform that is a multiselct (the user can pick more than one option).
When it translates to the Airtable multiselect field (the field is call "Select Dates"), it comes through as a massive long option that is super hard to read:
![Screenshot 2023-01-19 at 9.13.47 AM.png Screenshot 2023-01-19 at 9.13.47 AM.png](/t5/image/serverpage/image-id/24653i27B6E0055055D1BD/image-size/large?v=v2&px=999)
YIKES - I am wondering if there is a formula that can separate this out into distinct values, such as -
- Tuesday: February 28th at 12p PT / 3p ET
- Wednesday, February 15th at 10a PT / 1p ET
- Thursday February 9th at 11a PT / 2p ET
- Tuesday, February 14th at 10a PT / 1p ET
- Thursday February 9th at 11a PT / 2p ET
- Tuesday, February 14th at 10a PT / 1p ET
(there are also duplicates in there.... but thats not the worst thing / I don't mind... )
My plan is to then take the output of that formula and use an automation to re-submit the cleaned up values into the multi-select field named "Select Dates" in Airtable.
The formula seems easy enough... but I can't figure it out! Any suggestions would be greatly appreciated!