Quick Notes on Working with SQLite
- Nick Hales [Administrator] (Unlicensed)
- Joel Ireland (Unlicensed)
Description
The following are notes on the use of SQLite functions within All On Mobile. It is not designed to be a tutorial on the use of SQLite. For more information on SQLite functions please see the websites in the reference section of this page.
Calculated Field Overwritten by User
If a field value is derived (as in the example), if the field is not set as as being 'locked' then the Mobile Device user can overwrite the derived value. Field C is derived by adding together Field A and Field B (1 + 3 = 4). |
|
| The Mobile Device User has chosen to overwrite the derived value of 4 with the value 22. |
|
Recalculation If the Mobile Device users revisits the page for any reason (saved job, page flow, etc.) the Al lOn Mobile Mobile Device app will recalculate the the derived values and replace all Mobile Device users overwritten fields. |
|
Page Calculation
When deriving information from fields on other pages within All On Mobile it is important to remember the following tips:
Page Flow Following the simple tips above will help when designing page flow. Field Visability If a field's visibility is linked to a derived value on another page it will not become visible until that page is visited. |
|
Downloading Databases
| Description | iSO | Android | |
|---|---|---|---|
| 1 | From the 'Hamburger Menu' ( |
| |
| 2 | The list of Databases that have been successfully downloaded to the Mobile Device are listed. | ||
| 3 | If no Databases have been downloaded a message stating that "You don't have any databases downloaded on your device" is displayed. You can trigger databases to download by pressing the refresh button on this page. |
|
Database Download
Off-line Databases can only be downloaded when the Mobile Device is connected to a WiFi network. Database download is disabled over 3G/4G.
SQLite Version
The SQLite version running on the Mobile Device can be checked via the Settings Menu on both Apple and Android Mobile Devices.
Compatibility Matrix
To check if the version of SQLite that is installed on the Mobile Device is compatible with All On Mobile please check the /wiki/spaces/AOMP/pages/5079054.
Time and Date Format Change
In order to support SQLite time and date functions the text format of the time and date in All On Mobile has been change in All On Mobile v3.1 to a numeric format.