How can I automatically auto-fill lab ref number, report link from google sheets to app sheet, this data will be automatically added in google sheet i want the same thing to happen in-app sheets
[Lab Reference Number]
is a column of Ref type?
no
I changed it to ref type and choose the google sheet but I want to focus on the lab reference column in the google sheet
In general, I advice anyone to not use both, AppSheet and the service where/how the data is saved (GSheets, MSExcel).
If you try to use both at the same time, you will find problems no matter what
Itโs not clear what youโre trying to accomplish.
Do you simply want Lab Reference Number to be automatically set, so the app user doesnโt have to enter it it? If so:
Or do you want the app to automatically set the value to the next higher number? If so:
Or do you want the column value to be provided by a spreadsheet formula? If so:
User | Count |
---|---|
35 | |
31 | |
30 | |
18 | |
17 |