Skip to main content
Nintex Community Menu Bar

o365 form - Is number field blank?

  • June 28, 2019
  • 1 reply
  • 57 views

Forum|alt.badge.img+11

I have a number field that is optional to be updated. Zero is a legitimate value to enter into the field. However, if the field is left empty, it still returns zero. So a test for zero doesn't tell me if that was the original value or the updated value. I'd like the field to return blank if the field wasn't updated by the user to zero. 

I tried the following script that i found elsewhere, however it doesn't seem to work in o365. 

NWF$(document).ready(function()

   var number = NWF$('#'+Number).val();
   if(number == 0)
   {
     NWF$('#'+Number).val('');
   }
});

 

 

1 reply

DAGiessenburg
Forum|alt.badge.img+4

Nintex office 365 doesnt support Javascript.

 

You need to check on Empty value (Null)?

In formula or Rules you can use the formula IsNullorEmpty()

 

Returns TRUE where value has no data content.
isNullOrEmpty(value)

 

https://help.nintex.com/en-US/o365/Designer/Functions/isNullOrEmpty.htm?TocPath=Work%20with%20the%20basics%7CLearn%20the%20designer%7CForms%20designer%20and%20tools%7CNew%20Responsive%20Forms%20designer%7CFormula%20builder%7C_____16