- 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.2.Filter Form
Once Filter form is selected, designate one of the field name as the filter field name. When another form uses a relation(list) field to point to this filter form, the field will appear on the left side of the form with a drop down list. This would allow the user to filter the display on the form based on the dropdown list.
Step 1: Create a filter form
- Click on
- Select ‘Filter’ under Form Type
- Key in filter field name.
Note that Filter Field Name has to be the same as the Field Name IN your filter form.
Eg. If ‘Filter Field Name’ set in Form Details is ‘product’,
A Field should also be added with the Field Name ‘product’
Step 2: Add in required fields in filter
- Add in the data that you want to filter in the main form to ensure that each record added is a data found in the main form’s data.
Step 3: Link main form to filter form
- Select the field mapping in the main form that you want link the filter to.
- Change the field type to
- On Listbox Source, select the filter form that you have created
- On show field, select the field that you want to filter