I have field1 and field 2, on field 1 I have app.alert to limit me from entering specific value from field 2 even though field 1
doesn't calculate that value when alert pop it
still change value in field2. What I need to do so when I get alert that field2 stay same and doesn't change it's current value?
Sorry but it's not working for me as intended. All I need is if I get app.alert from field1 after entering value in field2, field2 need to return to it's previous value before app.alert.
Then modify my custom calculation script above for Field2 like this:
if (event.value <= 30) {
this.getField("Field1").value = event.value;
} else {
if (event.value > 30) { event.value = this.getField("Field1").value;
}
}
Don't change anything. Try it out first as instructed.
In the solution I am giving to you the app alert is not executed in Field1. If you have any calutlations or app.alert scripts in Field1 get rid of it. Or we will continue like the chicken or the egg story of what came first.
Everything will run from Field2 in this example.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
AdChoices