if, then function?

[smokeyjones]

Hi, I'm trying to generate a letterhead with the data I have. What I have is a field that says 1,2,3 and so on with people's name under them, 1 can have 5 names, 2 can have 3 and so on.

The letter head I need to make will say something like:

Hi [name field], please remember to take care of [1].

my problem is taking the [1] from the database I already have and change it into some form of text, like change [1] into [Throwing out the Trash].

Any help on this would be great, again I basically want to take the value from a field and generate a corresponding test based on the value. Thanks!

[efen]

pseudo code:

Case (

choicefield=1; "throwing out the trash";

choicefield=2; "collecting the trash";

choicefield=3; "generating the trash";

"")

[LaRetta]

There are limitations when hard-coding into a calculation. It must be opened any time you wish to add another action or change something and you must view the calculation to remember which action goes with which number. To allow much more flexibility, Smokeyjones, you might consider using a table instead (see attached).

The value list table would have an auto-enter serial beginning with 1 and simply a description field. Create a new record and then select your customer and the action (using popup) and the letter itself (generated from merge fields indicated below) will fill in.

It's just another approach ...

UPDATE: Oh, and if you want to still use calculation, another calc idea can be:

Choose (numberField -1 ; "Throwing out the Trash" ; "Emptying the Trash" ; "Generating the trash" )

... I mention it because I adore Choose() and we don't get many opportunities to use it so perfectly as in this example.

ValueListTable.zip

Edited October 22, 2009 by Guest
Added update

[smokeyjones]

thank you very much for your help!