Radio Button Pre-Supply

tknman0700

I have a smartsheet that uses a radio button for input. I want to make a selection on that radio button input using querystring but I cannot figure out how to do it. Can anyone give me any tips? I found this url but it does not deal with radio buttons.

Use a URL query string to prefill default values on a form | Smartsheet Learning Center

Thank you

KPH

Hi @tknman0700

At the end of the URL add ? (or & if you are already passing parameters).

Then the name of the radio button column. Use %20 if you have spaces in the name.

Then =

Then the value that you want to select.

In the example below, I have "Example Radio Button" as the first parameter at the end of the form URL (so I have ? rather than &)

The %20 are the spaces in the field name

Then =

Then the value to select, which is Bacon

tknman0700

Thank you - is it possible that a form can not support this? I dont want to share the URL public but I am not able to make it work. I suspect it may be not produced using a plan that supports this feature?

KPH

I believe query strings for URLs work on forms created using the following plans:

• Smartsheet
• Pro
• Business
• Enterprise

If you cannot get exactly what you want to work, try with something simple like a single word column heading and single word button, then you won't need to worry about the special characters.

Paul Newcome

It would look something along the lines of…

="https://……….form_url……….?" + SUBSTITUTE("Column Name=Default Selection", " ", "%20)

Or if you need it to be dynamic

="https://……….form_url……….?" + SUBSTITUTE("Column Name=" + [Column Name]@row, " ", "%20)

tknman0700

The problem is I didnt build the sheet - I dont have access to the column name because I can only see the Web form that its connected to.

Paul Newcome

Replace column names in my formula with field names.

tknman0700

ok thank you

Paul Newcome

Happy to help. 👍️