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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    You would wrap the whole thing in a SUBSTITUTE function.

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


    Come see me at ENGAGE 2023! I have "Happy to help 👍️" buttons!

    If you can't find me roaming the floor, I will most likely be at the 10xViz Partner Booth.