Forms URL query String, IS there a limit to how many queries can be used?
Answers
-
There is more than one way to skin a cat. 🙀
Thank you both for your help.
It is up and running
-
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 to help. 👍
And to answer the question posed in the title...
There is no limit to the number of fields you can populate, but both the formula AND the output URL must be less than 4,000 characters including spaces.
If the formula is 4,001 characters but only outputs the letter "A", it won't work. And if the formula is only 12 characters long but has an output of 4,001 characters, it also won't work.
There are some exceptions such as evaluating a JOIN string with a FIND function will not error out, but the find will only evaluate the first 4,000 characters.
=FIND(" ", JOIN(A:A, ","))
won't cause any issues within the sheet itself, but if the space is character number 4,001 when joining column A, you're going to still get an output of 0.
-
Hey there!
I've got this neat tool to create expressions and convert those special characters into query strings. (form-based form-creating automation.)
It's a lifesaver because writing error-free expressions can be quite a hassle.
Since my users use 2-byte Japanese, I've got plenty of options to convert all sorts of special characters.
Simply converting those grayed-out special characters in English-speaking countries usually does the trick.
-
This is great. Thank you for sharing. This will be super helpful and speed up the process.
-
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 did something similar as well. There's another one I need to bookmark that shows how to get it to do multi-select fields, but I can't seem to locate it again. Basically you repeat the field name and then each option.
................ + "&Field Name= Option A" + "&Field Name= Option C" + .............
This is the one time I will put a SUBSTITUTE function in the middle of the string. To make the above dynamic to match what is already filled in in the sheet:
................ + "&Field Name=" + SUBSTITUTE([Field Name]@row, CHAR(10), "&Field Name=") + ................
-
If you need a copy of the content, please contact us using the form below.😃
https://app.smartsheet.com/b/form/8af18bf7138d421d834bc38f67027e14
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives