0

I have five url fields on a custom object, an email template is created to send out the email to users with the custom object(record) content. My requirement is, I should display the url links in the email template, if there is one or more url fields have data in the record. Hence I have to create a formula field of text data type. Tried doing it, but this isn't displaying the link value and if the record has more than one field value, it doesn't work.

IF(NOT(ISBLANK(link_1__c)),link_1__c,
 IF(NOT(ISBLANK(link_2__c)),link_2__c,
    IF(NOT(ISBLANK(link_3__c)),link_3__c,
      IF(NOT(ISBLANK(link_4__c)),link_4__c,
        IF(NOT(ISBLANK(link_5__c)),link_5__c, null
        )
      )
    )
  )
)  

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.