Hello, I am trying to record data from several screens into 1 google sheets and I am having a hard time with it. I have create row in screen 1 which consists of 13 columns, but I only fill 2 columns in screen 1 and I am planning to update the 3rd column data of the row in screen 2 . I failed. Are there some ways to solve this problem?
Two ways of doing it:
1
Use variables to collect information and then from your final screen assign the variables values to the sheet.
2
Use a variable to save the rowID of the row you want to change and then from each screen write the changes you want to the columns of the rowID you saved previously.
Happy Thunking