Are you developing Sitecore 9 Forms and wondering where does the data get saved on Save Data?
- It goes to local DB called Experience Forms (The DB comes with it as part of Sitecore 9 installation OOTB)
- It has two tables – dbo.FormEntry and dbo.FieldData holds all the information.
- The below first query gives the top 1000 form submissions. From the form ID, you can query against dbo.FieldData for any specific field values.
SELECT TOP (1000) [ID]
,[FormItemID]
,[Created]
FROM [sc91local_ExperienceForms].[dbo].[FormEntry]
SELECT TOP (1000) [ID]
,[FormEntryID]
,[FieldItemID]
,[FieldName]
,[Value]
,[ValueType]
FROM [sc91local_ExperienceForms].[dbo].[FieldData]
You can also export the data from ‘Export the data to CSV‘ button from Form Designer.
Hope this information is helpful. Any questions, please leave a comment.
Happy Sitecoring.
