AnsweredAssumed Answered

Calculating/printing a field based on another field

Question asked by cMuller on Jul 20, 2010
Latest reply on Jul 20, 2010 by philmodjunk

Title

Calculating/printing a field based on another field

Post

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)


Thanks

Outcomes