Conditional Serial number
Newbie here - exploring possibility of moving company equipment list to FM
inherited a unit # convention that uses a prefix code: EX for excavator, DZ for dozer etc and a 3 digit number to make a unique unit number for each piece of equipment.
Wondering if its possible to set this up so the next available number is selected by default once the prefix is selected.
i.e. User selects "EX" to create a new excavator, EX001, EX002 already used, so 003 would auto populate?
I've tried researching on my own, just want to know if it's possible