Query String to pre-fill a form
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.
Best Answer
-
You would wrap the whole thing in a SUBSTITUTE function.
=SUBSTITUTE(JOIN(..........), " ", "%20")
Answers
-
You will need to SUBSTITUTE out the spaces with "%20".
-
Thank you Paul for the quick response. Can I do that within this formula or should I create a helper column to do it?
-
You would wrap the whole thing in a SUBSTITUTE function.
=SUBSTITUTE(JOIN(..........), " ", "%20")
-
As always, super instructive. Thank you.
-
Happy to help. 👍️