AnsweredAssumed Answered

Auto-enter text values

Question asked by yoelcita on May 14, 2010
Latest reply on May 14, 2010 by mrvodka

Title

Auto-enter text values

Post

I have a sponsorship database in which want to create a field ("Status") that auto-enters one of three text values ("current", "ahead" or "behind") based on the number of an unstored calculation field ("Months").

 

1. If "Months" is 0, "Status" field auto-enters "current"

2. If "Months" is greater than 0, "Status" field auto-enters "ahead"

3. If "Months" is less than 0, "Status" field auto-enters "behind"

 

Is this possible, and if so how can I script this?

 

I'm using Pro 10 on Mac OS X, and am still a novice.  Thanks in advance for any help!

Outcomes