erezzoo

Costume conditional serial number

Discussion created by erezzoo on Dec 28, 2017
Latest reply on Dec 29, 2017 by erezzoo

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:

TN2017/1

TN2017/2

TN2017/3

TN2017/4

TN2017/5

....

Normal invoices:

IN2017/1

IN2017/2

IN2017/3

IN2017/4

IN2017/5

....

I would also like them to restart every year.

Any suggestions?

 

Many thanks,

Erez

Outcomes