I rewatched your video here and, got it… I have to call a sheet and select the fields i want before any login! Thanks!
2 Likes
Correct!
1 Like
The problem I’m having is when writing any additional data to a newly created row. I’m just using a pretty simple sheet.getRange(lastrowNun,columnNum).setValue(‘to absolutely anything at all’); and that simple script action causes an extra line to be added under it. If the function is triggered after the new row has already been added, it writes to that row perfectly with no added row. But if I want the onChange trigger to write that data the moment it comes in, the new row adds. This doesn’t happen with any other data that comes in from forms on other sheets. I have content being added as new rows to other sheets and the same onChange trigger causes the same function to write some additional data to those new rows without adding a new line. So I really can’t figure this out.
Currently my work around is to let the data finish writing and then have a final deleteRow(lastrowNum + 1) action clean that row up. But it’s hacky and could cause big problems if two people log in to the app at around the same time.