Help

Create ref number when a new record is made

Topic Labels: Automations Formulas
233 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Stu
4 - Data Explorer
4 - Data Explorer

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 

 

1 Reply 1

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. 

Mike, Consultant @ Automatic Nation