[FORMS] URL Query string not working
Any idea what could cause it not to work? When I add the query ?Property=ABC
it just refreshes with only the URL. It is just working on this one form but not on the others. What do I need to check?
I've already read the documentation.
Re creating another form on this sheet does not help.
Here is the link, but please DO NOT SUBMIT anything, this is a live tracker for our clients.
Issue only persists here but not on other sheets.
...
Best 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.
Answers
-
Hi @heyjay
I hope you're well and safe!
Can you maybe share some screenshots and the complete fomrula? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.
I hope that helps!
Have a fantastic week & Happy New Year!
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, Awesome, 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.
-
Happy new Year!
There are no formula. I share the form link. Maybe you can try to play with it, see if it works for you.
...
-
Ok.
If I try this one, it works, but I can't see if it populates the Property field. Can you check?
Did it work?
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome 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.
-
Yeah, the property seems to work, but I forgot to mention that we also need the PMC. Property was just one of the columns that came to mind.
Well, looks like most query works, even those that are not on the sheet column except the one that we need
wow, even the unicode does not work
I made another dummy sheet with PMC as column, and it appears its not also accepting it, but the Name column works.
...
-
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.
-
-
Not sure!
Can you test it in another browser to ensure that's not the issue?
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome 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.
-
Who do I ask to have my post redacted? I have some sensitive information posted here.
...
-
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.
-
Hello all! Not sure if this is still an issue, but I was having a problem when I added a Query string to the end of the form URL. What I noticed is that you have to put the Label for the field into the string value.
So, if you have a column called Name, but then you have a label in the form that says Enter Name, then your normal URL will look like this:
https://app.smartsheet.com/b/form/sldfkjsdlfjssdlkfjs
Then your query string form will need to look like this:
https://app.smartsheet.com/b/form/sldfkjsdlfjssdlkfjs?Enter%20Name=Robert
I don't think it is called out very well in the instructions or maybe I just did not read properly ha! Would not be the first time.
Hope that helps someone out.
Cheers!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 137 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!