Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Inline HTML field, how do I check when a field is not NULL/Empty?
I feel like I've written this a dozen different ways and yet this formula keeps returning 'Empty' when custbody5 is definitely not empty.
CASE
WHEN TRIM(NVL({custbody5}, '')) != ''
THEN '<div style="background-color:yellow; color:black; font-weight:bold;">'
|| {custbody5} ||
'</div>'
ELSE 'Empty'
END
Can anyone tell me how I'm supposed to write this case to return custbody5 but highlighted when not null?
Highlighted is custbody5, Empty is the formula result.
0