// Get first field value
var v1 = getField("AnnInc").value;
event.value = v1 / 12;
I have a request to allow users to input either Annual or Monthly income to drive the rest of the worksheet calcs. I know there's got to be an easy way to do this but am at a loss. How can I make these two fields update each other accordingly? So if the user chooses to put in monthly or annual those two fields update each other?
It's possible, but isn't something you see done a lot. For a sample that demonstrates this type of thing, see: https://workspaces.acrobat.com/?d=ciEidIeR5cjGuadg7A-QUw
Each text field has a custom Calculate script. The field value is calculated only when the other field value changes.
Thank you! This worked!