Hi all, I have a table with empty data, i wa...

(Mohd Fadyllah) #1

Hi all,

I have a table with empty data, i want one of the column become auto numbering in increment.

How do i achieve this?Can this column become key?

Thanks

(Aleksi Alkio) #2

You could read this article why it’s not a good idea… help.appsheet.com - Is it possible to create an incrementing number for each record? Is it possible to create an incrementing number for each record? help.appsheet.com

(Mohd Fadyllah) #3

so how do i got about this? any other way to give a unique reference to the record?

Since i have inspection tables, now i use location as key but inspection can be done several times.

Thanks

(Aleksi Alkio) #4

The easiest solution is to add a 8 digit unique value with the expression UNIQUEID().

(Mohd Fadyllah) #5

Yessss…it worksss…Thanks