If I have 4 columns and the 1st column a person enters a value between 1-10, I want it so that if they enter 1-3 it appears in the 2nd column, 4-6 it appears in the 3rd column and 7-10 it appears in the 4th column. How do I do that?


OK, I've written for you a generic function that you could use for all the fields. You just need to specify the min and max values.
The function code (which should be placed as a doc-level script) is:
function showScore(min, max) {
var rowNumber = event.target.replace(/\D/, "");
var v = Number(this.getField(rowNumber+"A").valueAsString);
event.value = (v>=min && v<=max) ? v : "";
}
You then call it from the custom calculation script of your fields like this:
showScore(1,3);
Or:
showScore(4,6);
etc.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.