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 )
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!