Quick question that I can’t find an answer to:
Is there a limit to the number of If-Then-Else cases that can be used in a single computed column?
I’m creating a dropdown menu of 250 cities and don’t want to create 199 of them and then find out the limit is 200. 
Can you describe more about your use case? I feel like there’s something we can do here to not make you use an if-then-else with 250 conditions.
Hi, @ThinhDinh. I appreciate you getting back to me. I’m building out a workflow that starts with a form to collect 20 pieces of data, compiles the data into a custom query string, adds the string to a URL, then outputs the embedded data link via an action.
To avoid human error with manual entry of any data, the entire form is dropdown menus, radio buttons, etc. Part of the form is collecting address information and that’s where the dropdown list of 250 cities comes into play.
We would be using a computed ITE column to rewrite each city into the proper syntax for the query string (e.g., Phoenix becomes &City=Phoenix and Apache Junction becomes &City=Apache+Junction).
I’ll take any suggestions. Thx as always!
A massive IF statement with hard coded values is never a good idea, because it’s not easily scalable if and when you add more cities.
I think 1 or 2 template columns would do the same thing. One to replace space with + and one to add the query parameter text. Might be able to do it in one.
But in reality, I’d probably use just 1 template column to replace space with +, followed by a Construct URL column to properly build out the entire url with query parameters.
Hi, @Jeff_Hager. I really appreciate you making that suggestion — the Construct URL will definitely work and helps to simplify the table.
Plus, using it in conjunction with a Template column allows me to then remove the Construct’s default protocol of “https://” so the end user can still input the full URL that we’ll be using as the base for the query string.
As always, I’m thankful for fellow Gliders like yourself and your willingness to give of your time and expertise. Much appreciated! 