• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

use excel spreadsheet to fill in form

New Here ,
May 02, 2019 May 02, 2019

Copy link to clipboard

Copied

Is there a way for me to create an Excel spreadsheet and use it to fill in information on a pdf form and have it linked so that the template updates if the spreadsheet is updated?

For instance I want to be able to select a lot and block from a community and have it fill in the FEMA community name, the FIRM panel, index date, revised date, flood zone, and 100 year flood plain. Then later if the index date or revised date of a panel change be able to change them in the spreadsheet and have the template reflect that change but I don't want any of the files that were created before the change to update. Perhaps auto mail merge would work?

TOPICS
Acrobat SDK and JavaScript

Views

455

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
May 02, 2019 May 02, 2019

Copy link to clipboard

Copied

It's possible but not trivial. What programming skills do you have and do you need this to function in Acrobat Pro and Reader or just Pro.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
May 02, 2019 May 02, 2019

Copy link to clipboard

Copied

Will this excel sheet always be on the same computer as the PDF?  Will more than one person/computer be using it?  It would be much easier if you just used a DB on a server, then write a server script to update the DB on a form submit from the PDF. That way the data is centralized.

Thom Parker - Software Developer at PDFScripting
Use the Acrobat JavaScript Reference early and often

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
May 29, 2019 May 29, 2019

Copy link to clipboard

Copied

The excel sheets would be created individually for each neighborhood that the elevation certificates need to be completed for. Each municipality has different requirements so for instance one spreadsheet would contain the information for the city as well as the county where as any municipality that does not fall in a city limit would only require the county info. I would like to be able to create PDF templates for each neighborhood that will pull the info from the spreadsheets the research dept. creates to fill in most spots. I would include data such as city, zip, FEMA community ID, county, FIRM panel, Index date, revised date, flood zone and in some cases a value for the 100 year floodplain.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
May 29, 2019 May 29, 2019

Copy link to clipboard

Copied

I would do this from within an Excel macro, that would then push out information to your PDF file(s)

Look for the IAC API in the Acrobat SDK, that will allow you to “remote control” Acrobat.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
May 29, 2019 May 29, 2019

Copy link to clipboard

Copied

LATEST

I have only marginal skill with excel and even less with JavaScript for acrobat. So far I have been creating templates for the neighborhood and then setting up calculations for various fields because the base form remains the same but certain aspects change for each lot block and address.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines