Populate a Form Field depending on a URL

Aloha AAHA

Hi,

I'm not sure if this is possible. We have a website with a list of all our technical documentation. There was an idea, to have a link next to each document, where if they click on that link it will take them to our Smartsheet form to suggest a change. We have a generic form at the moment, with a dropdown list of "some" of the documents (there may be hundreds if we add them all).

The question is: Is there a way to modify a URL to a Smartsheet Form so that it automatically populates a form field with a default value depending on the URL selected?

For example, the user clicks the URL next to "Document A", and the form will already populate the form field "Document Name" with the value "Document A" and so on and so forth.

The only way I can even think to make this a reality would be to create a separate form for each document (hundreds of forms?), where that form field is hidden with a default value of that exact document name. That doesn't sound like a best practice.

However, if someone knows a good workaround, that would be one way to make it easier for the end user to request a change to a specific document, without asking them to find it in a long drop-down list, etc.

Thank you.

Andrée Starå

Hi @Aloha AAHA

I hope you're well and safe!

Yes, it's possible using the URL-Query feature.

More info:

https://help.smartsheet.com/articles/2478871-url-query-string-form-default-values

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Aloha AAHA

I hope you're well and safe!

Yes, it's possible using the URL-Query feature.

More info:

https://help.smartsheet.com/articles/2478871-url-query-string-form-default-values

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Aloha AAHA

Hello Andree!

Yes, this is exactly what I was looking for and turned what had been a very horrible, no-good day into one ending on a high note. Thank you very much for the quick response!

Regards,

AAHA😁

Andrée Starå

@Aloha AAHA

Excellent!

You're more than welcome!

KCI

Is there a limit to the number of parameters or characters in the url string?

Andrée Starå

Hi @KCI

I hope you're well and safe!

I don't know, but I guess it's 4000 characters, including spaces.

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!