When we want to get the details of latest created or updated item using SubmitForm, we use Form1.LastSubmit
Below is an example of Employee Details table.
- Form Name: frmEmployeeDetails
- Column Names in Employee Table: ID, Name, Address, Phone, Designation, PrimarySkill
SubmitForm(frmEmployeeDetails);
UpdateContext({newItem: frmEmployeeDetails.LastSubmit.ID})
This way, you can also fetch other details of the last submitted record, e.g., frmEmployeeDetails.LastSubmit.Name, frmEmployeeDetails.LastSubmit.Address etc.