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.
Yes, topically make the initial value UNIQUEID() and then I just hide it…
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.
User | Count |
---|---|
41 | |
28 | |
28 | |
23 | |
13 |