Hi FileMaker community,
I am working on a seminal hall reservation system. I am trying to create a costume serial number in my invoicing table for the front office to use as reference.
My problem is I have two types of Invoice - A normal Invoice, and a Tax return invoice. The type of invoice is decided via a text field after the creation of the record. I need a separate serial number for each record depending on its type. for example:
Tax return invoices:
I would also like them to restart every year.