Query String to populate form

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

Find more posts tagged with

Formulas

Accepted answers

All comments

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?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.