make a relation to itself and count the Jobs of the actual day
I don't get the point.
Ok I got it! If "actual day" I have 0 Records count then I set IDCounter = 1
How do I set IDCounter field to 1 (Which instruction(s))
And thank you.
A relation ship to it self date <-> date
Count ( whatever) + 1
I made the self relationship with the JobDate field and made a new field to store the count (jobID) field but it seems I am missing something or don't know what I am doing but it is not working.
You seem to be an expert in FM but I am a Newbee so can you tell me more in how to do it?
Date is a date field with auto enter date of new record
Make a new relation from to the same table, named Daily, Date = Date
JobID is a text field with Auto-Calculation:
Date & "-" & Count ( Daily::Date ) + 1
I'm working with a german version, so i'm not really sure how the functions are named in english...
Hi user 16813, good solution. I ask myself: Why Filemaker don't release a new field incremental type "On Left Side" ???
I explain myself better: A counter that increment all this that is placed to its left without script,so
Credit Card: Date: Counter
VISA 2016/01/01 01
VISA 2016/01/01 02
A.EXPRESS 2016/01/01 01
VISA 2016/01/02 01
and too, a MASK for a number so if I want to represent number 1 in four digit, it change in 0001 automatically.
Hope Filemaker listen to the suggestions.
This is the same problem
self-Relation on CreditCard and count....
Nice your approach, I solved Jobnumber this way:
Year ( FECHA_jobs ) & Right ( "00" & Month ( FECHA_jobs );2) & Right("00" & Day ( FECHA_jobs );2) & "_" & "0" & Count ( Daily::FECHA_jobs ) + 1
Thank you very much, I really appreciate your help.