Template Field Support for SQLite in All On Mobile v4
Field | SQL Function | Visibility & Validation | Comment |
Text box |
|
Field be considered valid?
| |
Divider | The Divider field does not support SQLite functions. | As for Text box | |
Checkbox | Single SQL select, returning distinct multiple rows of data of a single column (each row treated as an option) Comma separated literals (1,2,3,4…) Selected Default, not tied but support the same function as above. | As for text box | No enforced limit but user is responsible for limiting data Checkbox field data cannot be used in SQL statements at this time Cannot self reference within Checkbox |
Dropdown | Single SQL select, returning distinct multiple rows of data of a single column (each row treated as an option) Comma separated literals (1,2,3,4…) Selected Default, Single SQL select, returning single row of data of a single column (each row treated as an option) | As for text box | |
Radio | Single SQL select, returning distinct multiple rows of data of a single column (each row treated as an option) Comma separated literals (1,2,3,4…) Selected Default, Single SQL select, returning single row of data of a single column (each row treated as an option) | As for text box | |
Date | No SQL | Visibility only as for text box | Add to "Details". If you use this value in a SQL statement t will be returned in the yyyy-MM-DD in a string See new Date/Time field in v4.2.1. |
Time | No SQL | Visibility only as for text box | Add to "Details". If you use this value in a SQL statement t will be returned in the HH:mm:ss in a string See new Date/Time field in v4.2.1. |
Signature | No SQL | Visibility only as for text box | Signature fields cannot be used in another SQL statement, including self referencing |
Submit Button | No SQL | No SQL | |
Page Break | No SQL | N/A | |
Page Button | No SQL | As for text box | No value so not useable in SQL |
Photo/Video | No SQL | Visibility only as for text box | Cannot be referenced in other SQL statements |
Decorated Image | No SQL | Visibility only as for text box | Cannot be referenced in other SQL statements |
Freehand drawing | No SQL | Visibility only as for text box | Cannot be referenced in other SQL statements |
Work location | No SQL | Visibility only as for text box | Can be referenced in other SQL Statements |
Current Position | No SQL | Visibility only as for text box | Can be referenced in other SQL Statements |
Google Maps | No SQL | Visibility only as for text box | Cannot be referenced in other SQL statements |
TomTom | No SQL | Visibility only as for text box | Cannot be referenced in other SQL statements |
Waze | No SQL | Visibility only as for text box | Cannot be referenced in other SQL statements |
Attachment | No SQL | Visibility only as for text box | Cannot be referenced in other SQL statements |
No SQL | Visibility only as for text box | Cannot be referenced in other SQL statements | |
Barcode | No SQL | Visibility only as for text box Should do validation, 4.5 | Can be referenced in other SQL statements |
Hyperlink Button | No SQL | Visibility only as for text box | Cannot be referenced in other SQL statements |
Action Buttons | No SQL | Values cannot be referenced. |