Where is Adaptive Form Data is Stored in CRX

[MoiezMa]

Hi, Does anyone know if we can download or view the form submitted data? I remember seeing it somewhere in CRX but I can't recall where it was also "Download Document of Record" will this .xdp file have all the data users submitted? I can't open this file in local to check if it includes user submitted data.

Currently in our forms we are using "Send Email" option on submission. We don't have any external database connected to save data.  

[workflowuser]

If you are submitting to an workflow it is stored in the crx under the workflow node

[syama]

The submitted form data is not stored in JCR unless the submit action is invoke AEM workflow. In invoke AEM workflow, we can store the form data under the workflow payload or in a workflow variable(again persisted in JCR or externalized if workflow is configured to do that).

In the case of send email, form data is not stored in JCR.

[MoiezMa]

@workflowuser and @syama can we send email and save data in JCR at same time? What are the steps? do we have any document for this?

[syama · Accepted solution]

In order to send data in email, you can use the send email submit action.

If data needs to be stored in crx, one option is to use forms portal and that needs to be enabled when configuring form submission. It stores form data under "/content/forms/draftsandsubmissions/". Please find the documentation: https://experienceleague.adobe.com/en/docs/experience-manager-65/content/forms/use-forms-portal/crea...

You can find the relevant cloud documentation also on the same page.

Another option is to use "Invoke an AEM workflow". One of the steps in the workflow could be to send email. This submit action already stores the submitted data in crx under the workflow payload folder. If required at any other path, a custom step can be written to copy the form data from workflow payload to the new location. Please note that workflow runs on author instance and data is stored on author.

https://experienceleague.adobe.com/en/docs/experience-manager-65/content/forms/workflows/aem-forms-w....

https://experienceleague.adobe.com/en/docs/experience-manager-learn/forms/adaptive-forms/custom-proc...

The third way is to do both actions in a new submit action.

https://experienceleague.adobe.com/en/docs/experience-manager-65/content/forms/customize-aem-forms/c...

Please let me know in case you have questions.

[bhavigoyal]

submitted data is available under /content/forms/fp. In this, there will be several nodes, and you will find which you have submitted locally through the OOTB submit button.