0

Obviously it is for an HR form that only lets users enter increments of 4 or 8 for the value entered. So I figured one way may be is to take the inputted number, divide it by 4 and see if I get a whole number by using conditions. If it is not divisible by 4 then a decimal would appear making it known it is not divisible by 4 with a return of a whole number. I looked at all the functions and I can't find one that one would sort this out.

  • try validation in infopath, there you can use formulas mod. – ThinkB4Code Apr 4 '18 at 3:30
  • I have mentioned that but I do not know how to code it to do as I'd like. – Mike Rooker Apr 4 '18 at 4:33
1

Follow the steps below:

  1. Add an additional field named “modValue” and set the default value to number mod 4.

    enter image description here

  2. Remove the field from the form to make it as a hidden field.

  3. Select the number field and add a Validation rule.

    enter image description here

Condition:

enter image description here

  • JoannaW_MSFT you are amazing!! You totally rock. Thank you! Wishing you good karma!! :) – Mike Rooker Apr 4 '18 at 15:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.