Query String to populate form

Options

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

Tags:

Answers

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    edited 01/30/23
    Options

    @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


    Regards,

    Jeff Reisman

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

  • Becky Wilson
    Becky Wilson ✭✭✭✭✭
    Options

    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?