Forms URL query String, IS there a limit to how many queries can be used?

cjg · 06/29/23

There is more than one way to skin a cat.

Thank you both for your help.

It is up and running

Andrée Starå · 06/29/23

@cjg

Haha!

I'm always happy to help!

Paul Newcome · 06/29/23

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.

jmyzk_cloudsmart_jp · 06/30/23

Hey there!

我有这个整洁的工具来创建表达式和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.

https://app.smartsheet.com/b/publish?EQBCT=ea48e61454bf4ce0b15fb96377d2c5db&da_disableDeepLink=true

cjg · 06/30/23

This is great. Thank you for sharing. This will be super helpful and speed up the process.

Andrée Starå · 06/30/23

@jmyzk_cloudsmart_jp

Nicely done!

I've done something similar, but not so extensive.

Paul Newcome · 06/30/23

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=") + ................

jmyzk_cloudsmart_jp · 06/30/23

@cjg

If you need a copy of the content, please contact us using the form below.

https://app.smartsheet.com/b/form/8af18bf7138d421d834bc38f67027e14

Forms URL query String, IS there a limit to how many queries can be used?

Answers

Categories