Template Field Support for SQLite in Mobile Apps

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.