How to change content (IFNULL... THEN... ELSE)

Examples:

  • Show the direct number if the mobile is empty.
  • Allow users the flexibility to create their sign-off without you, as the admin has to create additional templates.
  • Allow users to add their own LinkedIn; if they don't, the company LinkedIn profile is used.


IF NULL... THEN... ELSE...

This is the IF NULL ... THEN ... ELSE statement:

{$$IFNULL(   Field   )$$THEN(   text   )$$ELSE(   Field   )$$}


Example #1 - How to show the direct number if the mobile is empty  

{$$IFNULL(Mobile)$$THEN(direct 208-555-1275)$$ELSE(cell ((Mobile)))$$}

You preview the condition results in the Preview tab of your signature.

Alexander Beck has Mobile field content and his email signature incl. his cell no.:

Ann Appleseed has no Mobile content, and instead, her email signature shows her direct no.:


Example #2 - How to create dynamic sign off

Let's say that you would like to allow end-users to maintain their sign-off; if they don't, they will get the company standard. 

{$$IFNULL(SignOff)$$THEN(Best regards)$$ELSE(((SignOff)))$$}

Now users can update their email signature sign-off in the Xink add-in, and if they don't, they will get the company default. When an end-user requests a specific sign-off, you don't have to create a new template to meet that request. And you don't have to streamline everyone to use one specific sign-off.


Example #3 - How to create a dynamic LinkedIn

Here's an easy way to allow end-users to update and maintain their LinkedIn using 'My Contact Details' in the Xink add-in. You can also update Employees if you prefer no user interaction.

In this example, the link is www.linkedin.com/company/xink/ if the ((LinkedIn)) field is empty.

If the user link is updated, then that link is used.

{$$IFNULL(LinkedIn)$$THEN(www.linkedin.com/company/xink/)$$ELSE(((LinkedIn)))$$}

When you make the field editable, then the end-user can update in their Xink add-in by clicking 'My Contact Details':

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.