Template Field Support for SQLite in Mobile Apps

Field	SQL Function	Visibility & Validation	Comment
Text box	One literal (text) or an SQLite Select statements. Select statement returning: one row of data with one column	Cannot mix literals (text) and SQLite statements. 1 = True (make the field visible) 0 = False (hide the field) In the event of an error = use the default (returns a single value) Field be considered valid? 1 = Valid 0 = Invalid Error = 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
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
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
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
Print	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.