Skip to main content
Participant
July 19, 2018
Question

How do I add new form responses to an existing workbook merged from previous responses?

  • July 19, 2018
  • 0 replies
  • 308 views

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!

This topic has been closed for replies.