- 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)
6.1.Field Value Selection
Field Value Selection
Step 1: Go to Forms > Automation> Add Automation> Select Action Type and choose ‘Set current event values’
Step 2: We can use the below value.
[[formID=5;field1=12;field2=’abc’ GET field4.last]]
In this example, the different parts of this line can be explained below.
- formID — this indicates which form we want to retrieve the value from.
- field1 / field2 — this indicates which record in the target form we are looking for.
- GET — this tells JET that we will be getting values from this record.
- field4.last — this will retrieve the particular field value in the record selected.
Note: that field1 / field2 / field4 can be replaced by other field names where necessary.
While using it in ‘Set current event values’ is the most direct way of using this method, it can also be used in other action types.