Query String to pre-fill a form

PeterLatcapital

I am attempting to use JOIN to build a query string and I am able to do it however if the column I join has spaces in the entry, the JOIN only attaches the first word until there is a space.

=JOIN([Join Column]@row:DlrName@row, "&DlrName=")

results with a query string but only the first word in the column DlrName. How do I add all the words in the column including the spaces. A Dlrname might be "Good Dealer Inc." and I want the full name so that my query string will pre-fill the full name in my form.

Paul Newcome

You would wrap the whole thing in a SUBSTITUTE function.

=SUBSTITUTE(JOIN(..........), " ", "%20")

Paul Newcome

You will need to SUBSTITUTE out the spaces with "%20".

https://help.smartsheet.com/articles/2478871-url-query-string-form-default-values?_ga=2.244265735.38509754.1684150566-264761218.1682960331&_gac=1.94979822.1681828141.CjwKCAjw__ihBhADEiwAXEazJiAT2-bV7FtQVCMBzzsMj1UEJDeWVdgQkHYOXqro_9ZUDzn6YJXN6hoCD6MQAvD_BwE&_gl=1*wl41g5*_ga*MjY0NzYxMjE4LjE2ODI5NjAzMzE.*_ga_ZYH7XNXMZK*MTY4NDMzNTg2Ny40Ni4xLjE2ODQzMzc2NTQuNjAuMC4w

PeterLatcapital

Thank you Paul for the quick response. Can I do that within this formula or should I create a helper column to do it?

Paul Newcome

You would wrap the whole thing in a SUBSTITUTE function.

=SUBSTITUTE(JOIN(..........), " ", "%20")

PeterLatcapital

As always, super instructive. Thank you.

Paul Newcome

Happy to help. 👍️