Skip to main content

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!

Hi @Elearning, welcome to the Community! 👋

Perhaps you could combine multiple IF formulas directly in the Google Sheets action instead? I’m thinking you could have the Zap trigger when a checkbox in a specific column is updated and then in another column you would display the relevant titles and text using IF formulas to check which checkboxes have been checked and output the corresponding titles and text accordingly.

We have a guide that explains how to combine multiple IF formulas in a Formatter action but you could follow a similar approach and add the formula directly into the relevant field in your Google Sheets action:


Do you th​​​ink that would work for your needs here? 


HI @SamB ,

 

Thanks for taking the time to reply.

 

Unfortunately, i have tried inserting a formula on google sheet before but zapier views formulas as occupied rows and will send form inputs into the next line.

 

I actually found the solution here 

 


Thanks for letting me know @Elearning. I’m so glad you were able to get this solved! 🎉 

Really appreciate you following up here to share a link to the solution you implemented. This will be super helpful to others in the Community here that come across your post! 🤗

Seems like you’re all set for now but please do reach back out to the Community if you’re in need of any further help in future. Until then, happy Zapping! 


Reply