Hi, our zap trigger is a form with a question that collects a number. Depending on the number, I need to convert it to text. For example:
If the number is 0–200, then produce the word “YES”
If the number is 200+, produce the word “NO”
How would I go about creating this?
Thanks!
Best answer by christina.d
Hey friends! I wanted to pop in and summarize some of the answers posted here!
Assuming there aren’t too many values we had a great suggestion here:
I’d recommend using the lookup table feature with the formatter tool! 🙂Here is a link to an article that walks through step by step how to set it up- https://zapier.com/help/create/format/create-lookup-tables-in-zaps.
In this particular case though Troy’s solution of:
may be the best route to go!
He also dropped some Javascript resources here:
https://www.w3schools.com/js/
I hope this helps!
Hey
+14Hi
Good question.
You can use a Zap with Paths or Filters: https://zapier.com/apps/filter/help
Hey
Thank you so much for taking the time to respond
Hi
Good question.
You can use a Zap with Paths or Filters: https://zapier.com/apps/filter/help
Thank you for the suggestion
Might another solution be a Zapier Code step that looks at the numbers range and depending on where the number falls, produce a string of text? (was hoping to avoid the code part)
+14I’m afraid the code solution may be the one here. Thanks for helping me work through this
+14Some JavaScript resources: https://www.w3schools.com/js/
ah I see! I’m glad Troy was able to help you find a solution using code! 🙂
+9Hey friends! I wanted to pop in and summarize some of the answers posted here!
Assuming there aren’t too many values we had a great suggestion here:
I’d recommend using the lookup table feature with the formatter tool! 🙂Here is a link to an article that walks through step by step how to set it up- https://zapier.com/help/create/format/create-lookup-tables-in-zaps.
In this particular case though Troy’s solution of:
may be the best route to go!
He also dropped some Javascript resources here:
https://www.w3schools.com/js/
I hope this helps!
Build and deploy automations from AI tools you already use. With Agentic Management, if anything breaks, the agent diagnoses the issue and proposes a fix.
Join us September 23rd, 2026 for a free, one-day virtual event with 30+ sessions on AI automation. Get live build-alongs, playbooks, and strategies to lead AI transformation at your organization.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
