Jan 20, 2018 08:21 PM
I have a form on my website that collects responses on a checkbox question with 6 responses. Because it’s a checkbox, I can get from 0 to 6 different responses. Some entries have one choice, some have three, others have all six. The problem I’m having is when I zap into the multi select field of any of the checkboxes have no value, I end up with blank options imported into the multi select field. I’d love to know if anyone has a better solution for me here.
Jan 22, 2018 12:35 AM
Try using conditions with your Zap to check if a field is empty…
Another solution would involve you to use the Airtable API for populating your base with the values of your forms.
Jan 22, 2018 06:03 AM
Hi Chris
You could probably use the Formatter option in Zapier to remove the blanks before sending them to Airtable - this depends, of course, on how your forms app supplies the checkbox values to Zapier in the first place.