Access Database from Smart Forms

App Designer provides you with built-in connectors to access the database. Users can configure the data source and schema in the Datasource Configuration screen.

The user can then choose to set this data source at the entity configuration

Once the entity is linked to a data source, the user can then proceed to map the different modules to the tables in that schema and then map the fields to the columns. All the CRUD operations to the database will be managed by ONEWEB.

To map module to a table Click on the edit icon to open the module configuration screen

Select the table to be mapped in Module Configuration

To map field to a column of that table Click on the edit icon to open Field Configuration for the text field "Name"

Select the column name that you want to map to save the data and also search data for "Name"

Enable the property SearchCriteria for fields that you want to use as Search Criteria and enable ShowSearch for fields that you want to see as a result of searching.

To enable table search, add Buttons to trigger Search Action Drag and drop the Entity button and select ENTITY_SEARCH for page action & searchResult() for button action.

Box (1) shows the SearchCriteria and box (2) shows the ShowSearch

To enable Insert and Update of the table add Buttons to trigger Save Action Drag and drop the Entity button and select saveEntity() as button action. The other options available are saveDraftEntity() to save and return to the same screen i.e. within the open entity and saveEntityCommit() to save the transaction with commit

• select ENTITY_INSERT as page action for insert page (create new)

• select ENTITY_UPDATE as page action for update page (update existing)