Hi, I’ve got the same issue. Did you find a solution ?
See @Darren_Murphy as per your suggestion this is not a good method to follow.
Let me explain: Suppose there are 10 rows across all the sheets in glide, including User Profile sheet, now
Case 1: If any new user enters first he would be able to see welcome screen, where he enters the email and after receiving the code he can proceed to next. Now as soon as the user is authenticated with the code, a new row is created in the user profile sheet.
Note: Now there are 11 rows in the user profile sheet, but 10 in other sheets
But now that user doen’t presses that button, which is suppose to be transfer the email id to all other sheets and exits the app.
Case 2: Another new user enters and gets authenticated, a new row gets added to the user profile sheet.
Note: Now there are 12 rows in the user profile sheet but 10 in other sheets, if this user presses the button his email id will gets added in 11th row of other sheet instead of 12th one, thus creating a row mismatch error.
Did you take a look at my concept App?
Neither of the cases that you describe are possible, if you follow the same method.