Is it possible to create a unique service req...

(Joshua Giles) #1

Is it possible to create a unique service request number column that autofills unique numbers automatically. I’m creating a service request app and a separate repair app using the same excel sheet and I want the person inputting in the repair app to say which service request number they are working on. Is this possible?

I could write a function on the back end to auto fill but I want to be able to add and delete without it derailing everything or creating duplicate numbers.

(Grant Stead) #2

Yes, topically make the initial value UNIQUEID() and then I just hide it…

(Aleksi Alkio) #3

As Grant explained, the UNIQUEID() is a good choice for the key value. Unfortunately it’s not so good for users and you should probably find a better value for it and use that as a label. One column for key value and another one for real value.