In order to begin storing the form’s data in a database, you need to generate a custom form store and configure it with a database connector such as MsSql Connector and MySql Connector. To create a connector, read Connecting with Third Party Systems.
To ensure that form data is stored in your database, follow these steps.
- On Pages & Forms, click the ‘Manage’ button associated with the form you wish to connect the database to. This will invoke the Data Storage screen, which is where you can create or update the required entities (tables). Each page should have one parent entity to map as well as sub entities for each repeater control used in that page.
- Choose the connection you want to use from the drop down menu. If you did not create a connector already, do so using the information on Connecting with Third Party Systems.
- Click ‘Load Data Store’ so that you can view suggestions for entities that can be created for the page.
- Mark the controls whose data you wish to store and click ‘Confirm Create Entities’.
- Open the page using Open Page Designer to specify the action of the ‘Submit’ button and properly send input data to the database.
- Click on the ‘Submit’ button you have added. On the panel to your right, select Actions/Triggers and then click’+ Action’. Enter a name for the action and save it. Add a Sub Trigger by clicking the ‘+’ button you see when you hover over the action. Define the type of action the button will take (e.g. close or submit data), the domain, connector, and entity.
- Map the controls on your page accordingly and then save.