disabled_adamsadow

Using Get or Logical Functions For If/Then

Discussion created by disabled_adamsadow on Jun 19, 2012
Latest reply on Jun 20, 2012 by PalmDBS

Evening,

 

I'm trying to create a calculation that basically says this: if the field "group" contains/says "monkey", then the field name "shortened group name" would contain/say/show "M", if the field "group" contains/says "dog", then the field name "shortened group name" would contain/say/show "D", if the field "group" contains/says "tiger", then the field name "shortened group name" would contain/sayshow "T", and if the field "group" contains/says "human", then the field name "shortened group name" would contain/sayshow "H".

 

Essentially, I'm trying to say that if a condition/field is met, than "A", if the condition is not met, then look at the condition/field again and if the next condition is met, then "B" and so on.

 

I hope I am making sense.

 

I am using FP 8.5.

 

Thank you for your help:-)

Adam

Outcomes