Skip to main content
Nintex Community Menu Bar

Is there a way to prevent blank fields from saving 0's in them when the form is submitted?

  • October 27, 2016
  • 1 reply
  • 5 views

Forum|alt.badge.img+3

I have a form that has a field for UPC codes which has a validation to make sure that it's formatted as a 12-digit number. However the form can be submitted without this information. What's happening is when the field is left blank and saved to be processed by others, a 0 is entered in. This causes the next person in the workflow having to go through and delete the zero because of the validation rule in order to submit the form.

Is there a way to prevent the zero from being saved in there when the form is submitted?

1 reply

Forum|alt.badge.img+8
  • October 27, 2016

Hi ‌,

This is default SharePoint behavior when using a field of type 'Number'. A field of type 'Single Line of Text' does not have this "drawback".

Cheers,

Rick