AnsweredAssumed Answered

Creation of serial number

Question asked by user2147901 on Aug 17, 2018
Latest reply on Aug 18, 2018 by user2147901

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.