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:[email protected] | 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.
