I am setting up an invoice system. I have spent several hours looking for a solution but I cannot find what I am trying to do.
My invoice number will be in format RP220101 where “RP” is the user initials, “2201” is the current date formatted as “yymm”. The last two digits “01” is a count of invoices for that month. I have set up initially with an input box:
In my workflow, I then create an invoice number like so:
I am trying to solve two issues:
When a new month rolls over, I want the last two digits to reset, so if the last number in the month of Jan is for example, RP220135, then the next number in the new month should be RP220201. How can I solve for this?
Is there a way to get the last two digits without the use of the input box? I can probably hide this on my page but that is not an ideal solution.