AnsweredAssumed Answered

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

Question asked by TeresaRansdell on Aug 30, 2011
Latest reply on Aug 30, 2011 by LaRetta_1

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? 

Outcomes