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

[rakeshk21205956]

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

[bebarth · Accepted solution]

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.
@+

[rakeshk21205956]

.

[rakeshk21205956]

thanks for the reply.

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

[try67]

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

[rakeshk21205956]

..

[bebarth]

You can find several examples I did on a French forum.

Here are the links of 2 posts:

http://abracadabrapdf.net/forum/index.php/topic,3859.msg24258.html#msg24258

and the example file

http://abracadabrapdf.net/forum/index.php?action=dlattach;topic=3859.0;attach=4975

or

http://abracadabrapdf.net/forum/index.php/topic,3999.msg25390.html#msg25390

and the example file

http://abracadabrapdf.net/forum/index.php?action=dlattach;topic=3999.0;attach=5462

don't hesitate to contact me in PM if you don't understand and need more help.

@+

[rakeshk21205956]

Couldn't find what i actually need.