Check data before save

Hello!

Ive done this form adding a virtual column, seting up as required field, which is getting the maximum value from a specified column and adding 1 on each add event as the initial value. But the problem is, if we have 2 computers running this app at the same time at the same add page, this virtual collumn will have the same value for both computers, once we've got the same column data, if we click on the save button, we will have duplicated values on our collumn.

What i want to do is check before save. When the user click on the save button, the app will first check if we have any values greater then our calculated value, if it do, the save progress will stop and we have to cancel this procedure to start it again, so it will get the right value, if not the save will happen normally.

0 1 58
1 REPLY 1

It sounds that you are trying to create a sequential numbering system. In AppSheet there is no concrete solution to overcome duplicate sequential numbers in a multi user operation.

Sequential keys - AppSheet Help

 

 

Top Labels in this Space