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:
Screenshot: Copy & Paste URL
Screenshot: Click URL in SS Table
Best Answer
-
@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
Answers
-
@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
-
Thank you! I saw that I needed to replace the blank spaces, but missed the @.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives