Hello, I have created an order form as a fillable PDF. I know how to distribute the form and compile form responses into a portfolio. I also know how to extract the responses from the portfolio and merge them into an excel workbook. I also created hidden form elements that create columns in the spreadsheet that I can edit and use to manage the orders (e.g., a delivery date field). What I don't know how to do is to add a new response file into the existing workbook. I want to be able to keep all responses in one workbook where I can edit and change cell values. To illustrate: I want to merge all Week 1 responses into an excel workbook, I want to be able to add any responses from Week 2 or subsequent weeks into that same excel workbook so I can track the delivery status of all orders in one document. Is this possible to do with Adobe Acrobat DC? The only work around I can think is to to generate a new workbook for each new order and manually copy and paste the data into my main excel workbook but that sounds like a pain and introduces opportunities for error. Any help is appreciated!
... View more