Increment column with Max(column)+1 when using security filters

[Gert1]

Good day.
Quite new here so I’ll try to explain my question.

I have a table with OrderID column.
When a new Order is added I set it’s initial value to MAX([OrderID])+1, which works as expected with no security filters.

Now say User 1 has added orders with OrderID’s 1 and 3 and User 2 has added an order with OrderID 2.

I also have a security filter on this table which gets only the orders of the currently logged in user.

When User 2 is using the app the above initial value evaluates to 3 when he adds an Order which should be three.

How can I resolve this?

Thanks

[Aurelien]

Hi @Gert

I would suggest that you may save the last number used in an “open” table, and use this one.
Just in case, here is a post you may want to read:

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 …

[Gert1]

Thanks so much!