About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

So How do I enter checkbox from Google sheets into Google docs template field?

  • 17 December 2022
  • 8 replies
  • 565 views
N

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?

icon

Best answer by franimal 21 December 2022, 20:00

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

8 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Nabeelan 

Good question.

Please post detailed screenshots with how your Zap steps are configured in order for us to have more context, thanks.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
N

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”.

 

Troy Tessalone
Userlevel 7
Badge +14

@Nabeelan 

Try using a Formatter > Utilities > Lookup Table to translate the values: https://zapier.com/help/create/format/create-lookup-tables-in-zaps

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
N

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

 

nicksimard
Userlevel 7
Badge +11

Hey @Nabeelan!

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!

N

Thanks Nick for taking interest. Ideally it would be something like this.

 

franimal
Userlevel 3
Badge +3

Hey @Nabeelan  - Here’s one thing you might want to try! So I did a little digging and here’s what I came up with..

 

First, get the checkbox you want from special characters, and copy it 

 


(view larger)

 

Then, go to your tools - preferences menu at the top of your Doc


(view larger)

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. 


(view larger)


(view larger)

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! 

N

Thanks and much appreciated for your answer and detailed explanation 😀.

Terms & Conditions