How To: Handle Null or Empty Values

Show fallback text when fields are null or empty.

Use null-handling attributes when blank fields would confuse the reader.

Problem

You need to display something meaningful when a field is null or empty.

Solution 1: nullprefix and nullpostfix

Display N/A for empty values:

<column nullprefix="N/A">Optional_Field__c</column>

Display TBD for empty dates:

<p>Ship Date: {{!Opportunity.Ship_Date__c format-date="MM/dd/yyyy"}}</p>

If the field is null, this shows nothing.

Better:

<column nullprefix="TBD" format-date="MM/dd/yyyy">Ship_Date__c</column>

Solution 2: Conditional Rendering

Show different text for null:

<!--{{!
<lineitemsSOQL>
<soql>SELECT Title FROM Contact WHERE AccountId = '{{!Account.Id}}'</soql>
<column render="RECORD.Title==null,No title provided,RECORD.Title"></column>
</lineitemsSOQL>
}}-->

Solution 3: allprefix and allpostfix

Add symbols regardless of null:

<column allprefix="$" format-number="#,###.##">Optional_Amount__c</column>

Result: The $ still appears even when the field is null.

Tips

• Use nullprefix when you need placeholder text.
• Use allprefix when symbols should always appear.
• Combine with render for more complex null logic.
• Standard prefix and postfix do not render for null values.