Query string is not working for multiple variables

Vera
Vera ✭✭✭
edited 07/28/23 in Formulas and Functions

Hi,

I am trying to pre-populate a form with multiple variables. I am trying to use a formula with the query string (see below). Only the first variable shows up correctly on the form. It is not picking up on the other 2. What am I doing wrong?



Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    You need an & before each field name after the first and it looks like anything being populated after the initial field isn't having the special characters (in this case the space) percent encoded. Try this:


    ="form_url?" + SUBSTITUTE("Sales_Rep=" + [Sales_Rep]@row + "&Current_Career_Level=" + [Current_Career_Level]@row + "&Career_Level_Applying_For=" + [Career_Level_Applying_For]@row, " ", "%20")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!