11 Replies Latest reply on Mar 4, 2013 10:30 AM by flybynight

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

    jmci

      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.