Readable Keys

Hello I am Building a Crm for  my Small business
In my Table I have an (Order ID) And the Other is (Order Items ) and it Is a Key
I need that to be a readable Value So i am using this formula

 

CONCATENATE("Cst",MAX(CUSTOMERS[_RowNumber]))

 

instead of UUID()

The problem occurs when Two Instance(users or windows ) Are Adding Orders
One entry Is saved First and the Other Edits It Or So
But I get One Order With Two references To  an Other Table Called (Order Items)
instead Of Two Orders With Single Reference To (Order Items)

 

 

1 2 59
2 REPLIES 2

You're looking for "sequential keys" - there are numerous good posts in the community on how to accomplish. 😉

Steve
Platinum 4
Platinum 4
Top Labels in this Space