I'm trying to create a URL to a form and ALSO prefill some of the form fields based on a sheet
I've added a column on my master for the hyperlink to the form.
Everytime I try to enter the info at the end of the URL to pull data from the sheet into the form fields I am getting the error - Invalid URL.
As a example - I want to prefill several fields from the row in my spreadsheet onto the form so the user doesn't have to enter this every time they fill out the form.
Store Number, Name of User, Address, City, State, etc....
Answers
-
I hope you're well and safe!
Have you looked at the URL Query documentation?
More info:
Did that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I can create the URL and specify a field to pre-fill in the form if I do this as an individual field with specific data entered.
For Example: If I want the address to prefill in the form, and the address is : 301 El Camino Real, My URL reads:
https://app.smartsheet.com/b/form/1791ce19078b4697a3a026c043d95843?Address=3011%20El%20Camino%20Real
This fills in the Form correctly.
The issue I'm having is: When the user clicks on the URL, I'd like for SEVERAL fields to prefill on the form for them so they don't have to type them in each time. I want the fields to prefill based on information that is pulled from the row in the sheet.
So, For example, I want the Address to pull in from the column in my sheet:
The instructions I was following to do that tells me to enter this in my URL:
This returns Invalid URL for me.
Is there an option to build this formula into the URL? Do I have the formula portion wrong? I'm fairly new to all of this
-
@Sandra Martin Did you by chance figure this out? Looks like this is the exact same issue I am having. Spaces necessary for the correct formula do not work in a URL format and cannot be eliminated from what I can tell to preserve as a proper URL.
-
@Sandra Martin - curious if you found a solution.
-
I wrestled with this myself. Here is the answer. You are in essence building the actual URL by appending text from a cell reference. So the problem with our URL is that you need to add the =" to the beginning.
wrong:
right:
The " after Address=" is the close quotes from the beginning of the cell. The command after the " will be evaluated when you press enter as with any other formula.
Again, this stumped me until I ran across this youtube video https://www.youtube.com/watch?v=H7qw7gbGjZk which triggered my AHAH moment. Thank you to Prodactive Product Solutions for this video.
Hope this helps.
-Mons
-
I came up with a solution for this for my approval process by using logic. The original form has hidden fields for the Approvers. When a form is submitted, I have a defaulted check box "Submitted" that does 2 things:
1) sends the automated notification to the Approvers with the URL to the pre populated form;
2) because the "Submitted" box is now checked, it triggers logic to open up the additional "hidden" fields we want the approvers to complete.
I created a URL query to pre populate the form fields and pre populate some of the fields specific to the approvers. This process also allows for that row to be "updated" vs creating a duplicate form with a different URL which causes a duplicate row to be submitted with the added approval fields.
Hope this helps!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 428 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives