I have a value that always needs to be rounded to a nearest multiple, usually 4 or 6 (based on another value). We usually deal with values in the hundreds, but this number must always be rounded to a multiple. As data entry is manual, this often gets messed up.
Is there a way to automatically round the number up, on submit? Or even better, is it possible to have a dropdown appear under a number field that will show the rounded up number as a user types, so that they can click it?
Think, someone ordering a bunch of individual items, that come in bundles of 4, or 6.