One of the apps i have is a quoting system. When a quote is generated currently it adds a row of the quote to a big table and we use row id internally and externally for customers
however i really want the quotes to be in like
#QM-1001
#QM-1002
Styling and format and just increment upwards indefinitely.
How can this be achieved? I know i could have a number that just gets used as a reference and increments when a row is made sets it as the reference for the quote. However is this scalable? Lets say we have 5x users click quote at a similar time
Will Glide handle this properly and ensure no duplicates?
See below, but be aware that the method described does not guarantee uniqueness. There is plenty of discussion about this in the thread, but the bottom line is that operations in Glide are not atomic, so if you need to guarantee uniqueness then you need to offload the allocation of IDs to some 3rd party, and ensure that requests are handled serially.
