[FORMS] URL Query string not working

heyjay · 01/03/23

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.

Andrée Starå · 01/03/23

@heyjay

It works for me.

Andrée Starå · 01/03/23

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!

heyjay · 01/03/23

https://community.smartsheet.com/discussion/comment/355750#Comment_355750

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.

Andrée Starå · 01/03/23

@heyjay

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!

heyjay · 01/03/23

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.

Andrée Starå · 01/03/23

@heyjay

It works for me.

heyjay · 01/03/23

https://community.smartsheet.com/discussion/comment/355759#Comment_355759

is there something wrong on my end?

Andrée Starå · 01/04/23

@heyjay

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!

heyjay · 01/04/23

Who do I ask to have my post redacted? I have some sensitive information posted here.

Andrée Starå · 01/04/23

@heyjay

You can do it underneath the post.

RobertBuckley · 04/05/23

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!

[FORMS] URL Query string not working

Best Answer

Answers

Help Article Resources

Categories