Skip to main content
rakeshk21205956
Inspiring
June 27, 2020
Answered

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

  • June 27, 2020
  • 1 reply
  • 1063 views

 

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

This topic has been closed for replies.
Correct answer bebarth

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

1 reply

bebarth
Community Expert
bebarthCommunity ExpertCorrect answer
Community Expert
June 27, 2020

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
Inspiring
June 27, 2020

.