Copy link to clipboard
Copied
Very new to Adobe!! I have a form that I am working on that I need help with from you awesome, more experienced people! 🙂
I have a field, total3 that is the sum of other fields. (works perfect) I have another field, total6, that I need to be total3 divided by 6 IF total3 is greater than 300. If total3 is less than 300, then total6 would be zero.
Any takers to help me out??
Enter the following custom calculation script total 6:
var ttl3=this.getField("total3").value;
if(ttl3>300)
{event.value=ttl3/6}
else
{event.value=0}
This does not cover when ttl 3 is exactly 300. If you want 300 included in the greater than statement us >=. If you want the 300 result to be zero, leave as is.
Copy link to clipboard
Copied
Enter the following custom calculation script total 6:
var ttl3=this.getField("total3").value;
if(ttl3>300)
{event.value=ttl3/6}
else
{event.value=0}
This does not cover when ttl 3 is exactly 300. If you want 300 included in the greater than statement us >=. If you want the 300 result to be zero, leave as is.
Copy link to clipboard
Copied
Thank you so much!! Worked like a charm. 🙂