- 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
- 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. |
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.