Can a form be populated via URL from multi-line text?

jdswift

I have two sheets, one is titled "Test Scenarios", it's a sheet that contains steps to complete a test scenario, the other is titled "Test Issues", it collects testing issues submitted via form URL. When a test scenario fails, the user selects "failed" from a multi select box which causes a form URL to display. The URL contains the formula below to gather several pieces of information. See URL Form Image 1 attached.

If the description has a line break, i.e., someone has pressed ctrl+enter to start a new line (see Description Image 1 attached) Smartsheet will not read past the break. I understand that this is because Smartsheet treats this as a line break and stops. Is there a way to edit the formula to collect the entire description even if it contains a line break?

Description Image 1.png

FORM URL:

=IF([TestScenario Status]@row ="Failed", SUBSTITUTE("https://app.smartsheet.com/b/form/2ff5a32177d64308a5a6dd32ec7d206d?" +"Test Scenario=" + [Test Scenario]@row , " ", "%20") +SUBSTITUTE("&Functional%20Area=" + [FunctionalArea]@row , "", "%20") +SUBSTITUTE("&Test%20Scenario=" + [TestScenario]@row , "", "%20") +SUBSTITUTE("&Tester%20Name=" + Assignee@row , " ", "%20") +SUBSTITUTE("&Scenario%20ID=" + [ScenarioID]@row , "", "%20") +SUBSTITUTE("&Description=" + Description@row , " ", "%20"))

URL Form Image 1.png

Paul Newcome

You can save yourself a bit of typing by wrapping everything except for the base form url in a single SUBSTITUTE function instead of each field individually.

Also… The percent encoding for a line break is "%0D%0A" and the back-end value is CHAR(10), so you would use:

=IF([TestScenario Status]@row = "Failed", "base form url?" + SUBSTITUTE(SUBSTITUTE("Test Scenario =" + [Test Scenario]@row + "&Functional Area=" + FunctionalArea@row + "&Tester Name=" + Assignee@row + "&Scenario ID=" + ScenarioId@row + "&Description=" + Description@row, " ", "%20"), CHAR(10), "%0D%0A")

Here is a link to a post that may help. There is a link in that post there under #3 that should take you to a sheet that allows you to enter some basic data, and it will generate your formula for you.

https://community.smartsheet.com/discussion/142948/pre-filled-forms-using-url-queries-tips-and-tricks