I have an app whereby each job gets allocated [Job Number] based on [_RowNumber]+40000 as an App Formula. The issue seems to be that in certain senarios the following happens:
- User A starts to adds a record, [Job Number] = 41000 because row 1000 is still blank
- User B starts to adds a record, [Job Number] = 41000 because row 1000 is still blank
- User A saves the record so where [_RowNumber] = 1000, [Job Number] = 41000
- User A saves the record so where [_RowNumber] = 1001, [Job Number] = 41000
I'm thinking the best way to solve this is to have an action on Form Saved to write [Job Number]. Any better suggestions?
LinkedIn
Twitter
