I am fairly new to Airtable & Integromat/Make and am having a problem I cannot resolve. I have survey data that I am trying to import in Airtable. The problem is that when applicants select more than one option in a question, Airtable will either say “Cannot parse value” or will combine the select options and make a new select option:
As you can see in the above screenshot, it is combining values under the “Program Selection” column. I want it to separate the values “Humanities at Hertog” and “Summer Course.” But instead, it is either putting a comma between the values or just putting them together with no space. I want it to mimic the example of the separated values “Summer Courses” and “Advanced Institute” in the same column.
The weird thing is that in the “Alumni Program Type” column, I managed to separate the values of multiple selected options by using the following command in Make/Integromat
But it’s not working with “Program Selection.”
Anyone know how to resolve this issue?