Hey guys. I need help with the logic of this automation.
I have a spreadsheet on google sheets that has a column with lawsuit number. I going to the court website, typing their numbers in a loop, getting the text of the last update and trying to ruturn the text to the spreadsheet. If I’m writting the cell at the end of the loop then it should write a cell for each lawsuit number, right?
Problem is, I’m only getting one result in the sheet. I don’t know what I’m doing wrong.
Welcome to the community
in cell field you have to use index from for loop to increment the cell value
"B" + currentindex.ToString
cheers
Could you explain how to do this with more details? Simply typing “B” + currentindex.ToString didn’t work.
When you type in CurrentRow. do you get an option for index there?
Can you please mention the range as well under your sheet property? I see you have only provided the sheet name but not the range.
like example → processos!B1:B10 or processos!A1:B10
In for loop you need to use the index variable currentindex is the index variable
Either check in for loop properties or in a field use ctrl+ space to display runtime variables and use them
Obviously simply typing would not work
Cheers