Calculating/printing a field based on another field
Hello and thank you in advance for looking. I am using FMP 10 on OSX and I am a noob.
I have a large database of addresses with with the State field as a text box. This is not set up as a value list.
The states are all in the format (VA, MD, CA, etc.)
I need to create a new field that looks at VA and prints Virginia.
What would be the best way to acheive this? (all my attemps have failed)