I have done data validation on Google forms response into checkboxes but when I enter this checkbox in Google doc template field, it is converted into the original unvalidated form. I have done some experimentation in formater but to no avail. So How do I enter checkbox from Google sheets into Google docs template field?
Answer
So How do I enter checkbox from Google sheets into Google docs template field?
- Beginner
Best answer by franimal
Hey
First, get the checkbox you want from special characters, and copy it
Then, go to your tools - preferences menu at the top of your Doc
then finally, under substitutions, paste the checkbox and choose a word that you would like to Docs to automatically replace with those boxes. In this case, I chose I agree/I disagree since those are what are coming from your form.
From there…you wouldn’t need the table! Unless the words “I agree” or “I disagree” appear elsewhere and you don’t want those boxes, in which case..you would need to update your lookup table to change those checkboxes into different words. Does that make sense?
Give that a try! Let me know if it works or you have any other questions!
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
Good question.
Please post detailed screenshots with how your Zap steps are configured in order for us to have more context, thanks.
- Beginner
Its simple Google forms/Google sheets to Google docs zap. I have validated responses of “I Agee” and “I Disagree” to checkbox ticked and unticked in Google sheets. When this data is pulled from Google sheets into my zap, it is original values of “I agree” or “I disagree”.
+14- Zapier Orchestrator & Solution Partner
Try using a Formatter > Utilities > Lookup Table to translate the values: https://zapier.com/help/create/format/create-lookup-tables-in-zaps
- Beginner
I tried it but what should I put in the lookup table to convert it into a value that can check the checkbox. Using special character in the lookup table looks like a passable solution but not a perfect one
+11- Zapier Staff
Hey
What are you trying to display in the Google Doc, depending on whether someone has agreed or not?
It might be helpful if we could see a screenshot of what you’d like the final Google Doc to look like. Thanks!
+3- Zapier Staff
- Answer
Hey
First, get the checkbox you want from special characters, and copy it
Then, go to your tools - preferences menu at the top of your Doc
then finally, under substitutions, paste the checkbox and choose a word that you would like to Docs to automatically replace with those boxes. In this case, I chose I agree/I disagree since those are what are coming from your form.
From there…you wouldn’t need the table! Unless the words “I agree” or “I disagree” appear elsewhere and you don’t want those boxes, in which case..you would need to update your lookup table to change those checkboxes into different words. Does that make sense?
Give that a try! Let me know if it works or you have any other questions!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.