cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

Blank out a number field that defaults to zero.

I have a SharePoint 2013 on prem list that has a number field. Most of the time when a form is filled out this field is left blank (as it needs to show). We report off of this field and need for it to show blank and not "0". 

Is there a way for me to do this with either forms or workflows?

Thanks

Labels: (1)
0 Kudos
Reply
3 Replies
Highlighted
Nintex Newbie

Re: Blank out a number field that defaults to zero.

Hi Ryan McDeavitt,

In column settings you can clear out the default value.

Or, If you want you can do using JavaScript also. Name number control's JavaScript variable as 'Number'.

Add this code in form settings->Custom Javascript

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

 Thanks,

Lakshmi C

0 Kudos
Reply
Highlighted
Automation Master
Automation Master

Re: Blank out a number field that defaults to zero.

how do you have configured default value in list field and form control?

if neither of the two is configured, field should left blank.

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Blank out a number field that defaults to zero.

Hi @lakshminarayana 

Can I use that java script in a 365 task form? It doesn't error when i publish the workflow, however the task form refuses to open. It sits there trying to open. 

NWF$(document).ready(function()

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