Adobe Acrobat - Submit Form - Export Data to Excel (On SharePoint, if possible?)
Copy link to clipboard
Copied
The title says it all, but we're hoping to create a Submit Form button that will send the form data to an Excel .XLS document in our SharePoint (webserver). We're looking into Web-forms in our Adobe Sign Enterprise account but that also has limitations. Please consider this issue and let me know if you have insight and we could possibly meet to discuss. Thank you!
Copy link to clipboard
Copied
Hi there
Hope you are doing well and sorry to hear that.
As described, you to create a Submit Form button that will send the form data to an Excel .XLS document in our SharePoint (webserver)
Please go through the help page https://helpx.adobe.com/acrobat/using/setting-action-buttons-pdf-forms.html and see if that works for you.
Additional information: You may also check out the help page https://helpx.adobe.com/acrobat/using/publishing-interactive-pdf-web-forms.html
Regards
Amal
Amal
Copy link to clipboard
Copied
Thank you Amal,
I've seen all this, however, I cannot seem to make the FDF file open in any kind of a workable format or send it to SharePoint to which we'd like that data to add to a currently existing spreadsheet.
Thank you for any more information you can share!
Copy link to clipboard
Copied
If you have a technical person available that can code a solution for you, you can automate to do the following:
1- set the data to be sent as HTML (this will send the data as field1=somevalue&field2=anothervalue...
2 - the data is passed to your web server as a raw stream of hex data. Decode the data from Base64 hex and then parse the query string
3 - save these parsed values to your excel file based on the field name. It might be easier to save as a CSV rather than XLS
Hope this helps.
Joe
Copy link to clipboard
Copied
If you gather up the returned forms/data, you can export the data into a spreadsheet.
It's not automated but probably could be with either Actions or a script.
Copy link to clipboard
Copied
Thank you David,
I've seen that too, however, we're looking automate this as much as possible. I think you're right that it will end up being a Javascript button but we're still looking for the path of least resistance. Currently, I'm looking into Web Forms in Adobe Sign and Power Automation.
If you have any experience with those tools I'd love to talk more about it?
Copy link to clipboard
Copied
No, can't help much there.
Another possibility might be the Adobe Experience Manager (AEM) forms.

