I hope this isn't already addressed on the forum, but I was unable to find a post close enough to what I'm trying to do to get me there.
I am working on making a PDF for field work, to be used on a tablet. Users will input a structure number in a field, and other fields will populate accordingly from a dataset (which I currently have in Excel). For portability and reusability, I want to store the data from Excel directly in the PDF file. There are only about 600 structures in the spreadsheet with only 32 values for each (lots of blanks too), so not a huge amount of data. When I say directly, I imagine exporting the Excel file to a .txt, then pasting it directly into a script. I'm trying to avoid the need to have multiple files handy or to have to import data each time a new structure is being inspected.
What OS on the tablet?
Well if necessary we could get any available app for the iPads. Free would be best, but if I need a pro version of something, that's possible.
You can try the PDF Expert.
Great, we have that one downloaded.
Now with that esatblished, can you help me make the PDF do what I need it to?
I don't know what is possible in PDF Expert.
I feel like I should repost and start over...
I have also found in my searching that attaching the data in a CSV is likely the way I should go. I just need to make sure that will be compatible in a PDF viewer for iPad. Plus I then have to figure out how to work with the attached CSV... 😅
I've developed a (paid-for) tool that allows you to set it up very easily, based on a spreadsheet, and it even has an option to do it in a way that works in PDF Expert! You can find it here: http://try67.blogspot.com/2015/07/acrobat-populate-fields-from-dropdown.html