I want to number each row when the data is saved in Google sheets??
ID is number of the user
ex: user 1: ID = 1 , user 2 : ID= 2 …
this is my project:
blocks:
Google Sheets:
I want to number each row when the data is saved in Google sheets??
ID is number of the user
ex: user 1: ID = 1 , user 2 : ID= 2 …
this is my project:
blocks:
Google Sheets:
If you want sequentially numbering, then do as follows:
={"ID";arrayFormula(if(A2:A="","",row(A2:A)))}
Send an empty string for your ID value in your app.
.
.
.
If you want to pull a value from your app somewhere, include this in your empty block.
In Multiple ways you can achieve this.
Thank you for your help.
When I do this, the app does not send data at all.
Thank you for your help.
Did you delete all your empty rows as instructed? Scroll to the end of the sheet, I guess you will find data…
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.