Pre-Filled Form URLs

Hi SS Community,

I created a formula that builds the URL below to pre-fill fields on a form using values from a table. The resulting string works when I copy & paste it into a browser window, but not when I click on the link in the Smartsheet table, the last field (Personal Email) is blank. Does this mean that there is an error in the formula?

FORMULA:

=SUBSTITUTE(("https://app.smartsheet.com/b/form/833532b90edd4095bbc397e870a7ff7e?Full%20Name=" + [Full Name]@row + "&Application ID=" + [Application ID]@row + "&Work Email=" + [Work Email]@row + "&Personal Email=" + [Personal Email]@row), " ", "%20")

FORMULA RESULT:

https://app.smartsheet.com/b/form/833532b90edd4095bbc397e870a7ff7e?Full%20Name=John%20Doe&Application%20ID=2024-0458&Work%20Email=john.doe@work.com&Personal%20Email=john.doe@personal.com

Screenshot: Copy & Paste URL

Screenshot: Click URL in SS Table

Find more posts tagged with

Forms

Formulas

Links

Accepted answers

Lucas Rayala

@tnayak you can’t have special characters like the @ symbol in the URL. You need to use that SUBSTITUTE to change the @ to “%40”. Here’s the help article, it lists all special characters you need to replace:

https://help.smartsheet.com/articles/2478871-url-query-string-form-default-values

All comments

Lucas Rayala

https://help.smartsheet.com/articles/2478871-url-query-string-form-default-values

tnayak

Thank you! I saw that I needed to replace the blank spaces, but missed the @.

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.