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 Like

You’re looking for “sequential keys” - there are numerous good posts in the community on how to accomplish. :wink:

2 Likes

Serial Numbers, If You Must - Google Cloud Community