I have a scenerio which is based on a field of a record. This field is a lookup relation ship to another record. Example on my
abc__c object I have
xyz__c object. The
xyz__c object has a field named
type__c. My formula is based on
xyz__c and type__c values. The condition is:
xyz__cis not blank
type__Chas one of these
values -> 'CAR' , 'TRAIN' , 'BIKE' or 'PLANE'If the above 2 condition satisfies then formula field should have 'FALSE' else it should have 'TRUE' text. Formula is a text type field.
This is what I got started with:
IF( OR ( ISBLANK(xyz__c), ( UPPER(xyz__r.type__c) != 'CAR' || UPPER(xyz__r.type__c) != 'TRAIN' || UPPER(xyz__r.type__c) != 'BIKE' || UPPER(xyz__r.type__c) != 'PLANE' ) ) , 'TRUE','FALSE' )
What I am know that I should be doing is putting all the combination of
type__c in the formula field, meaning there could be case when the field has 'PLANE'
instead of 'CAR' so I might have to cover all those cases in the formula field. Is that correct? Is there a better way to implement this formula field?