I’m using Zapier to send survey responses from Alchemer to Airtable. To help with filtering in Airtable, I match each survey question type to the corresponding field/column type in Airtable; so a likert scale (or other radio button question) is mapped to a single-select field, a checkbox question is mapped to a multi-select field/column, and open-text questions are mapped to single/long text field/column types. My survey makes heavy use of ‘Other - write in’ fields, especially in the context of multi-select (checkbox) questions. Commas are often included in these write-in fields, either by survey respondents or by Alchemer in how it formats data. However, either Airtable or Zapier (I’m not sure how to tell which) appears to be seeing the commas and using them to break apart individual responses into smaller pieces that then get entered into Airtable incorrectly.
For example, if someone writes in “Planes, trains, and automobiles” into the “Other - write in” option of a checkbox question, instead of the response “Other - write in, Planes, trains, and automobiles” getting piped into Airtable as a complete, single response, it instead gets piped in as “Other - write in” “Planes” “trains” “and automobiles” all as different individual entries within the same cell. As you can imagine, breaking apart the responses like this is causing a lot of problems in being able to read and filter responses in Airtable, and is creating a bloated list of options within a given multi-select field.
Desperate to see if anyone has any ideas on how to fix this, so thank you all in advance for any insights into the problem!