Form not auto populating fields if one column cell contains a comma

jdswift

I'm using a form that when triggered, populates several fields from a source sheet then posts to a another sheet. I've noticed that if the column titled "Description" has a comma in the text of a cell, such as image 1 below, then the form will not auto populate all of the fields that I want. It will also stop populating the text from the description column at the comma. I assume SmartSheet must treat a comma in text as a stop, is that correct? Even if that is so, I'm curious why it doesn't populate all fields that are sourced from other columns if one cell has a comma in its text.

Below are some images for an example. In Image 1, the top cell has a comma after "In Workday". When I trigger my form and it opens to display several fields that should auto populate we see that Tester Name, Scenario ID, and Functional Area are not populated (image 2). If I remove the comma from the text in image 1, then trigger the form again, we see that Tester Name, Scenario ID, and Functional Area auto populated as expected (image 3).

What is going on here?

Image 1:

Image 2:

Image 3:

jmyzk_cloudsmart_jp

Hi @jdswift

Use URL percent-encoding to include a space or other special character like "," in your URL.

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

Include special characters in the query string
If you want to include a space or other special character in your URL, you need to use URL percent encoding. The following table includes a few common special characters you can use and their percent encoding values. These characters are also known as escape characters.

Character space	%20

Comma (,)	%2C

In the demo sheet below, I used the SUBSTITUTE function to replace them.

[UpdateFormLink]

=FormURL# + SUBSTITUTE(SUBSTITUTE("?Task=" + Task@row + "&Assignee=" + Assignee@row + "&Tester Name=" + [Tester Name]@row + "&Scenario ID=" + [Scenario ID]@row + "&Test Scenario=" + [Test Scenario]@row + "&Functional Area=" + [Functional Area]@row + "&Description=" + Description@row, " ", "%20"), ",", "%2C")

https://app.smartsheet.com/b/publish?EQBCT=ae86126642b84094a9b19b8ce75a8948