Autonumbering

[Thang_Van]

Hello, I’m developing my first app with Appsheet. In my table I have 1 key field Query No. I want this to be unique and auto numbering i.e. if an user raise a query, it will be automatic 000XX for example, and user cannot edit it (I don’t want this to be an unique xyzdfs, as it doesn’t look good in a report). How can this be done?

[MultiTech]

Hey Thang.

In order to make something auto-incrementing, you have to create a formula to count things, something like:

count(query_table[Key_Field])

You’ll want to put that in the initial value field, not the app formula, because you only want the formula to run when someone is creating the query (not when making further updates) - otherwise the order number will keep changing later on when making any updates to the query.

But that’s the idea