How can i pre fill an answer?

AppSheet AppSheet Q&A
1

Hi, I’ve an app what i use to record the monthly rent and bills payment record system for my tenants. There’s a column named “Serial Number of the Bill” every bill’s serial number will be (+1) from the previous one. But I’ve to check the previous serial number Everytime to input the new serial number.

Is there any way to make it automatic, i mean that appsheet will automatically detect previous row’s serial number and add 1 for the current data entry? So that i Don’t Have to check it manually from the Google sheets.

Thank You,

2

You can use the initial value as MAX(TABLE NAME[COLUMN NAME])+1

Please have a look at this post by @Steve

[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 …

2 Likes