Applying radio buttons to already existing documents.

[Megan273543390eza]

Hi everyone. I recently noticed when I exported data from an Adobe Acrobat document into an Excel sheet that some of the radio buttons are not coded correctly in the document and no not align with their actual variable number.

For example, variable AS50 on this document has a value of AS51 in the radio button, so it is being exported into the Excel sheet as AS51 rather than AS50. Also, because there are two AS52 radio buttons, only one is getting exported and the other cannot be found in the export.

Further, there are some discrepancies in the way some data is getting coded, as well as the locations of some variables, which will need to be amended. 

To our knowledge, we can edit the properties and locations of these radio buttons in Adobe; however, we are wondering if there is a way to apply the changes that we make to the Adobe document to all of the already completed/filled out versions of the document. That way, we don't have to manually re-enter all of that data. 

If anyone has any idea of ways to apply these changes to pre-existing documents, please let me know! Any help/ideas are appreciated.

[Meenakshi Negi]

Hi Megan273543390eza,

Thank you for reaching out.

Please confirm if you have created the form in Acrobat. Would you mind sharing the sample PDF form and the converted Excel sheet with us to check it?

Share the steps you did to convert the PDF to an Excel file.

Share the Acrobat and OS versions that are in use.

Let us know if you need any help.

Thanks,

Meenakshi

[Megan273543390eza]

Hi there,

Yes, the document was created with Acrobat. I've attached the PDF and exported Excel sheet to this response.

To export it, I took the following steps: Tools > Prepare Form > More > Merge Data Files into Spreadsheet > Add Files > Blank SCID_adobe sample.pdf > Export

The OS build on the desktop is 17134.2208 and is a 64-bit operating system, and the Acrobat version is 2202.003.20258.  

Let me know if you have any other questions, and I appreciate your help!