This is not a specific question, rather looking for ideas on possible ways to handle the following scenario. I have created a PDF that automates the task of printing variable data for labels. User selects from a drop down, which will produce results in three additional fields. Select: Option 1 > Results: A,C,D Select: Option 2 > Results: B,E,F Select: Option 3 > Results: A,C,F The above results are performed with a custom calculation script. This functionality works fine. If modifications are necessary to results, this is made to the calculation script. All of the data for Options and Results are in an external spreadsheet. Currently, modifications are made first to the spreadsheet, then communicated, then changes made to the script. So, is there any way to bridge or connect the data from the spreadsheet, into Acrobat, and into the script in some automated manner? This question is open to accomplishing this task outside of Acrobat. Performing the entire task in Excel was considered. TIA for any ideas or thoughts.
... View more