I have a multi-select field in my base. I want to create a form that has one of the selections checked when they open the form but allows people to select additional choices. I know how to do it in a text field but can’t figure out the syntax for a multi-select field (assuming it’s possible).
Thanks for any help!
I would suggest using the Prefilled Forms App by @kuovonne. It removes a lot of the guesswork and frustration for prefilling forms.
@Hannah_Wiginton 's suggestion looks like a good solution. Just wanted to share a thread I found that offers other possible solutions:
@Hannah_Wiginton 's suggestion looks like a good solution. Just wanted to share a thread I found that offers other possible solutions:
I used this for Pre-Filling:
- Multi-Select Fields
- Single & Multiple Linked Records Fields (I use a an ARRAY formula in a rollup field for each Linked Record field & just put RID at the end for easy denotion)
- Hiding Pre-Fills
FORMULA:
{FORM URL} &
"?"&"&prefill_"&ENCODE_URL_COMPONENT("Email List")&"="&ENCODE_URL_COMPONENT({Email})&"&hide_Email%20List=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Greeting")&"="&ENCODE_URL_COMPONENT({Greeting})&"&hide_Greeting=false"
&"&prefill_"&ENCODE_URL_COMPONENT("First Name")&"="&ENCODE_URL_COMPONENT({First Name})&"&hide_First%20Name=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Last Name")&"="&ENCODE_URL_COMPONENT({Last Name})&"&hide_Last%20Name=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Suffix")&"="&ENCODE_URL_COMPONENT({Suffix})&"&hide_Suffix=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Best Contact Method Dropdown Options")&"="&ENCODE_URL_COMPONENT({Best Contact Method Dropdown Options})&"&hide_Best%20Contact%20Method%20Dropdown%20Options=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Teams")&"="&ENCODE_URL_COMPONENT({Teams})&"&hide_Teams=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Birthday")&"="&ENCODE_URL_COMPONENT({Birthday})&"&hide_Birthday=true"
&"&prefill_"&ENCODE_URL_COMPONENT("Pronouns Not Listed")&"="&ENCODE_URL_COMPONENT({Pronouns Not Listed})&"&hide_Pronouns%20Not%20Listed=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Pronouns Dropdown Options")&"="&ENCODE_URL_COMPONENT({Pronouns Dropdown Options})&"&hide_Pronouns%20Dropdown%20Options=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Gender Dropdown Options")&"="&ENCODE_URL_COMPONENT({Gender Dropdown Options})&"&hide_Gender%20Dropdown%20Options=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Gender Not Listed")&"="&ENCODE_URL_COMPONENT({Gender Not Listed})&"&hide_Gender%20Not%20Listed=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Ethnicity Tags Options")&"="&
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({Ethnicity Tags Options},"/","%2F"),"(","%28"),";","%3B"),")","%29"),":","%3A"),"&","%26"),",","%5B"),"$","%24"),"]","%5D")," ","%20"),"{","%7B"),"!","%21"),"}","%7D"),"@","%40"),",%20",",")
&"&hide_Ethnicity%20Tags%20Options=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Ethnicity Not Listed")&"="&ENCODE_URL_COMPONENT({Ethnicity Not Listed})&"&hide_Ethnicity%20Not%20Listed=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Mobile Phone Number(s)")&"="&
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({Mobile Phone Number(s) RID},"/","%2F"),"(","%28"),";","%3B"),")","%29"),":","%3A"),"&","%26"),",","%5B"),"$","%24"),"]","%5D")," ","%20"),"{","%7B"),"!","%21"),"}","%7D"),"@","%40")
&"&hide_Mobile%20Phone%20Number%28s%29=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Office Phone Number(s)")&"="&
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({Office Phone Number(s) RID},"/","%2F"),"(","%28"),";","%3B"),")","%29"),":","%3A"),"&","%26"),",","%5B"),"$","%24"),"]","%5D")," ","%20"),"{","%7B"),"!","%21"),"}","%7D"),"@","%40")
&"&hide_Office%20Phone%20Number%28s%29=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Street Address")&"="&ENCODE_URL_COMPONENT({Street Address})&"&hide_Street%20Address=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Unit / Apt #")&"="&ENCODE_URL_COMPONENT({Unit / Apt #})&"&hide_Unit%20%2F%20Apt%20%23=false"
&"&prefill_"&ENCODE_URL_COMPONENT("City")&"="&ENCODE_URL_COMPONENT({City})&"&hide_City=false"
&"&prefill_"&ENCODE_URL_COMPONENT("State")&"="&ENCODE_URL_COMPONENT({State RID})&"&hide_State=false"
&"&prefill_"&ENCODE_URL_COMPONENT("ZIP Code")&"="&ENCODE_URL_COMPONENT({ZIP Code})&"&hide_ZIP%20Code=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Country")&"="&ENCODE_URL_COMPONENT({Country RID})&"&hide_Country=false"
&"&prefill_"&ENCODE_URL_COMPONENT("States You Want SAFE Updates In Tags")&"="&ENCODE_URL_COMPONENT({States You Want SAFE Updates In Tags})&"&hide_States%20You%20Want%20SAFE%20Updates%20In%20Tags=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Company List")&"="&ENCODE_URL_COMPONENT({Company List RID})&"&hide_Company%20List=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Roles")&"="&ENCODE_URL_COMPONENT({Roles RID})&"&hide_Roles=false"
&"&prefill_"&ENCODE_URL_COMPONENT("How Did You Hear About Us Tags Options")&"="&SUBSTITUTE(ENCODE_URL_COMPONENT(SUBSTITUTE({How Did You Hear About Us Tags Options},", ","`")),"`",",")&"&hide_How%20Did%20You%20Hear%20About%20Us%20Tags%20Options=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Did You Know About Sober Events Before SAFE Dropdown Options")&"="&ENCODE_URL_COMPONENT({Did You Know About Sober Events Before SAFE Dropdown Options})&"&hide_Did%20You%20Know%20About%20Sober%20Events%20Before%20SAFE%20Dropdown%20Options=false"
&"&prefill_"&ENCODE_URL_COMPONENT("How Many SAFE Events Have You Been To Dropdown Options")&"="&ENCODE_URL_COMPONENT({How Many SAFE Events Have You Been To Dropdown Options})&"&hide_How%20Many%20SAFE%20Events%20Have%20You%20Been%20To%20Dropdown%20Options=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Text Message Update Preferences Tags Options")&"="&SUBSTITUTE(ENCODE_URL_COMPONENT(SUBSTITUTE({Text Message Update Preferences Tags Options},", ","`")),"`",",")&"&hide_Text%20Message%20Update%20Preferences%20Tags%20Options=false"
&"&prefill_"&ENCODE_URL_COMPONENT("SAFE Newsletter Sign-Up Tags Options")&"="&SUBSTITUTE(ENCODE_URL_COMPONENT(SUBSTITUTE({SAFE Newsletter Sign-Up Tags Options},", ","`")),"`",",")&"&hide_SAFE%20Newsletter%20Sign-Up%20Tags%20Options=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Favorite Types Of Events Tags Options")&"="&
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({Favorite Types Of Events Tags Options},"/","%2F"),"(","%28"),";","%3B"),")","%29"),":","%3A"),"&","%26"),",","%5B"),"$","%24"),"]","%5D")," ","%20"),"{","%7B"),"!","%21"),"}","%7D"),"@","%40"),",%20",",")
&"&hide_Favorite%20Types%20Of%20Events%20Tags%20Options=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Favorite Genres Tags Options")&"="&SUBSTITUTE(ENCODE_URL_COMPONENT(SUBSTITUTE({Favorite Genres Tags Options},", ","`")),"`",",")&"&hide_Favorite%20Genres%20Tags%20Options=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Favorite Sports Tags Options")&"="&SUBSTITUTE(ENCODE_URL_COMPONENT(SUBSTITUTE({Favorite Sports Tags Options},", ","`")),"`",",")&"&hide_Favorite%20Sports%20Tags%20Options=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Favorite Types of Training / Workshops Tags Options")&"="&SUBSTITUTE(ENCODE_URL_COMPONENT(SUBSTITUTE({Favorite Types of Training / Workshops Tags Options},", ","`")),"`",",")&"&hide_Favorite%20Types%20of%20Training%20%2F%20Workshops%20Tags%20Options=false"
&"&prefill_"&ENCODE_URL_COMPONENT("What Resources Are You Interested In Tags Options")&"="&SUBSTITUTE(ENCODE_URL_COMPONENT(SUBSTITUTE({What Resources Are You Interested In Tags Options},", ","`")),"`",",")&"&hide_What%20Resources%20Are%20You%20Interested%20In%20Tags%20Options=false"
&"&prefill_"&ENCODE_URL_COMPONENT("What Resources Have We Connected You To That You Found Most Helpful Tags Options")&"="&SUBSTITUTE(ENCODE_URL_COMPONENT(SUBSTITUTE({What Resources Have We Connected You To That You Found Most Helpful Tags Options},", ","`")),"`",",")&"&hide_What%20Resources%20Have%20We%20Connected%20You%20To%20That%20You%20Found%20Most%20Helpful%20Tags%20Options=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Relationship With Drugs & Alcohol Tags Options")&"="&SUBSTITUTE(ENCODE_URL_COMPONENT(SUBSTITUTE({Relationship With Drugs & Alcohol Tags Options},", ","`")),"`",",")&"&hide_Relationship%20With%20Drugs%20%26%20Alcohol%20Tags%20Options=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Survey - Increased Skill & Awareness Dropdown Options")&"="&ENCODE_URL_COMPONENT({Survey - Increased Skill & Awareness Dropdown Options})&"&hide_Survey%20-%20Increased%20Skill%20%26%20Awareness%20Dropdown%20Options=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Survey - Supports Sobriety Dropdown Options")&"="&ENCODE_URL_COMPONENT({Survey - Supports Sobriety Dropdown Options})&"&hide_Survey%20-%20Supports%20Sobriety%20Dropdown%20Options=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Survey - Improved Mental Wellbeing Dropdown Options")&"="&ENCODE_URL_COMPONENT({Survey - Improved Mental Wellbeing Dropdown Options})&"&hide_Survey%20-%20Improved%20Mental%20Wellbeing%20Dropdown%20Options=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Survey - Increased Comfort Sharing About My Substance Relationships Dropdown Options")&"="&ENCODE_URL_COMPONENT({Survey - Increased Comfort Sharing About My Substance Relationships Dropdown Options})&"&hide_Survey%20-%20Increased%20Comfort%20Sharing%20About%20My%20Substance%20Relationships%20Dropdown%20Options=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Survey - Decreased Self Judgement Dropdown Options")&"="&ENCODE_URL_COMPONENT({Survey - Decreased Self Judgement Dropdown Options})&"&hide_Survey%20-%20Decreased%20Self%20Judgement%20Dropdown%20Options=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Survey - Used / Shared Recovery Knowledge & Resources Dropdown Options")&"="&ENCODE_URL_COMPONENT({Survey - Used / Shared Recovery Knowledge & Resources Dropdown Options})&"&hide_Survey%20-%20Used%20%2F%20Shared%20Recovery%20Knowledge%20%26%20Resources%20Dropdown%20Options=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Text Message Update Preferences Tags")&"="&ENCODE_URL_COMPONENT({Text Message Update Preferences Tags})&"&hide_Text%20Message%20Update%20Preferences%20Tags=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Social Platforms You Use Tags Options")&"="&
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({Social Platforms You Use Tags Options},"/","%2F"),"(","%28"),";","%3B"),")","%29"),":","%3A"),"&","%26"),",","%5B"),"$","%24"),"]","%5D")," ","%20"),"{","%7B"),"!","%21"),"}","%7D"),"@","%40"),",%20",",")
&"&hide_Social%20Platforms%20You%20Use%20Tags%20Options=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Personal / Company Website URL")&"="&ENCODE_URL_COMPONENT({Personal / Company Website URL})&"&hide_Personal%20%2F%20Company%20Website%20URL=false"
&"&prefill_"&ENCODE_URL_COMPONENT("LinkedIn Profile URL")&"="&ENCODE_URL_COMPONENT({LinkedIn Profile URL})&"&hide_LinkedIn%20Profile%20URL=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Instagram Profile URL")&"="&ENCODE_URL_COMPONENT({Instagram Profile URL})&"&hide_Instagram%20Profile%20URL=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Facebook Profile URL")&"="&ENCODE_URL_COMPONENT({Facebook Profile URL})&"&hide_Facebook%20Profile%20URL=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Facebook Page URL")&"="&ENCODE_URL_COMPONENT({Facebook Page URL})&"&hide_Facebook%20Page%20URL=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Facebook Group URL")&"="&ENCODE_URL_COMPONENT({Facebook Group URL})&"&hide_Facebook%20Group%20URL=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Twitter Profile URL")&"="&ENCODE_URL_COMPONENT({Twitter Profile URL})&"&hide_Twitter%20Profile%20URL=false"
&"&prefill_"&ENCODE_URL_COMPONENT("TikTok Profile URL")&"="&ENCODE_URL_COMPONENT({TikTok Profile URL})&"&hide_TikTok%20Profile%20URL=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Twitch Channel URL")&"="&ENCODE_URL_COMPONENT({Twitch Channel URL})&"&hide_Twitch%20Channel%20URL=false"
&"&prefill_"&ENCODE_URL_COMPONENT("YouTube Channel URL")&"="&ENCODE_URL_COMPONENT({YouTube Channel URL})&"&hide_YouTube%20Channel%20URL=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Discord Profile URL")&"="&ENCODE_URL_COMPONENT({Discord Profile URL})&"&hide_Discord%20Profile%20URL=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Spotify Profile URL")&"="&ENCODE_URL_COMPONENT({Spotify Profile URL})&"&hide_Spotify%20Profile%20URL=false"
&"&prefill_"&ENCODE_URL_COMPONENT("SoundCloud Profile URL")&"="&ENCODE_URL_COMPONENT({SoundCloud Profile URL})&"&hide_SoundCloud%20Profile%20URL=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Apple Music Profile URL")&"="&ENCODE_URL_COMPONENT({Apple Music Profile URL})&"&hide_Apple%20Music%20Profile%20URL=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Audius Profile URL")&"="&ENCODE_URL_COMPONENT({Audius Profile URL})&"&hide_Audius%20Profile%20URL=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Bandcamp Profile URL")&"="&ENCODE_URL_COMPONENT({Bandcamp Profile URL})&"&hide_Bandcamp%20Profile%20URL=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Beatport Profile URL")&"="&ENCODE_URL_COMPONENT({Beatport Profile URL})&"&hide_Beatport%20Profile%20URL=false"
&"&prefill_"&ENCODE_URL_COMPONENT("Prefix Dropdown Options")&"="&ENCODE_URL_COMPONENT({Prefix Dropdown Options})&"&hide_Prefix%20Dropdown%20Options=false"
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.