Jun 09, 2022 04:28 PM
Hi all! I’m conducting a survey that includes a multiple-select field. Has anyone devised a formula or some other clever way to transform multiple-select data into single-select fields (toy example below). I came up with a way of doing it in Excel and then pasting it back into Airtable, but I’m wondering if there is a more elegant approach (other than having the fields be single-select to start out with, which makes for a sub-optimal survey experience). Thanks!
Jun 09, 2022 04:45 PM
Is this something you will regularly need to do, or just once when you import your data?
Jun 09, 2022 04:49 PM
I only need to do it once for each survey response, but there are a lot of responses and they will be coming in over a long time period during which I’d like to keep the second table updated.
For context, the purpose of the second table is to be able to have a view of all the respondents grouped by A, B, and C. Grouping by the multiple select field puts each combination into a separate group.
Jun 09, 2022 06:04 PM
Hmm… I’m sure that @Kamille_Parks will come up with a clever solution for this, but I use Make.com for everything, so that’s what I would personally use for this.
When a new record is created, I would have a Make scenario loop through the array of multi-select options, and then create individual records in your junction table for each unique combination of name & option.
In Make, it could be setup as simply as this, but there are other ways of setting this up as well:
This is what the iterator module would look like — this is how you loop through the multi-select field:
Jun 09, 2022 06:25 PM
@Kamille_Parks And here I was so sure that if you posted, you’d recommend having a two table system.
Jun 10, 2022 09:08 AM
That is normally my MO, but my thinking here was that if this is just a one -time data import its probably just one table. If you regularly need to split the records apart it would be a two-table setup.