try67
Community Expert
try67
Community Expert
Activity
‎Aug 29, 2016
10:01 AM
Reader is a stripped, free version of Acrobat, but in this case it has features that your version doesn't...
... View more
‎Aug 29, 2016
09:46 AM
It happens because your invoices contain form fields, and fields with the same name in a single file will always have the same value. The solution is to flatten the files before merging them, converting the form fields into static content. If you have Acrobat Pro then you can do it using a simple Action. Otherwise you'll need to do each file separately.
... View more
‎Aug 29, 2016
09:37 AM
1 Upvote
Acrobat is not the same as Reader... In Acrobat this option is only available in the Continuous (Subscription) track, not the Classic track.
... View more
‎Aug 29, 2016
08:51 AM
2 Upvotes
So the formula is not: stddev = sqrt (sum (sampleXRow1 - average)^2 / (n-1)) But: stddev = sqrt (sum ((sampleXRow1 - average)^2) / (n-1)) So the code should be something like this: var avg = Number(this.getField("AverageRow1").valueAsString); var sum = 0; var n = 0; for (var i=1; i<=8; i++) { var v = this.getField("sample"+i+"Row1").valueAsString; if (v!="") { sum+=Math.pow((Number(v)-avg),2); n++; } } if (n==0 || n==1) event.value = ""; else event.value = Math.sqrt(sum / (n-1));
... View more
‎Aug 29, 2016
08:11 AM
I also think there's something wrong with your formula, because it seems to me that the sum of all the values minus the average will always be zero...
... View more
‎Aug 29, 2016
08:05 AM
Never mind, got it now... The field names you provided were not accurate. Open the JS Console and you'll see an error message about the "Average" field. The actual name seems to be "AverageRow1", so adjust it accordingly in the code.
... View more
‎Aug 29, 2016
08:03 AM
Are you sure? It seems like you sent an email to the forum, instead...
... View more
‎Aug 29, 2016
08:01 AM
If you want JavaScript to capture the mouse coordinates, you'll need to cover the entire page with a button field which may not be practical. Not true. You can use the mouseX and mouseY properties, as I've mentioned. Edit: Unless you mean that the button will also trigger the script itself, in which case you're correct. But it can still be done using the keyboard if the button is added to the application menus.
... View more
‎Aug 29, 2016
07:52 AM
Yes, it does, actually. It's called Adobe LiveCycle Designer, and it also generates PDF files, but the technology behind them is very different to that used by Acrobat.
... View more
‎Aug 29, 2016
07:46 AM
There's no such option in Acrobat forms. You can try to do it using a script, but it's quite complicated and will probably not work very well.
... View more
‎Aug 29, 2016
07:46 AM
1 Upvote
You can use the document's Will Save event to do that. You'll find it under Tools - JavaScript - Set Document Actions.
... View more
‎Aug 29, 2016
07:44 AM
The actual PDF file. You can either send it to me directly (try6767 at gmail.com) or upload it to something like Dropbox and post a share link here on the forum.
... View more
‎Aug 29, 2016
07:26 AM
1 Upvote
You need to upgrade to Reader DC to have this feature.
... View more
‎Aug 29, 2016
07:18 AM
I'll need to see the actual file to help you further.
... View more
‎Aug 29, 2016
06:59 AM
Change line #5 to: var v = this.getField("sample"+i+"Row1").valueAsString; Regarding the Average field, you need to double-check how it works. I think that it includes empty fields as zero in the calculations, which might not be what you want.
... View more
‎Aug 29, 2016
06:43 AM
Not 100% sure about this code, but give it a try... var avg = Number(this.getField("Average").valueAsString); var sum = 0; var n = 0; for (var i=1; i<=8; i++) { var v = this.getField("sample"+i+"Row1").valueAsString; if (v!="") { sum+=(Number(v)-avg); n++; } } if (n==0 || n==1) event.value = ""; else event.value = Math.sqrt(Math.pow(sum,2) / (n-1)); I assume that "n" stands for the number of (filled-in) fields. I'm not sure how are you calculating the average, though, and if you're including empty fields in this calculation... Edit: Syntax error fixed
... View more
‎Aug 29, 2016
05:37 AM
Just to clarify, I'm still talking about using addField. I don't think it can be done the way you've described.
... View more
‎Aug 29, 2016
05:21 AM
Does it not work if you press Ctrl+A inside the Comments List panel? Or if you click on the first comment and then Shift+click the last one?
... View more
‎Aug 29, 2016
05:19 AM
What do you see under the field's Properties, then?
... View more
‎Aug 29, 2016
05:19 AM
[Question moved to the Acrobat PDF Forms forum]
... View more
‎Aug 29, 2016
05:18 AM
[Question moved to the Acrobat Rich Media & 3D forum]
... View more
‎Aug 29, 2016
04:57 AM
What do you mean?
... View more
‎Aug 29, 2016
04:46 AM
That's possible, but it means you will have to execute the command using only the keyboard, which is a bit tricky (but not impossible)... You can use the mouseX and mouseY properties of the Document object to get the current location of the mouse, in default user space in relation to the current page.
... View more
‎Aug 29, 2016
04:43 AM
Use Save As...
... View more
‎Aug 29, 2016
04:42 AM
No, it can be done using a single button.
... View more
‎Aug 29, 2016
03:31 AM
You should use the addField method of the Document object if you want to add a check-box field.
... View more
‎Aug 29, 2016
03:01 AM
This is quite tricky to achieve in an Acrobat PDF form. What can be done is to create these fields in advance and then show/hide them when needed, but keep in mind that it won't "reflow" the rest of the contents on the page, so when the fields are hidden you'll basically have a big white space in the middle of your page...
... View more
‎Aug 29, 2016
03:00 AM
What version of Office do you have?
... View more
‎Aug 29, 2016
02:32 AM
Welcome to the wonderful world of PDF Forms... Don't expect what you're used to in Excel to work here. It's a very different (and sometimes confusing) world. To answer your questions: - No, you can't force the fields detection wizard to detect your fields. If it works, great, if it doesn't then you need to do it manually (or using scripts). It never works perfectly, but it usually generates something you can use as a starting-point. - Actions associates with fields can't be applied to multiple fields at once using the built-in GUI, unlike properties. What you can do is set one field as you want it to be, and then copy and paste it multiple times, or use the Create Multiple Copies command, and the Actions associated with it will be carried over to the new fields. Another option is to use a script to apply the same Actions to multiple fields at once, like this script I've created: Custom-made Adobe Scripts: Acrobat -- Mass Edit Fields Actions - Regarding the calculations: If you use consistent field-names (ie, Cost1, Cost2, Cost3, Quantity1, Quantity2, Quantity3, etc.) then you can write a generic script to do all of the calculations you won't need to manually apply a different calculations for each row. That is a little bit complicated for someone without knowledge at all, but not too much. A good tutorial about calculations in PDF fields can be found here: https://acrobatusers.com/tutorials/how-to-do-not-so-simple-form-calculations Good luck!
... View more
‎Aug 29, 2016
02:16 AM
Let's say the export values of these boxes are 1, 2 and 3, and you want to show the other field (let's say it's called "Reference") if "2" is selected. As the MouseUp event of all three boxes enter this code: this.getField("Reference").display = (event.target.valueAsString=="2") ? display.visible : display.hidden;
... View more