Copy link to clipboard
Copied
I am using Adobe Acrobat Pro DC. I am creating a pdf fillable form, which contains fields for areal space measurements. I would like to multiply two fields (variable values), divide the result by a set value number and have that result displayed in a separate field to reflect number of acres in the area. For example: length X width / 43,560 = #Acres
Can anyone advise please as to what script/formula to use for this fillable adobe form?
Copy link to clipboard
Copied
Let's say the fields are called "Length", "Width" and "Acres".
Under the Calculate tab of Acres select the second option "Simplified field notation", and then enter this formula:
Length * Width / 43560
That's all there is to it...
Copy link to clipboard
Copied
Thank you! That fixed it.
Copy link to clipboard
Copied
Good afternoon, I am new to this so giving this a try. I am creating a score card and need some assistance on adding some numbers and then diving the total by a set number ranging from 1 to 3. I have attached a photo of what I am referring to. I can add the numbers but having trouble with the division part of it. In summary, it needs to be total score divided by total number of trades (1-3) as noted for an average score. Any help would be much appreciated.
Copy link to clipboard
Copied
Please start a new thread
Use the Acrobat JavaScript Reference early and often
Copy link to clipboard
Copied
I'm trying to subtract one field from the other. In Simplified field notation of the answer field, I'm entering:
1st field-2nd field.
I tried including an = before the 1st field. I tried adding = the destination field after the 2nd field.
Nothing seems to work.
Help is greatly appreciated!
Thank you much.
Anthony
Copy link to clipboard
Copied
For Simplified Field Notation the field names must not contain spaces or punctuation. Which means you need to change both the field names and the SFN script.
Use the Acrobat JavaScript Reference early and often
Copy link to clipboard
Copied
What if I want to have a date entered on a form and then have the next field calculate 15 calendar days and have that date listed. For example, the date a form is submitted to me starts a 15 day waiting period that I need to know the date of.
Copy link to clipboard
Copied
Dates are handled differently than numbers. They are more complictated. You'll find lots of scripts for adding days to a date on this forum. It's a common question.
Here's an example validation script for the field where the date is entered.
var dtStart = util.scand("mm/dd/yyyy", event.value);
if(dtStart)
{
dtStart.setDate(dtStart.getDate() + 15);
this.getField("NextField").value = util.printd("mm/dd/yyyy", dtStart);
}
Use the Acrobat JavaScript Reference early and often
Copy link to clipboard
Copied
Thank you, Thom. That was extremely helpful and worked like a charm.


-
- 1
- 2