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

Populate City field using a csv without using Livecycle

Forum Index > Forms: Acrobat > Populate City field using a csv without using Livecycle
2010-08-02 09:13:58
adjmcloon
Registered: Jan 8 2010
Posts: 13

I have been having trouble finding some information on populating a city field when a user enters a zip code in the same pdf form.

I have a csv file containing the zip code information, does anyone know of any javascript examples I can look at to complete this task?

Thanks, I apologize if this has been covered and I missed it.

My Product Information:
Acrobat Pro 9.3.1, Windows
Top
2010-08-02 09:32:45
#1
gkaiseril
Expert
Registered: Feb 23 2006
Posts: 4308
Acrobat forms can read a tab delimited file. See the Acrobat JS API Reference for the additional requirements for column headings and security restrictions and how to program the trusted function.

George Kaiser

Top
2010-08-02 09:39:35
#2
adjmcloon
Registered: Jan 8 2010
Posts: 13
Actually I think I would rather just use a sql database, since I need to share this document across over 40 users. I was thinking of setting up a sql database that contains the zip code/city information, and then using javascript to query the database when the user enters the zip code in the field.

I would use ADBC to open the connection, correct? And then just create the array that defines the query that should be sent?
Top