Query string is not working for multiple variables

Vera

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?

Paul Newcome

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")

Paul Newcome

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")

Vera

Perfect! It worked. Thank you so much for your help.

Paul Newcome

Happy to help. 👍️