We help IT Professionals succeed at work.

Serializing Records By Category Filemaker Pro 11

PachecoPrimo
PachecoPrimo asked
on
Medium Priority
782 Views
Last Modified: 2012-05-12
I want to have an auto-enter field or a calculation field that serializes records by category. i have attached a sample of the database I have. I have four fields (Group, Name, Serial Id, and Max Serial Id). I have 1 table with 2 ocurrences.  The field 'Max Serial Id' is based on a relationship from an occurrence of the main table that uses the max() function to show the largest 'Serial Id' value entered for a particular Name under a Group. I want to be able to auto enter the Serial Id number every time a record is created. The calculation should look into the Max Serial Id field and get the value and then add a 1 to the Seria Id value.
Serial-Number.fp7
Comment
Watch Question

North2AlaskaSenior Engineer
CERTIFIED EXPERT

Commented:
How about just calculating serial number?  In order to do this, you need an additional field to "Break the tie".  So I created a Date Created field and auto entered the timestamp when the record was created.  Then added it to the join.  One caveat;  a record in the same group/name pair can NOT be created at the same exact second.  If you feel comfortable with this condition, this will produce what you want.

 Serial-Number.fp7

Commented:
PachecoPrimo
You can run a script that opens that table in a separate windows,
Then find all record, sort by field with serial number, go to the last record
Set a variable that equals the serial number field and then add 1

Hope that helps!
Tom

Commented:
Another option to having a serial number is to use a Universally Unique Identifier (UUID)

You will need filemaker advanced. Learn more about it here
http://www.briandunning.com/cf/1246
Senior Engineer
CERTIFIED EXPERT
Commented:
A UUID is a "Universally Unique ID", but in this case the ID (or serial number) is unique within the group/name pairs.  But the idea is the same.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.