Add Cell Data in a Custom Form URL

andycrim

Hi. I've created a form and want to create QR codes that, when scanned, pre-fills certain data (a session title, and speaker name). The Session Title and speaker name are in a different table (TABLE1) for which the form feeds (TABLE2).

The URL will ultimately resemble: https://app.smartsheet.com/b/form/XXXXXXXXX?Title=TITLE&Author=AUTHOR

I can't seem to get TITLE and AUTHOR to pull from TABLE 1 to display in the form for TABLE 2. Any ideas on how to get this information into the URL.

Thanks in advance!

Andrée Starå

Hi @andycrim

I hope you're well and safe!

You have to create a formula that creates the URL.

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to 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!

andycrim

Sorry...my screenshot skills are lacking...but here is a shot. The first is the form (for table 2). The second is Table1 where I want cells from columns 8 & 9 to pre-fill in the form for table 2. I knew it would be a formula, but not sure which function I should choose. Thank you!!

Jason Tarpinian

I think you may be getting stuck on the special characters, as defined on this help page:

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

You should be able to use the formula below for a helper column, and it will replace any/all special characters that can't be used in an HTML code. All you have to do is update the "Title@row" to the appropriate field name.

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Title@row, "%", "%25"), " ", "%20"), "=", "%3D"), "#", "%23"), "$", "%24"), "&", "%26"), "`", "%60"), ":", "%3A"), "<", "%3C"), ">", "%3E"), "[", "%5B"), "]", "%5D"), "{", "%7B"), "}", "%7D"), "+", "%2B"), "@", "%40"), "/", "%2F"), ";", "%3B"), "?", "%3F"), "^", "%5E"), "|", "%7C"), "~", "%7E"), "'", "%27"), ",", "%2C"), CHAR(34), "%22"), CHAR(92), "%5C")

Now, THIS is the field that you use to substitute into the form. So it would look something similar to this below. Where the values of the fields are using the substituted characters instead of the regular field name. You would also have to replace any special characters in the field name portion as well, but you don't need to do the formula for that as the field name is constant. For example, in the formula below, if instead of "Title" the field name was "Session Title", you would replace "?Title=" with "?Session%20Title="

=[Base Form Link]@row + "?Title=" + [Title (Sub)]@row + "&Author=" + [Author (Sub)]@row

Let me know if I'm way off the mark, but I've had that formula in my back pocket for a few builds I've done internally for my company and it looked like it fit here!