Forum Discussion

frnmj's avatar
frnmj
Qrew Member
3 years ago

Invoice Number Formula

I was hoping to create a field that's auto-generated with this format [YY]+0000 <- where this increments by one every time a new invoice is added. Can someone help me with the formula? --------...
  • MarkShnier__You's avatar
    3 years ago
    This should work as a formula text field.  The numeric portion will come from the [Record ID#] which is auto generated when you first save the record.


    IF([Record ID#]>0,
    List("-",
    Right(ToText(Year(ToDate([Date Created]))),2),
    PadLeft(ToText([Record ID#]),4,"0")))

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------