Normally an ID gets field out between 3 separate fields so trying to find which one is not blank while also inserting a text field.
IF(OR(NOT(ISBLANK(ThisId__c), "This" ThisId__c, NULL))), (NOT(ISBLANK(ThatId__c), "That" ThatId__c, NULL)), (NOT(ISBLANK(OtherId__c), "Other" OtherId__c, NULL))))
Any help would be greatly appreciated.
6 件の回答
Sorry, my bad...
IF(
NOT(ISBLANK(ThisId__c)),
'This: ' + ThisId__c,
IF(
NOT(ISBLANK(ThatId__c)),
'That: ' + ThatId__c,
IF(
NOT(ISBLANK(OtherId__c)),
'Other: ' + OtherId__c,
NULL )))
