Hi, I’m wondering the best approach to my scenario. Essentially to break down my goal I am getting range value as a method of calculating my new row number e.g. Total number of bundles + 2 (inc header) will equal the next empty row. From there I use the webhook to create a document and then update the empty row (using get range values “Total number of bundles + 2” as the new row determiner). However, doing this obviously returns multiple bundles to which In turn when updating a row using google sheets get range value variables theres multiple bundles which in turn generates multiple output bundles in my subsequent modules. Wondering whats the best way to achieve my goal?
e.g.
Webhook (get content) → Google Sheets (empty row value) → Create doc → Update sheets with doc link and content in the empty row value.
Welcome to the Make community!
The “Get Range Values” module do not output row numbers, because you already know the row numbers for them (since you had to specify the row numbers to get the range values).
If you require row numbers, use the “Search Rows” module instead.
samliew – request private consultation
Join the Make Fans Discord server to chat with other makers!
1 Like
I still have to get the empty row number regardless using “search rows”. Main issue here is using variables from the “search rows” or “get range value” in subsequent modules. And there being multiple bundles, create multiple operations.
If you want to combine multiple bundles into a single bundle,
Every result (item/record) from a search module will output a bundle. To “combine” them into a single structure, you’ll need to use an aggregator of some sort.
Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module. The next popular aggregator is the Text Aggregator which is very flexible and has applies to many use-cases.
Then, to map values from the array variable into your “Update a Row” module, to update only a single row, see “Mapping with Arrays” below, or the Make Academy
Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —
General
Help Center Basics
Articles & Videos
samliew – request private consultation
Join the unofficial Make Discord server to chat with other makers!
