Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Exit
Monteigo99
Explorer
Monteigo99
Explorer
Activity
‎Jun 29, 2018
04:53 PM
Woohoo! Got it and it works. Thank you sooooo much. It's funny, you seem to always be the one who provides my answers.
... View more
‎Jun 29, 2018
03:53 PM
Hello Try67, So, I don't have the Porfolio option on my Adobe Acrobat Pro DC. Any idea why? I have combine, but when I use that it doesn't work. All the fields in the different docs with the same name synchronize to a single entry.
... View more
‎Jun 29, 2018
01:05 PM
Hello, I am trying to figure out how to combine multiple single page forms that gets filled out with specific Physician information into a single file without the fields changing to the first forms field data. Can I enter some kind of .js to keep the fields from merging/synchronizing? Thank you Makr
... View more
‎Jun 29, 2018
12:58 PM
Hello, I am trying to figure out how to combine multiple single page forms that gets filled out with specific Physician information into a single file without the fields changing to the first forms field data. Thank you Makr
... View more
‎Jun 20, 2017
09:48 AM
Karl, this.saveAs(outputDir + this.getField("Text1").value + "_" + this.getField("Text2").value + ".pdf"); // saves the file idx++; This is from your blog that I gathered the script from. It looks like the idx++; is missing after the ".pdf"); which it is not but it doesn't show the 'enter' that separates it from the 'saves the file. This is my new script and it is important to point out a couple things that us novices need to be careful of. 1) that the this.resetForm needs to go after the idx++; in order for it to populate the form first. I tried it in 3 separate locations and it broke the js. 2) when copying and pasting your script, the idx++; actually flows with the "saves the file" unless there is an enter after "file". This script just saved my office about 150 hrs per year. Thank you so much, Karl. (I'll post this on your consulting blog too.) Thank you too, Try67; you've been a significant help in the past with my js education. Here is the full code. /* Autofill OPPE Records */ // specify the filename of the data file var fileName = "/c/Users/XXX/Desktop/Temp Files/NeuroTestDatafile.txt"; var outputDir = "/c/Users/XXX/Desktop/Temp Files/OPPEAutoPopTest/"; var err = 0; var idx = 0; while (err == 0){ err = this.importTextData(fileName, idx); // imports the next record if (err == -1) app.alert("Error: Cannot Open File"); else if (err == -2) app.alert("Error: Cannot Load Data"); else if (err == 1) app.alert("Warning: User Cancelled File Select"); else if (err == 2) app.alert("Warning: User Cancelled Row Select"); else if (err == 3) app.alert("Warning: Missing Data"); else if (err == 0){ this.saveAs(outputDir + this.getField("Provider").value + ".pdf");idx++; // saves the file idx++; this.resetForm(); } }
... View more
‎Jun 19, 2017
04:57 PM
OMG! I've made some headway! After testing out what Karl suggested, I discovered what the first problem was. 1) My this.getField is the Provider name field. When I looked at the txt file, it surrounds ONLY the Provider name (not the other fields) with quotes, e.g. "Last,First M". This is the File path issue. So, I was able to get it to start processing through all the files. Next problem. 2) As I watched the save to folder populate, it would create the first file based upon the field name, then I'd see the tmp pdf file churn as if it was opening the txt file again, but then it would only extract the first record and save as the same file over and over again. So, it would just keep saving as the same file name and not the successive records. I fixed item 1. Now, what is wrong with the script that keeps it from advancing to the next record? How does the script know that it should look at row 2, row 3, etc.? /* Autofill OPPE Records */ // specify the filename of the data file var fileName = "/c/Users/XXX/Desktop/Temp Files/NeuroTestDatafile.txt"; var outputDir = "/c/Users/XXX/Desktop/Temp Files/OPPEAutoPopTest/"; var err = 0; var idx = 0; while (err == 0){ err = this.importTextData(fileName, idx); // imports the next record if (err == -1) app.alert("Error: Cannot Open File"); else if (err == -2) app.alert("Error: Cannot Load Data"); else if (err == 1) app.alert("Warning: Missing Data"); else if (err == 2) app.alert("Warning: User Cancelled Row Select"); else if (err == 3) app.alert("Warning: Missing Data"); else if (err == 0){ this.saveAs(outputDir + this.getField("Provider").value + ".pdf") } }
... View more
‎Jun 19, 2017
03:04 PM
Hello Try67, That looks very useful, however, I am not looking to email, nor create a single file that includes multiple individuals. I need a single file for each record in the txt file. In addition, while I am advocating for consulting resources, your product would have to get approved by our National office, and you would have to be vetted as a vendor for a contract through GSA. There are some workarounds for some adhoc consulting fees, but I've not gained fund approval for that as yet in my Federal Agency.
... View more
‎Jun 19, 2017
01:02 PM
I did convert the windows format to the PDF required format. The save folder location is in the same location as the txt file, and the path reads the txt file for the first record, populates the form, and then says it was successful. It just won't save. Apparently, I am not asking the correct questions. How about this: I need to batch import records, autopopulate the form, save the form with the 'Provider' field in the file name, and then move to the next record and repeat for my 1000 plus files. Can anyone suggest a script that would allow me to do this?
... View more
‎Jun 19, 2017
12:57 PM
Hey Karl, this is actually your script. I've communicated with you several times on your consulting website, but after reviewing 2-3 years worth of comments, I came up with it being the security issues with saving to a Privilege folder with Trust Functions. I don't quite understand how to do this though.
... View more
‎Jun 19, 2017
12:48 PM
So, although I'm saving to a local drive, it is still heavily securitized, and it does not save to any of my network drives either, as I've tried several different scenarios. The script states that it runs successfully under the action, but does have errors in the Console. The current script is being run through the Action Tab in which I created a new action. This is from the 'FULL REPORT' Link: Action Name: AutoPopALL [-]TestOPPEForms2.pdf(Succeeded) Execute JavaScript Command Name: Execute JavaScript Command Start Time: 2017-06-19 12:44:02 Command Status: Succeeded Command Finish Time: 2017-06-19 12:44:03 This is the error from the Debugger Console: ReferenceError: Percent is not defined 1:Field:Validate ReferenceError: Percent is not defined 1:Field:Validate UnsupportedValueError: Value is unsupported. ===> Parameter cPath. Doc.saveAs:26:Batch undefined:Exec I know my path is correct.
... View more
‎Jun 19, 2017
10:55 AM
I appreciate your attempt at assisting, but I'm past all the errors, I know what I need. Can you assist in providing the specific script edits required to get past saving to a highly secured network?
... View more
‎Jun 19, 2017
10:41 AM
Thank you for responding, but that is what I'm doing. The action requires a script and I am trying to write the script per above.
... View more
‎Jun 19, 2017
09:30 AM
Hello all, I'm lost and have been struggling with this for a couple weeks now. I am a decent beginner level who can understand js, copy it and past, then modify to get it working. I am much more limited with regards to creating new scripts from scratch. I have a js 'Action' that performs a batch import: locates txt file, imports data for first record, saves the file with one of the field names, then automatically, pulls the next record and repeats. I'm using Acrobat Pro XI. The problem is that while it populates the data, it will not save the new file to my folder, and thus, will not proceed to the next file. I have performed the research and have traced the problem to the security issues associated with saving files on my company's drives. I believe this is a Trust function and Privilege scripting. I don't quite seem to understand 1) how to create a .js file that I save in the javacript folder, 2) the javascript folder location is different from where I have seen in blogs that it is supposed to be (it is here: C:\Program Files (x86)\Adobe\Acrobat 11.0\Acrobat\Javascripts), and 3) the difference between writing the trust script into the Action js and simply creating a js to go and retrieve the trusted script from the js file. I have tried all sorts of variations to no avail. Any assistance would be really appreciated. Current script: /* Autofill OPPE Records */ // specify the filename of the data file var fileName = "/c/Users/XXXXX/Desktop/Temp Files/NeuroTestDatafile.txt"; var outputDir = "/c/Users/XXXXX/Desktop/Temp Files/OPPEAutoPopTest/"; var err = 0; var idx = 0; while (err == 0){ err = this.importTextData(fileName, idx); // imports the next record if (err == -1) app.alert("Error: Cannot Open File"); else if (err == -2) app.alert("Error: Cannot Load Data"); else if (err == 1) app.alert("Warning: Missing Data"); else if (err == 2) app.alert("Warning: User Cancelled Row Select"); else if (err == 3) app.alert("Warning: Missing Data"); else if (err == 0){ this.saveAs(outputDir + this.getField("Provider").value + ".pdf") } }
... View more
‎Aug 25, 2016
01:37 PM
I have two fields that calculate from the same 5 drop downs. The % field calculates from the '0 of 0' field. I want to count the yes's and no's and have it populate, but I only want it to say N/A if ALL 5 drop downs are N/A. If 1) <5 dropdowns are NA and the others are blank, I want both calc fields to be blank, 2) all drops are blank, then calc's are blank. The scripts are different for each calc field due to the percentage. Did that make sense? My government securities would not allow the example link locations to be viewed.
... View more
‎Aug 25, 2016
01:20 PM
I get that, but this was what happened. When I went from this: if (totalNA==5) event.value = "N/A"; else event.value = totalY + " of " + total; To this: if (totalNA==5) event.value = "N/A"; if (totalY==0 || total==0) event.value = ""; else event.value = totalY + " of " + total; the blank field worked but it negated the N/A. I think what would work is if I could say, but I can't find reference for this: if (totalY==0 || total==0) AND (totalNA<5) event.value = "";
... View more
‎Aug 25, 2016
12:55 PM
Ok, I have to study that one a bit. I had to adjust the event.values because once I plugged in the requested script, it would no longer recognize the totalNA script. Why can't I get ALL of these to function. I can only get 2 of the 4 to work at a time. if (totalNA==5) event.value = "N/A"; if (totalY==0 || total==0) event.value = ""; if (total==0) event.value = totalY+ " of " + total; else event.value = totalY + " of " + total;
... View more
‎Aug 25, 2016
11:04 AM
Thank you once again Try67, it works for the '0 of 0' field but not the % Is there something else I have to do for that field. I know % outputs sort of screw some things up.
... View more
‎Aug 23, 2016
05:27 PM
Hello, I have a form with 5 fields that are drop down boxes. There are 4 choices: Blank (default), Y, N, N/A. I have two fields that produce a calculation. One returns '# of #' and the other produces a % of Y's. In the default state of blank, the calculations are '0 of 0' and '0%'. The problem is that, unfortunately, some providers will want a printed hardcopy to fill out and the fields have these zero's in them. How can I make the field so blank? I have tried several variations to no avail. 1st script '0 of 0': var totalY = 0; var total = 0; for (var i=1; i<=5; i++) { var f = this.getField("JJCRDropdown"+i); if (f.valueAsString=="Y") { totalY++; total++; } else if (f.valueAsString=="N") { total++; } } if (total==0) event.value = ""; else event.value = totalY / total; 2nd script '0%': var totalY = 0; var total = 0; for (var i=1; i<=5; i++) { var f = this.getField("JJCRDropdown"+i); if (f.valueAsString=="Y") { totalY++; total++; } else if (f.valueAsString=="N") { total++; } } if (total==0) event.value = ""; else event.value = totalY / total;
... View more
‎Aug 03, 2016
04:43 PM
This is fun. This is what I came up with. Thanks var totalY = 0; var total = 0; var totalNA = 0; for (var i=1; i<=5; i++) { var f = this.getField("JJCRDropdown"+i); if (f.valueAsString=="Y") { totalY++; total++; } else if (f.valueAsString=="N") { total++; } else if (f.valueAsString=="N/A") { totalNA++; } } if (totalNA==5) event.value = "N/A"; else event.value = totalY + " of " + total;
... View more
‎Aug 03, 2016
11:48 AM
Apologies. This was just a copy and paste error. var totalY = 0; var total = 0; for
... View more
‎Aug 02, 2016
04:20 PM
I'm still learning and have a script as follows: var totalY = 0; var total = 0; for var totalY = 0; var total = 0; for (var i=1; i<=5; i++) { var f = this.getField("JDCRDropdown"+i); if (f.valueAsString=="Y") { totalY++; total++; } else if (f.valueAsString=="N") { total++; } } if (total==0) event.value = "N/A"; else event.value = totalY + " of " + total; The problem is that and N/A is different than zero of zero. If I leave as is, then the output field defaults to N/A. If I remove: if (total==0) event.value = "N/A"; then it spits out 0 of 0 as the default. What I need is for it to default to 0 of 0, UNLESS all 5 fields are N/A. Then I need the output to be N/A. ALL 5 fields must have N/A selected in order for it to populate N/A. I've attempted a few different scripts to no avail. Thanks
... View more
‎Jul 14, 2016
11:58 AM
Yep, that's what I found. It works now. Thank you
... View more
‎Jul 14, 2016
10:13 AM
I've derived this formula that works for 5 of 6 fields. On the 6th field it is a one adjustment calculation delayed (I have 5 Y/N drop down list options that get calculated in a field, one for the first 6mths, then on another field for the second 6 mths). What's wrong with this? var v1 = Number(this.getField("JJNotesCompletionRate").valueAsString); var v2 = Number(this.getField("JDNotesCompletionRate").valueAsString); if(v2>0) { event.value = (v1+v2)/2; } else { event.value = v1;}
... View more
‎Jul 14, 2016
08:18 AM
If V2>0, then add v1+v2, if it is false, then v1. Is that what you're asking? Thanks
... View more
‎Jul 13, 2016
04:59 PM
So, the above script works but I just figured out that I need the event.value to only calculate if v2 is >0. I tried this but it didn't work. Any assistance is appreciated. var v1 = Number(this.getField("JJPC_MCKTOTAL1").valueAsString); var v2 = Number(this.getField("JDPC_MCKTOTAL1").valueAsString); event.value = If((v2>0),(v1+v2)/2,v1);
... View more
‎Jul 07, 2016
01:07 PM
It worked! Thank you. var v1 = Number(this.getField("JJPC_MCKTOTAL1").valueAsString); var v2 = Number(this.getField("JDPC_MCKTOTAL1").valueAsString); event.value = (v1+v2)/2;
... View more
‎Jul 07, 2016
12:21 PM
Thank you. The two fields are different; they have different names. I can't use the simplified field because it doesn't have secondary functions; e.g. it will add ONLY, but will not then divide. I'm an advanced form creator, except when it comes to JavaScript. I've searched all over the internet for this script, but all I get is simple tutorials that do not provide the structure of the entire syntax with all the {,},; etc. I don't know how to structure the script properly.
... View more
‎Jul 06, 2016
01:22 PM
(JJPC MCKTOTAL1 + JDPC MCKTOTAL1)/2 Can someone provide a Script for me to evaluate? Thank you
... View more
‎Jun 29, 2016
02:10 PM
It worked. Thanks Karl! Creating PDF forms is only one responsibility in the entire process lifecycle. I am just learning how to do this, but I learn fast. Sometimes, I will need the entire script until I get better at it. Unfortunately, I only do this type of work every so often. Thank you so much.
... View more
‎Jun 29, 2016
12:48 PM
Thank you Karl, Unfortunately, that doesn't work. 1) it only accounts for Y; I need Y & N total 2) I have 20 fields with the same name with 1-20 tacted on. But I only need 1-5, then 6-10, etc. So your group function doesn't work effectively 3) the final output is a single #. I need '# of #'; as in '3 of 4'. This is the script that I used to produce a %. Can this be modified to produce '# of #'? var totalY = 0; var total = 0; for (var i=1; i<=5; i++) { var f = this.getField("CRDropdown"+i); if (f.valueAsString=="Y") { totalY++; total++; } else if (f.valueAsString=="N") { total++; } } if (total==0) event.value = ""; else event.value = totalY / total;
... View more
Copyright © 2025 Adobe. All rights reserved.
AdChoices