- About JET
- Administration
- Creating an App
- Basic Functions
- Advanced Functions
- Automation Parameters
- Field Value Selection
- Field Value Formatting
- Field Value Manipulation
- Total Count of a Form
- Total Sum of Field
- Minimum Value of Field
- Maximum Value of Field
- Average Value of Field
- Site Level Parameters - Site Name
- Site Level Parameters - Login User
- Site Level Parameters - Login User Email
- Owner Email
- Check Permission Group
- Date Time Addition
- Email Image
- CheckBox Condition
- Usage of Time Fields
- Parent Form Updates
- 3rd Party API
- Other Features
- Known Issues & Solutions
- Linux
- Windows
- FAQ (JET)
3.6.Field Types
Each field type has its own function. Here is the extensive list:
Text | Any characters can be keyed into this text field. |
Relation (list) | Choose another form's field that it is related to. |
Drop-down List | A dropdown box with your own set options. |
Dynamic Dropdown | A dropdown box with your own set of options where you are able to save new entry options. |
Number | Only numbers can be keyed into the field. |
Currency | Store Currency value. |
Date | Ability to select a date or key in manually. |
Data Time | Ability to select date and time manually. |
To input email addresses (must include @/com/.sg , etc.). |
|
GPS | Shows the current location. |
GPS Insert | Inputs current GPS location on new record save. |
GPS Update | Auto stores current GPS location on record save. |
Long text | Allows characters to be keyed onto the next line. |
Text Header | Allow display of text without input. |
Body Text | Allow display of large text volume without input. |
Single File Upload | Allows you to attach file (excel, word, text, etc.). |
Image from Upload | Allows you to upload images from your device. . |
Timestamp Insert | Inputs the timestamp of record save. |
Timestamp Update | Auto stores timestamp of record save. |
Image Low | Low resolution image on mobile camera. |
Image Medum | Medium resolution image on mobile camera. |
Image High | High resolution image on mobile camera. |
Barcode QR scan | Allows you to scan barcodes. |
Checkbox | Allows you to indicate a True or False value. |
URL/UNC | Redirects to a new page upon clicking on the link. |
Chat Room | Chat room. More Details |
Resource | Allows you to upload multiples files, add file description, upload date & time, delete files, etc. |
Username Insert | Updates the Username when a record is created. |
Username Update | Updates the Username when a record is updated. |
IP Insert | Updates the IP address when a record is created. |
IP Update | Updates the IP address when a record is updated. |
Time | Allows you to indicate a time. |
Signature | Allows you to submit a signature. |
Free Drawing | Allows you to create drawings for illustration. |
Video Upload | Saves and allows play of video from JET server. |
Video URL | Upload video from external URL. |
Auto Numbering | This is a record ID number that would automatically increase in value when a new record is added. |
Users List | Allows you to choose from the users list. |
Permission Groups List | Allows you to choose from the permission groups list. |
User - Record Ownership | Assign access to a record to another user. More Details |
Permission Group - Record Ownership | Assign access to a record to another permission group. |
Memo | This allows the user to insert long paragraphs of text |
Display QR | This allows to display a field value as QR code. |
Field Description:
Chat Room
This field can only be used once it is added as a record into a form.
Note: The chat room will not work if it is opened while on the popup to create a record.
After creating a record, you can access it by looking at the records of the form and clicking the “Chat Room” button under the appropriate field.
User - Record Ownership
In order to make use of this, this field type should be selected during field creation.
It would not work properly if it was changed from another field type.