I have a pdf form with the field names that are the same as my excel spread sheet, how do I make the pdf find the excel file?

Question

Is there a way to link them together so the pdf will auto fill from the excel file? Also is there a way to fill one field in the pdf with a combination of two fields from the excel file. Example pdf has "name" excel file has "first name" and "last name", I would like to fill name field on the pdf file with a combination of first name and last name from the excel file.

Thanks for any help.

try67 · Accepted Answer

Thanks, thats what I was doing wrong. Is there an easy way to fill a spot on the form with a combination of 2 fields from the spread sheet?

Thanks again

Using the example above, the custom calculation code for the "name" field will be:

event.value = this.getField("first name").value + " " + this.getField("last name").value;

try67 · Answer

You can import the data from the Excel file to the PDF, but it's a one time thing and the names of the fields in the PDF and the columns in the Excel file must match EXACTLY. However, you can create hidden fields called "first name" and "last name" and then use a script to populate the "name" field with their combined data, for example.

Regístrese

Social Login

Bienvenido

Social Login

Escaneando el archivo en busca de virus

Este archivo no se puede descargar