I have looked at a few of the prefix scripts but cannot find one that fits the bill for us.
When a new record is created, our Ref field is manually inputted as:
ABC2025-01 (Enquiry identifier - always the same 3 letters, Current Year, sequential number)
Occasionally, the Ref field is filled with a subnumber, usually if a project gets split into phases. This is always manually inputted, so in theory the last project could end up being ABC2025-125-01.
All we are looking for (hopefully) is once a new record is made, the Ref field is automatically filled with ABC2025-02, next record ABC2025-03 etc
Any help appreciated