-
1. Re: How can I validate that a calculated field equals a specific number?
try67 Apr 23, 2013 9:50 AM (in response to lmphil)And what should happen if it's not equal to 100? Also, should it check if the other fields are filled-in at all? And what if just one of them is 100?
-
2. Re: How can I validate that a calculated field equals a specific number?
lmphil Apr 23, 2013 11:05 AM (in response to try67)Thanks for your response. If the sum of the values in the calculated field does not equal 100%, an alert should appear to indicate that the sum of those fields must equal 100%. As far as checking whether both of the fields being calculated, that is not as important; only one of those fields could have an entry as long as it equals 100%. Does that help? Thanks again for your help.
-
3. Re: How can I validate that a calculated field equals a specific number?
try67 Apr 23, 2013 12:33 PM (in response to lmphil)You can use sometthing like this as the custom calculation script:
if ((+event.value)!=0) {
if ((+event.value)!=100) {
app.alert("The sum of the percentages must equal 100%.");
}
}
-
4. Re: How can I validate that a calculated field equals a specific number?
lmphil Apr 23, 2013 12:40 PM (in response to try67)Thank you!!! You are a genius!


