Is there a way to automate this system of numbering new records:
Q-19001 - “19” is tells me it’s from 2010 and then it’s followed by a 3 digit autonumber.
Q-20001 - that’s the first record for 2020 and the 3 digit sequence resets itself.
I have two questions -
Which formula command “extracts” the 2 digit year (YY) from a “date created” field for example? I can’t seem to figure that one out. I am sure it’s easy…
How do I set the autonumber field as having to have 3 digits - and is there a way to have the auto-numbers reset every year? (Someone had suggested to manually adjust the formula at the beginning of each year by subtracting the highest number of last year - that’s certainly one way of doing it.)
Thank you so much in advance.