Hi, I searched a Row, and now I have the Row ID.
Thats ok, but now, I want to “Get a Row”, not the same, the next one that the one I´ve searched. I try adding “+1” in the “Row ID” field, but it doens´t work.
I need to do it in this way because I need to check like ten of the next rows that come after the one searched previously. And all of this with some logic inside the flows.
Does anyone have any ideas how to solve this “the next row ID” problem?
Thanks
Pablo Leonhart
Unfortunately there’s no specific logic that you could really include to progress through row ID’s in Google Sheets. Each Row ID is unique and not necessarily sequential, e.g. you could have Row ID 12345 and then the next row be 13765.
What could work as a potential workaround is to have a unique identifier for each column such as row #. So row 1 would have #1, row 2 would have #2 and so forth.
Since you can then search for a start number it could be incremented by one each time using the number service and you could work through the rows as many times as needed.