RE: A field which returns a value that is a multiple of another value

I have a integer field on the item record called the “pack size”  {packsize}

I would like to create a new integer field “minimum order quantity” {MOQ}.

The requirement is to make the {MOQ} field only allow a user to enter a multiple of the {packsize}.

Can someone assist me with a formula that I could use in a workflow or on the field setup to restrict entry of the {MOQ} so its only multiples of the {packsize} field?

 

EXAMPLE

IF {pack size} = 6

THEN {MOQ} = should only allow values = 6,12,18,24,30…etc.

yoantny Rookie Asked on June 5, 2020 in Items.
Add Comment
2 Answers

You can use another custom field as the multiplier and make MOQ a formula which multiplies packsize by the multiplier.

Intermediate Answered on June 5, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.