- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 23, 2025 12:25 PM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 23, 2025 03:18 PM
Hey! I’m on my phone rn, but you’ll probably want smth like this for your formula:
“ABC”&YEAR({created})&”-“&{autonumber}&IF({subnumber},”-“&{subnumber}, BLANK())
The above asumes that you have a {created} Field for created date/time, and a {subnumber} Field which might or might not have a value.
I hope to get back to this once I’m on a computer.
![](/skins/images/FE00829FDD2AE889FAB731D8F02A8942/responsive_peak/images/icon_anonymous_message.png)