solve this

January 4, 201016 yr

i have 2 fields one is "religion" (text) and the other one is "Parish or horoscope" (text).I want a calculation so that if i type "christian" in the field "religion" then the field "Parish or horoscope" should be automatically typed with "Parish" and if i type "hindu" in the field "religion" then the field "Parish or horoscope" should be automatically typed with "horoscope"..

can any one help me please..

January 4, 201016 yr

Try this. They're are other ways to do this also.

religion.fp7.zip

January 6, 201016 yr

Newbies

Redefine your "Parish or horoscope" as a CALCULATION field with the RESULT being TEXT and the following as the calculation (you can copy and paste it)

Case(religion = "christian"; "parish"; "horoscope")

This calculates for the 2 results you wish for. The above function operates, in plain English, as "if this person is a Christian then this field will be PARISH. Otherwise it will be HOROSCOPE".

You can add to this if you wish. Let's say you wanted to add Buddhist with the result "dharma". Your function would be as follows:

Case(religion = "christian"; "parish";

religion = "hindu"; "horoscope";

"dharma")

Hope this helps!