AnsweredAssumed Answered

What's the Best Way to Increment an Alpha Character the Same Way as a Serial Number?

Question asked by jmci on Mar 3, 2013
Latest reply on Mar 4, 2013 by flybynight

I'm working on a system to replace a legacy project management system. In the legacy system the "Job" has a 5-digit numeric Job No. field. In the legacy system there maybe many Estimates related to each Job. Each Estimate has an "Estimate No." field that is derived by appending an upper case alphabetic character (A thru Z) to the Job No. of the related Job. I wondered if FileMaker's auto-enter Serial Number feature would be smart enough to increment alphabetic characters as well as numeric characters but it isn't. I created a field Estimate_No_Suffix__t and identified it as a Serial number and set the next value to "A". I hoped that Filemaker would generate values in this field in new records as "A", "B", "C".... Unfortunately what I got was "A1", "A2", "A3"...


I bet somebody else has had to solve this problem before. I could use some ideas.