AnsweredAssumed Answered

Auto-enter text values

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


Auto-enter text values


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!