Hey guys,
First time posting here :)
Short version: I want to display the data I get from the Webflow form onto a Google Spreadsheet.
Details:
So I have a Multi-Step Form in Webflow, where some of the slides have multiple checkboxes.
Now what I want is that when you select the checkboxes (blue), you get the value displayed in a Google Spreadsheet. I know that the Form works because I get an email when you submit the Form and the data is correct. I’ve also managed to get the data from Webflow into a Google spreadsheet using this setup.
The problem I’m experiencing is that the value of the checkboxes are displayed as “true & false”. This is just the way Webflow checkboxes work and I don’t think I can change that.
Obviously this is not ideal because in the Google spreadsheet it looks like this:
So is there a way I can Filter out the “true” values from the “false” values, AND then display the “true” values as they are displayed in the Form. So from the example above I’d get:
arrondissement: 7e, 14e, & Banlieue Proche. Instead of “false, true, false,”
I know I’d probably have to use Zapier “filter” and/or “formatter”
I’ve tried it out multiple times but I just can’t seem to figure it out…
I really hope this made sense and someone could help me out :)
Thanks!!