These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Creating a Fillable Form

aryniewicz
Registered: Jan 6 2010
Posts: 4

I’m trying to create a fillable form for changes to our vendors. I’ve started the form but it is not allowing me to populate the information the way I’d like it (less room for user error).

What I’m trying to accomplish is the following

The user selects new or change for the type of submission

If they choose new, all fields need to be manually completed

If they choose change, the user would enter the Identification Code for the Vendor they are changing
Once the Identification Code is entered, I would like the information we already have on file for that vendor to populate (this information is currently in an Excel spreadsheet)
Any changes to the Vendor information to show up in RED bold font.

All fields (whether it is new or change) need to “spit out” to an Excel spreadsheet listing all vendors.

Does anyone know how I can accomplish this?

My Product Information:
Acrobat Pro 9.2, Windows
thomp
Expert
Registered: Feb 15 2006
Posts: 4411
What you are asking for can be done, PDFs and PDF workflows are very flexible. However, implementing your particular workflow is a custom task that requires some programming. Also, prepopulating from an Excel spreadsheet can only be done on a local machine. Do you have any programming experience? And what are the specifics of your workflow?

Thom Parker
The source for PDF Scripting Info
[url=http://www.pdfScripting.com]pdfscripting.com[/url]

The Acrobat JavaScript Reference, Use it Early and Often
[url=http://www.adobe.com/devnet/acrobat/javascript.php]http://www.adobe.com/devnet/acrobat/javascript.php[/url]

Then most important JavaScript Development tool in Acrobat
[url=http://www.pdfscripting.com/public/34.cfm#JSIntro][b]The Console Window (Video tutorial)[/b][/url]
[url=http://www.acrobatusers.com/tutorials/2006/javascript_console][b]The Console Window(article)[/b][/url]

Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script

aryniewicz
Registered: Jan 6 2010
Posts: 4
I do not have any programming experience, I wish I did.

Basically, two departments use international vendors. Banking information and business information (for the vendors) change frequently. There is currently no process to inform my group (finance) of the changes or new vendors. We just receive a payment request that says pay this person, this amount. We find a number of these payments are returned because the information is not accurate or complete. We are trying to centralize all of these changes and have a standard vendor set-up/change form to ensure accuracy of information. The two groups have provided me with a list of vendors that we currently have so that I can create this form.

I hope I gave you what you needed.