Hi, I am new to filemaker. I would like to create a serial number when record created.
I have 2 tables, A and B. A and B is connected through id <--> id_b.
So I would like to create a number something like ed-S-a-00001-01
where 00001 will fix for same portal records. if there are 2 parent records, the number will be 00002 for second record.
for the final number, when the user duplicate the parent record, it will increase to 02, otherwise, it will be 01 for most cases.
for a, it is same as 2018, so it will be b for 2019 and so on. I will use
Char ( Mod ( SerialIncrement ( GetAsNumber ( Year ( Get(CurrentDate) ) ) ; 1 ) - 2019 ; 26 ) + 97 ) to represent the number.
so for other parts, could I do it in auto-calculation rather than script.