fillable form with data tracked in excel

[Shannon27462759m995]

I take calls all day to schedule customer appointments for our installers. I need to fill out the fillable form and have it auto save to a folder with one of the fields being the file name AND allows for exporting of all pdf data to be sent to an excel for later.

Example Customer 1 calls in. I enter all info. I print copy then would like to  save/submit form to a folder on my computer . Customer 2 calls in I repeat process above.  at end of day or week I would like to compile all the data from the fillable form of the customers data to an excel spreadsheet without having to export each pdf each time. 

Even saving them each time is an issue itself. 1.problem is the form name is what the file always saves as so obviously all customers cant have same file name. I tried web form also and that didnt work either since I am literally the only person entering the information into the form .

[try67]

Yes, this is possible. A script can be used to save the file under a specific name in a specific folder, and then clear it and allow you to start over. It requires some custom development and the script file itself needs to be placed in a specific folder on the computer. If you're interested in hiring a professional to create it for you, feel free to contact me privately by clicking my user-name and then on "Send a Message".

Regarding combining the data from multiple files, that's easily done. You can use the Merge Data Files into Spreadsheet command in Acrobat to do it. You'll find it under Tools - Forms - More.

[Shannon27462759m995]

I sent you an email from my personal email. Did you get it?-Shannon

[try67]

I think so, and I replied to it, but didn't hear anything back from you...