0

Need to generate an invoice number type field with year specific format.

Hi,

I have little to no understanding of code, could someone help me create a formula number please with a specific format. We want to create increment numbers with each new data entry to a max of 999 and have the year it was created at the beginning formatted "YY".

Additionally, we want the number to reset to 001 each year on 01/01/XXXX

 

End result = last entry has number 20-254, we create a new data entry and the new number would be 20-255. On new years day the next number would be 21-001.

 

Thanks in advance

1 reply

null

Content aside

  • 3 yrs agoLast active
  • 1Replies
  • 659Views