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:

The Mobile Device user may not have had an opportunity to enter information into field on other pages (Fields A and B in the example).
Derived information is not calculated until the Mobile Device end user has visited that page.
Derived information is only calculated whilst the Mobile Device end user is visiting that page. In the example, once the Mobile Device user has moved from Page 1 to Page 2, Page 1 will no longer update Field C.

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' () select '*Databases*'.
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.

All On Mobile Public