- 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)
6.18.Parent Form Updates
Parent Form Updates
This serves to allow automations in the subform to update the parent record in the parent form.
A specific use case would be the last updated time.
The action “Auto Update Existing Record” should be used with the below.
formID=123;ID_ROW=getParentId() SET field1='{field2}'
- ID_ROW – to define the ID of the target record.
- getParentId() – retrieves the id of the parent record.
- field1 – field name of the target form
- field2 – field name of the current form
This will allow us to update the parent record with any values from the records within the subform that falls under the parent record.