I am trying to iterate over sub-arrays in order to batch process rows (E.g., if I have 10 rows in Google Sheets and a batch size of 5, I want to process 2 batches of rows: The first 5, then the second 5). I want to create an array from 2 to my batch size in steps of 1. Both ChatGPT and make.com Agent recommended I use a range function which does not appear to be available:
What is the situation with the range function? How should I handle this situation, and create an array to iterate over? Thank you for your support!
Hello Calijoe, a very easy way to do what you are trying to do is use the increment module in make.com. make sure it’s set to “never” so it won’t ever reset its value.
Then you can set up a filter to check when it reaches 5 so you can process the second batch of rows. I hope this gives you some insight into solving your problem.
1 Like
There is no range function in Make.
Do not trust AI suggestions with it comes to Make, as they are not trained on using the Make platform. If you Google it, looks like range() is a Python function instead.
If you want to do “chunking” — processing an array of items in batches, see A Better Solution for "How to group bundles in X amount of bundles" (Chunking Arrays)
Alternatively, use this module, How to send multiple inline keyboard buttons in a single Telegram Bot message (in multiple rows) with dynamic data? - #5 by samliew
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
1 Like
