I have a Zap with answers from Typeform falling into a Google Sheet. One question has 5 possible fixed answers which I’d like to be set as a TRUE in the Google Sheet.
So Typeform: “What are you most interested in:
Female
Male
Kids
Animals
Electronics”
Should fall into GSheet if chosen, as:
Interest_female: TRUE
Interest_male: TRUE
Interest_kids: TRUE
Interest_animals: TRUE
Interest_electronics: TRUE
How do I change the answer to TRUE?
Best answer by christina.dBest answer by christina.d
It looks like the answers from type form are coming in as ‘Im interested in animals’/’I am interested in electronics’/etc, is that correct? And in your Google Sheet, each column is one of the categories, yes? If so, then here is how you can change the text...
Add a Formatter by Zapier step before the Google Sheets step, choose Utilities > Lookup table. With a lookup table you can tell the Zap ‘if you see this, then use this text’. In this case, you’re saying ‘if you see “I am interested in animals”, write “TRUE”. You’ll need to have a line in the lookup table for each possible answer. If you haven’t used a Lookup table step before, I recommend reading this help guide to get you started.
Here’s a screenshot of what the table would look like:
In the Google Sheets step, you need to map the output of the Formatter step to the correct column in the sheet.
I just had to choose “Text” → “Replace” instead of “Utility” in the formatter and then everything worked out
Woohoo! So excited to hear you were able to get this sorted! Thanks for letting us know your end solution! 🤗
It looks like the answers from type form are coming in as ‘Im interested in animals’/’I am interested in electronics’/etc, is that correct? And in your Google Sheet, each column is one of the categories, yes? If so, then here is how you can change the text...
Add a Formatter by Zapier step before the Google Sheets step, choose Utilities > Lookup table. With a lookup table you can tell the Zap ‘if you see this, then use this text’. In this case, you’re saying ‘if you see “I am interested in animals”, write “TRUE”. You’ll need to have a line in the lookup table for each possible answer. If you haven’t used a Lookup table step before, I recommend reading this help guide to get you started.
Here’s a screenshot of what the table would look like:
In the Google Sheets step, you need to map the output of the Formatter step to the correct column in the sheet.
Will that work the way that you need it to? Let us know what you think!
Are you typing the full sentence in the Lookup Table? Did you include the FALSE answers? If not, Did you include FALSE as the Fallback Value? After finishing this step, did you click on Test And Review to check the output?
Please let me know if you need more help with this
It looks like the answers from type form are coming in as ‘Im interested in animals’/’I am interested in electronics’/etc, is that correct? And in your Google Sheet, each column is one of the categories, yes? If so, then here is how you can change the text...
Add a Formatter by Zapier step before the Google Sheets step, choose Utilities > Lookup table. With a lookup table you can tell the Zap ‘if you see this, then use this text’. In this case, you’re saying ‘if you see “I am interested in animals”, write “TRUE”. You’ll need to have a line in the lookup table for each possible answer. If you haven’t used a Lookup table step before, I recommend reading this help guide to get you started.
Here’s a screenshot of what the table would look like:
In the Google Sheets step, you need to map the output of the Formatter step to the correct column in the sheet.
I just had to choose “Text” → “Replace” instead of “Utility” in the formatter and then everything worked out
Woohoo! So excited to hear you were able to get this sorted! Thanks for letting us know your end solution! 🤗