I have used a SET node to create a variable called “Index”. It is followed by a “Google Sheets” Lookup which gets row 1.
How can I add 1 to this variable then loop back to get row 2 from the “Google Sheets” Lookup?
I have used a SET node to create a variable called “Index”. It is followed by a “Google Sheets” Lookup which gets row 1.
How can I add 1 to this variable then loop back to get row 2 from the “Google Sheets” Lookup?
Welcome to the community
Check this example How to retrieve all executions data of a node? - #2 by jan.
If that does not help let me know.
OK, that helps but if I add another node after the “Increment” node then result of this node gets fed back to the “Start Loop” node and breaks it. Is there a way around this?
Thanks.
I have discovered the $runIndex variable - that does what I need here.
Thanks.
@tamone : Could you share Workflow you are using $runIndex variable?
@tamone I could use that too please
@mumudu22 There is a variable $runIndex that you can reference inside of the code. I am using it as a pagination on my node
Ok thanks!