Highlighted

Populate rest of the row fields if i enter the first field from excel

Contributor ,
Jun 27, 2020

Copy link to clipboard

Copied

 

I have excel sheet which contains list of 100 students details like student ID, Name , Parent name, Address, phone number, etc .  Now i want to make same table in PDF fillable forms and want that if i enter any student name or ID, the rest of the corresponding details relating to that student (row) populates itself.

 

Is it possible?

 

Thanks

Yes, it is possible using for example a csv attached file into your pdf form.

You have to use the getDataObject function to read the data of the attached file.

You can for example initialize a dropdown field including all ID, then when you choose one ID, all other fields are automaically filled.

It is also possible to fill the csv sheet from the pdf fields with the setDataObject function.
Please let me know if you need more information.
@+

TOPICS
Acrobat SDK and JavaScript, PDF forms

Views

208

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

Populate rest of the row fields if i enter the first field from excel

Contributor ,
Jun 27, 2020

Copy link to clipboard

Copied

 

I have excel sheet which contains list of 100 students details like student ID, Name , Parent name, Address, phone number, etc .  Now i want to make same table in PDF fillable forms and want that if i enter any student name or ID, the rest of the corresponding details relating to that student (row) populates itself.

 

Is it possible?

 

Thanks

Yes, it is possible using for example a csv attached file into your pdf form.

You have to use the getDataObject function to read the data of the attached file.

You can for example initialize a dropdown field including all ID, then when you choose one ID, all other fields are automaically filled.

It is also possible to fill the csv sheet from the pdf fields with the setDataObject function.
Please let me know if you need more information.
@+

TOPICS
Acrobat SDK and JavaScript, PDF forms

Views

209

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
Jun 27, 2020 1
Participant ,
Jun 27, 2020

Copy link to clipboard

Copied

Yes, it is possible using for example a csv attached file into your pdf form.

You have to use the getDataObject function to read the data of the attached file.

You can for example initialize a dropdown field including all ID, then when you choose one ID, all other fields are automaically filled.

It is also possible to fill the csv sheet from the pdf fields with the setDataObject function.
Please let me know if you need more information.
@+

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
Reply
Loading...
Jun 27, 2020 1
Contributor ,
Jun 27, 2020

Copy link to clipboard

Copied

.

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
Reply
Loading...
Jun 27, 2020 0
Contributor ,
Jun 27, 2020

Copy link to clipboard

Copied

thanks for the reply.

It would have been helpful if you could just elaborate with an example script for 2 rows of data.

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
Reply
Loading...
Jun 27, 2020 0
Most Valuable Participant ,
Jun 27, 2020

Copy link to clipboard

Copied

There's no such example. Doing it for one or two rows is the same as doing it for 1000 rows. The basic code is exactly the same. Try and write the code yourself using the tips given above. It's not a simple task, though.


If you're interested I've developed a (paid-for) tool that allows you to do exactly that very easily and without having to write any code. You can find it here: http://try67.blogspot.com/2015/07/acrobat-populate-fields-from-dropdown.html

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
Reply
Loading...
Jun 27, 2020 0
Contributor ,
Jun 27, 2020

Copy link to clipboard

Copied

..

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
Reply
Loading...
Jun 27, 2020 0
Participant ,
Jun 28, 2020

Copy link to clipboard

Copied

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
Reply
Loading...
Jun 28, 2020 0
Contributor ,
Jun 28, 2020

Copy link to clipboard

Copied

Couldn't find what i actually need.

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
Reply
Loading...
Jun 28, 2020 0