Converting Incoming Form Data

I set up a Zapier to bring in from responses from 123Forms into Coda. However, the checkbox responses from the form are coming over as ‘yes’/‘no’. Is there a good way to convert these responses to proper ‘true’/‘false’ values for Coda?

I ended up having to create two columns for each incoming checkbox: One to bring in the raw data and another to convert it to a proper checkbox in Coda using If(thisRow.[ColumnName]='yes',true ,false )

Hey @ben_ross welcome to the community! Your technique will definitely work, however maybe consider using a Zapier Lookup Table to convert your yes/no to true/false.

In my experience, I’ve found handling / normalizing the data BEFORE it comes into Coda makes for a much better doc and experience. Good luck!

1 Like