How can I set attribute as auto generated?

[abirtanjinadnan]

Hi all,

I want the name attribute of the form as autogenerated. Here is a picture.

The pattern of this attribute should be "itemcode_1, itemcode_2, … "

Thanks

[LeventK]

Do apologize but I’m afraid your query is not so clear. Do you want the form header (apperaring as Product Form in your screenshot) to be changed or dynamic? If so as per what criteria?

[abirtanjinadnan]

Thanks for your attention.

Actually, I want that

I will not input anything in the “Name” property, which is now blank in the image. I need it to be auto generated.

And the pattern of naming will be itemcode_* (here, * = number)

Is it possible?

[LeventK]

If you want it to be sequential, it’s not possible if you have multiple app users as it’s always possible that 2 same name will be assigned to 2 different users when they are trying to create a record at the same time.

[abirtanjinadnan]

I am adding the picture. here.

Here, you will see that I have added images as Photo1, Photo2

I need it to be auto generated.

[khuslid]

Mixing up the topics here?

[khuslid]

Not sure I understand, but in ‘Initial value’ of the column, you can generate almost any value from other columns or text as you wish.

[abirtanjinadnan]

@khuslid

Thanks for your attention.

Actually, these are the same topic with different problems.

Could you please mention how the “Query” should be written to generate value like "itemcode_* " (where * = auto-generated number)

[LeventK]

@abirtanjinadnan
If you want the itemcode_* to be sequential (1, 2, 3, …) it’s not possible as I have explained above.

[abirtanjinadnan]

@LeventK

Ok sir

[Steve · Accepted solution]

Serial Numbers, If You Must 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 …