Skip to main content

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?

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


Reply