Here are some of the business-critical workflows that people automate with Zapier. With Zapier, you can integrate everything from basic data entry to end-to-end processes. However, Zapier appears to be seeing the commas and using them to break apart individual responses into smaller pieces that then get entered into Airtable incorrectly.įor 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.Īs 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. Connect Field Service Management Powered by GPS Insight and Airtable to integrate crucial parts of your business. Commas are often included in these write-in fields, either by survey respondents or by Alchemer in how it formats data. My survey makes heavy use of ‘Other - write in’ fields, especially in the context of multi-select (checkbox) questions. Some entries have one choice, some have three, others have all six. Because it’s a checkbox, I can get from 0 to 6 different responses. To help with filtering in Airtable, I match each 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. 08:21 PM I have a form on my website that collects responses on a checkbox question with 6 responses. Zapiers automation tools make it easy to connect Mailparser and Airtable. Then create events, notifications, or tasks directly from Airtable entries. Collect information from your app or tool of choice and automatically store it in Airtable. Here are some of the business-critical workflows that people automate with Zapier. Airtable combines the ease of a spreadsheet with the power of a database, and with the help of Zapier, you can instantly put your data to work. I’m using Zapier to send survey responses from Alchemer to Airtable. Set up the Mailparser trigger, and make magic happen automatically in Airtable. Connect Airtable and MySQL to integrate crucial parts of your business.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |