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 information? 👀 | 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, join the Smartsheet Guru Elite
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 information? 👀 | 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 information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
@Genevieve P. Thank you!
Darren Mullen, join the Smartsheet Guru Elite
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
- Customer Resources
- 66.5K Get Help
- 434 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Trending Posts
- I've set up a archiving workflow using an archive checkbox column in our intake sheet through our blueprint. When this criteria is met, the project is supposed to be moved into an archive workspace, t…
Anyone has a problem Datamesh error code 1302;You cannot edit cells with Column Formula for column(0
Dear Support, I created a Datamesh with lookup value from a Formula column (source column), once run the config, then show error "code: 1302; message: You cannot edit cells with Column Formula for col…- Hi all, I was just informed by our I.T. Dept that Microsoft is killing the Outlook Add-in. We use this add-in quite extensively. Is anyone out there aware of a quick and easy way to attach emails to s…
