...
The Doc URI Approach* | The Business Rules Approach | Dynamic Options | |
---|---|---|---|
Overview | Automatically create the controls in your form based on your database table, and use the Document Action user interface to set up Doc URIs that can perform CRUD Operations. | Write JavaScript business rules to perform CRUD operations. | Dynamically retrieve options at runtime from the Database Connector (or any RESTful web service) using the Options Src control property, no code needed. |
Recommended Use Cases |
|
|
|
Form Design |
|
| Use Checkbox, Dropdown, Radio or ComboBox control with the from palettepalette design method. |
Performance | Call the DB Connector once for all operations (using the autocreate feature) → fast, reliable performance | Call the DB Connector query for every add/update operation (this can impact performance) | Calls the DB connector for each instance of the selection control. Fast, reliable performance for non-repeating controls. Performance issues may be seen for repeating controls. |
Technical Skills | No code needed Create/Modify xsd schema document | JavaScript code required | No code needed |
Documentation | Generating XML Schema | Data Sources | CRUD Operations Example | 10-Minute Doc URI Video | Forms Designer | Palette Controls | Integrations | Business Rules HTTP Methods | Rule Examples | Control Property Settings - Dynamic Options |
...