Query String to populate form

Becky Wilson

I have a query string I am using to auto-populate a form. It works great until the cell has multiple values.

Here is the query string:

="https://app.smartsheet.com/b/form/611a48e1b24d445eb48e373c9e06e1fd?Internal%20Course=" + SUBSTITUTE([Course Name]@row, " ", "%20") + "&Course%20Start%20Date=" + SUBSTITUTE(Date@row, " ", "%20") + "&Time=" + SUBSTITUTE(Hours@row, " ", "%20") + "&Instructor=" + SUBSTITUTE(Instructor@row, " ", "%20") + "&CTC%20Host=" + SUBSTITUTE([CTC Host]@row, " ", "%20") + "&Remote%20Attendance%20Supported=" + SUBSTITUTE([Remote Attendance Supported]@row, " ", "%20") + "&Location=" + SUBSTITUTE(Location@row, " ", "%20")

Both the Instructor and Location columns can have more than one value. Instructor column is a Contact List. Location is a drop down list.

Thanks

Jeff Reisman

@Becky Wilson

To populate a multi-select column from a form URL query, you need to list each value separately. For instance, if you have a Names column, and want to populate it with 3 names, you would need to do it like this in the query string:

https://app.smartsheet.com/b/form/{formID}?Names=Jeff&Names=Andrew&Names=Jill

Becky Wilson

Thanks Jeff, unfortunately the names are dynamic it would require me to update this for each line rather than have it be a column formula. Any suggestions on how to get it to pick up both names without specifying the name?