URL String Query for Column Type: Contact List

Hi Smartsheet,

I'm trying to help a few new users within my organization by prepopulating a couple fields in commonly used forms with the use of URL String Queries. So far I can seemingly prepopulate almost all fields in a form, but the hurdle I've come across is when the column type is a contact list.

The drop down values are intracompany and in the form read like this:

" Firstname Lastname (firstname.lastname@company.com) "

I'm not able to collect this data and push into a URL successfully.

I've found this link to be very helpful (https://help.smartsheet.com/articles/2478871-url-query-string-form-default-values?_gl=137mxsi_gcl_auMjkzNjMyODI4LjE3Mzk5MDAyMjY._gaMTQyNTc4OTY5MC4xNzMxOTQ5Mjk3_ga_ZYH7XNXMZK*MTc0MTAzMzk3NS43Mi4xLjE3NDEwMzQwNzEuNDYuMC4w)
, but have I hit the max capabilities of URL String Queries?

Thanks,
Eric

Find more posts tagged with

Forms

columns

URL Query

Accepted answers

Eric B.

@Adam Murphy
Thanks!! I'm a little embarrassed. My issue was me trying to build string query for the punctuation contained in the address…. oof.

All comments

Adam Murphy

If you just use the email address as the pre-fill value won't it show the display name(s) correctly when matched?

Eric B.

@Adam Murphy
Thanks!! I'm a little embarrassed. My issue was me trying to build string query for the punctuation contained in the address…. oof.

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.