Having difficulty transposing data from an excel column into separate fillable form fields

Explorer ,
May 26, 2020 May 26, 2020

Copy link to clipboard

Copied

Hi, 

 

I must preface that I cannot change the design or function of this form.

There is an excel column of salutation containing mr, mrs, miss, ms & dr; that I’d like to transpose into the fillable PDF into four checkable boxes "mr, mrs, miss, ms" and "other" fillable input field (dr):

 

Acrobat_2020-05-27_03-31-19.png

I’ve grouped them under "Salutation", but they cannot be individually named as form fields to delineate them and the fillable field "other" cannot be grouped/linked into the salutation.

 

Acrobat_2020-05-27_03-08-41.png

The script would interpret the excel "Salutation" column and check the box thusly:

Acrobat_2020-05-27_03-14-15.png

Is any of this possible?

 

 

The next two fields are a work/home number:

Acrobat_2020-05-27_02-57-40.png

The excel column contains the 10 interger number with the 2 integer prefix followed by the rest of the number containing 8 integers.

Acrobat_2020-05-27_03-39-50.png
How can I link these two separate fields so that the first field transposes only the first two numbers (prefix) followed by the second field with the next 8?

 

 

Lastly is a single integer percent value with two decimal places. There is two fields, the first with the integer and the second with the two numbers following the decimal place.

 

Acrobat_2020-05-27_02-58-13.png

The decimal place is part of the PDF design, but the decimal is also contained within the excel column, which I understand only adds to the difficulty.

 

Acrobat_2020-05-27_03-16-31.png
Again, much like the phone number, how can I link these two separate fields so that the first field inputs the first integer and the second inputs the two integers following/ignoring the decimal place contained within the excel column?

I fully understand how complex my request is and may require serious javascript beyond my skillset. Any help would be greatly appreciated.

TOPICS
Acrobat SDK and JavaScript, Edit and convert PDFs, How to, PDF forms

Views

316

Likes

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
Most Valuable Participant ,
May 26, 2020 May 26, 2020

Copy link to clipboard

Copied

Yes, this would require developing a custom-made script to read the data (which you will have to convert first to a plain-text file, such as a CSV or tab-delimited text), parse it, map the Excel columns to the PDF fields and then write the data to them.

If you're interested in hiring a professional to create all of this for you feel free to contact me privately via [try6767 at gmail.com] to discuss it further.

Likes

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
Explorer ,
May 26, 2020 May 26, 2020

Copy link to clipboard

Copied

>read the data (which you will have to convert first to a plain-text file, such as a CSV or tab-delimited text), parse it, map the Excel columns to the PDF fields and then write the data to them

 

I've got the excel file coverted to a tab-delinated text file and it's being parsed into the PDF. The salutation is certainly going to require some scripting, however I assumed the phone number fields and percentage fields were much easier to implement in terms of some minor script formatting regarding the two fields being joined.

Likes

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
Adobe Community Professional ,
May 26, 2020 May 26, 2020

Copy link to clipboard

Copied

LATEST

First, in order to import the data at all you'll need to have hidden fields that match the names of the Excel columns. Then you can use a calculation script to detect the import and properly process the data into the visible fields.

 

The struture of the calculation script is

 

if(event.target == null)

{

// put code here for processing new data in the hidden fields.

}

 

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

Likes

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