Skip to main content
Nintex Community Menu Bar
Question

Differentiate 0" and blank"

  • July 10, 2024
  • 3 replies
  • 10 views

Forum|alt.badge.img+8

I understand that {{#blah}} is basically an “if” statement that checks if a field has a value, but for numerical fields a zero value will be counted as blank.  Is there a method to differentiate between a blank and a zero?  

This topic has been closed for replies.

3 replies

Forum|alt.badge.img+8
  • Author
  • July 10, 2024

Anyone have any thoughts on this?


Forum|alt.badge.img+13

You could use a Ui-Only Formula Field to differentiate between a field being zero or blank, e.g. a Checkbox Ui-Only field called “MyFieldIsZero” which returns true only if the value is explicitly zero

IF({{MyField__c}}==0,true,false)

Then in your page, where you were using {{#MyField__c}} you could instead do {{#MyFieldIsZero}}… {{/MyFieldIsZero}}


Forum|alt.badge.img+1

And how would do that for number fields? I can see you rely on Javascript, meaning that 0==‘’ is true. In this case how do I know whether a field has 0 value or is blank?