Hi everyone,
I'm currently working on integrating a Webflow form with Google Sheets via Zapier, and I'm running into a bit of an issue with how the data from checkboxes and text fields is being recorded.
Here's the setup:
- 1 question of my form contains several checkboxes that users can select, as well as two text fields for additional input.
- In Google Sheets, I want the titles of the checkboxes that are marked "True" to be combined into a single cell, along with any input from the text fields, separated by a "-".
The problem:
- Zapier sends "True" or "False" values for the checkboxes, but I need the actual titles of the selected checkboxes to be combined in the cell.
- Additionally, I want to include any text entered in the text fields within the same cell.
- I initially considered using a formula in Google Sheets to handle this, but placing formulas directly in the rows seems to cause Zapier to skip those rows, thinking they're occupied.
What I've tried:
- I explored using the Formatter by Zapier to combine text, but I'm struggling to set it up in a way that only includes the checkbox titles marked "True" and skips the "False" ones.
- I’ve also thought about using Google Apps Script to automate this, but I’m not sure if that’s the best or simplest approach.
What I’m looking for:
- A straightforward method to dynamically combine these values (checkbox titles marked "True" and text field inputs) into a single cell when Zapier updates Google Sheets.
- Ideally, a solution that doesn’t involve skipping rows or overly complicating the data flow between Zapier and Google Sheets.
Has anyone tackled something similar or could suggest an effective way to achieve this?
Thanks in advance for any advice or pointers!