Hi There,

I am trying to have text auto entered into "Field A" if "Field B" = "Active"

So, basically if "Field B" = "Active" then "Field A" would have a warning automatically filled out that would say "This record is currently ACTIVE"

I am able to accomplish this with a script, however I would like to have this done automatically if the conditions match. I am wondering if this can be accomplished with a calculation field.

Thank You.

npaadmin:

Certainly. You can set your Field A as a Calculation field like so:

Case(Field B="Active"; "This record is currently ACTIVE";"")

Any other possibilities can also be put within the Case statement as well...

-Stanley

Thanks,

I just tried that out and it worked like a charm. Sometimes I feel so stupid when things are that darn simple.

Thanks Again,