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
1 Like
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:
[Serial Numbers, If You Must](https://community.appsheet.com/t/serial-numbers-if-you-must/19325) Tips & Tricks ?
Danger Ahead! In general, sequential numeric identifiers (i.e., serial numbers) are risky in AppSheet: if two users happen to add rows at the same time, both rows could be assigned the same serial number, which could lead to confusion (at the least) or data loss (at the worst). For this reason, serial numbers are strongly discouraged! Basic Serial Numbers One way to implement serial numbers is with a normal (not virtual) column named (e.g.) Serial of type Number and an Initial value expression …
Or do you want the column value to be provided by a spreadsheet formula? If so:
1 Like