Initial Value Plus one

Hi everyone,

I am looking to have my app have an initial value of the last work order created plus one.

I’ve done some research and I know that this can cause problems if you use that column as a key which I will not be doing. I have found some information of using MAXROW but I’m not sure how to accomplish this.

Furthermore, is there a way to prevent a user from making a duplicate value? For example I wouldn’t want users to be able to create work order #1 if work order#1 already exists.

Thank you!

0 1 378
1 REPLY 1

Check this article and the section " Preventing Duplicate Field Values"

Top Labels in this Space