Expand my Community achievements bar.

Radically easy to access on brand approved content for distribution and omnichannel performant delivery. AEM Assets Content Hub and Dynamic Media with OpenAPI capabilities is now GA.

Adobe form extracts data to Excel

Avatar

Level 3

Good day all,

I have a form with  four columns : a day of the week,number of hours worked, overtime hours worked and the total hours worked.

This form will be emailed to employees to complete and they will email it back.

I want this form to build an excel spreadsheet that will extract all the different employees information from all the forms they have emailed and give me one summarized data.

Thanks

Ace

1 Reply

Avatar

Former Community Member

You can certainly build the form and have it create an xml structure that represents the data. I am no Excel expert but I undrestand that you can import xml into a spreadsheet so as long as the xml you generate from the form conforms to the structure of your spreadsheet I do not see why this will not work.

Paul