BRIDGE by Smartsheet - Array[100]
I'm creating a workflow to populate a drop-down column with a large number of values.
It looks like there is a 100-node limit to the row array being returned. Is this true, and if so, how do you increase this limit?
Best Answer
-
Hey @earl_bennett and @Darren Mullen
You can change the number of rows being returned in the Get Sheet module by adding a number to the Results per Page parameter:
Here's more information: Get Sheet
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
@earl_bennett I just ran into the same issue. Looking to see if there is a way to get more than 100 like this. Otherwise... I'll have to javascript it!
Darren Mullen, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
I haven't gotten past the issue yet. If you do javascript it, I would appreciate knowing how you did it. Each time I find a good use-case for BRIDGE I've ran into a wall.
-
Hey @earl_bennett and @Darren Mullen
You can change the number of rows being returned in the Get Sheet module by adding a number to the Results per Page parameter:
Here's more information: Get Sheet
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
AWESOME!
Thank you! I will give this a try today!!!
-
-
Glad to hear it! Thanks for following up 🙂
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
@Genevieve P. Thank you!
Darren Mullen, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
Just an FYI that the max is 10,000, even if you put a higher number in.
-
Good to know @Brian_Richardson !
Thanks,
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives