Skip to main content
smithalanw
New Participant
November 7, 2018
Question

Is it possible to do these things with a submit button on a form?

  • November 7, 2018
  • 2 replies
  • 639 views

I'm using Acrobat 2017 on a Windows 10 machine and trying to automate some functions on a PDF form.  I have been reading the forums and I'm not even sure it is possible now.  Could someone on this forum please save me some time and tell me if this even possible so I can drop it if I can't even do it?

1. Save the data from the PDF form to an Excel spreadsheet to a specified location on a SharePoint server.

2. Flatten the file and save the whole PDF to a specified location on a SharePoint server.

3. Save the file again to a dynamically set folder on a SharePoint server.

4. Delete the original file from the SharePoint location it was opened from.

I'm finding precious little in the forums to help me out, so if there is another way to get the same results with different actions, I'd be happy for that advice too.

Thank you all for the time you put into these forums to help people like me! 

This topic has been closed for replies.

2 replies

try67
Community Expert
November 7, 2018

1-3. Possible, but requires installing a script on the local machine of each user who is going to use it. See: https://acrobatusers.com/tutorials/how-save-pdf-acrobat-javascript

#3 requires them having Acrobat, not just the free Reader.

4. Not possible.

try67
Community Expert
November 7, 2018

1. Actually, that is not possible if you mean that you want to export the values to an existing file. You can create a new file, though.

smithalanw
New Participant
November 7, 2018

Can I append the form data to an existing file and save it with a new name?  If not, I'll have to skip flattening the file and export the data from the completed forms in the folder to an Excel file as an action.  Does that sound like it would be the proper way to do it?

Bernd Alheit
Community Expert
November 7, 2018

4. Adobe Acrobat Javascript can't delete files.

smithalanw
New Participant
November 7, 2018

Thank you for your rapid response, sir!

So can everything else can be done from a submit button?  Specifically a submit button created with JS that performs these functions?

I'm thinking of one Mouse Up trigger with three "Run a JavaScript" actions:

1. Submit data to an Excel file in a static SharePoint location specified in the JS.

2. Flatten the file, then Submit the completed PDF form to a static SharePoint location specified in JS.

3. Submit completed PDF form to second, dynamic, SharePoint location specified in JS using data from one of the form fields to set the last folder.  (The folder structure would be created in SharePoint in advance, since Acrobat can't do that.)

I can easily delete the files in one quick operation later.