Guys, I have the following problem. I have a script with a table containing several fields, from A to F. Column F is an error column. My bot reads all the columns, and if there's nothing in column F, it performs the functions I defined. If the bot encounters an error, it writes the error in column F.
When processing each row of my table, it deletes that entire row from A to F. If the bot encounters an error, it saves the error in column F, saves that row (from A to F) at the end of the table, and moves on to the next row. However, if there are any errors in column F (i.e., rows where an error is described in column F), the bot keeps looping through these rows.
How can I ensure that for each row read, the bot checks column F, skips to the next row if it finds an error, and after processing all rows, stops and leaves the rows with errors in the table? This way, the rows with errors remain in the table. Can someone help me with this structure?
When processing each row of my table, it deletes that entire row from A to F. If the bot encounters an error, it saves the error in column F, saves that row (from A to F) at the end of the table, and moves on to the next row. However, if there are any errors in column F (i.e., rows where an error is described in column F), the bot keeps looping through these rows.
How can I ensure that for each row read, the bot checks column F, skips to the next row if it finds an error, and after processing all rows, stops and leaves the rows with errors in the table? This way, the rows with errors remain in the table. Can someone help me with this structure?