I have been trying increment a field by 1 each time addrecord is invoked. It is the composition/output of the field that I am not able to “figure out.”
I want the field (Invoice Number) to contain the year and to display like this 2017001, 2017002, etc. So come January next year the invoices would appear 2018001, etc.
Is this doable?