Short answer:
Use IFNULL...THEN...ELSE to show fallback content when a field is empty. If the field has a value, that value is shown; if not, a default is displayed.
The IFNULL...THEN...ELSE statement allows you to change the content in an email signature depending on whether a field contains data.
This is useful when employees may or may not have certain information available, such as a mobile number, personal sign-off, or LinkedIn profile.
With this statement, you can define:
- What to show if a field is empty
- What to show if the field contains data
This allows one signature template to work for all employees.
IFNULL statement syntax
Use the following syntax:
{$$IFNULL(Field)$$THEN(Text if field is empty)$$ELSE(Content if field has value)$$}How it works:
- IFNULL(Field) → Checks if the field is empty
- THEN → Content shown when the field has no value
- ELSE → Content shown when the field contains data
Example 1 — Show direct number if mobile is empty
If an employee does not have a mobile number, you can show a company number instead.
{$$IFNULL(Mobile)$$THEN(direct 208-555-1275)$$ELSE(cell ((Mobile)))$$}Result:
With mobile number:
cell 208-555-5678
Without mobile number:
direct 208-555-1275
Example 2 — Dynamic email sign-off
Allow employees to define their own sign-off, with a default fallback.
Create a field called SignOff and make it editable.
{$$IFNULL(SignOff)$$THEN(Best regards)$$ELSE(((SignOff)))$$}Result:
- Custom value → Employee’s sign-off is shown
- Empty field → Default “Best regards” is used
Example 3 — Default company LinkedIn
Show a company profile if the employee has not added their own.
{$$IFNULL(LinkedIn)$$THEN(www.linkedin.com/company/xink/)$$ELSE(((LinkedIn)))$$}Result:
- Employee link → Personal LinkedIn is shown
- No value → Company LinkedIn is shown
How to test the IFNULL statement
- Go to Signatures
- Edit your template
- Insert the IFNULL statement
- Click Preview
- Test with users with and without values
This ensures your logic works before publishing.
When to use IFNULL
- Show fallback phone numbers
- Provide default sign-offs
- Display company links when personal ones are missing
- Handle empty fields cleanly
