1 Reply Latest reply on Aug 30, 2011 6:25 PM by LaRetta_1

    Auto Enter Numeric Value in New Field Based on Alpha Value in Another Field

    TeresaRansdell

      Title

      Auto Enter Numeric Value in New Field Based on Alpha Value in Another Field

      Post

      I'm new to FileMaker and not a techie by trade...I want a new field in a table to be auto-populated with a number based on the alpha character that I enter into another field.  For example:

      When I enter "A" in Field 1, I want "1" to populate in Field 2.

      When I enter "B" in Field 1, I want "2" to populate in Field 2.

      When I enter "C" in Field 1, I want "3" to populate in Field 2.

      "A" will always equal "1"; "B" will always equal "2", etc. up to "I" will always equal "9"

      Any advice on how I can do this?