Function: Populate Text Fields using Fetched Subform Values in Deals
We need help creating a Function that will auto-populate 4 text fields when the values are added in the first two rows of a subform. (photos included)
So these four values:
...would go into these four fields as a result of the function:
The first row in the subform is Lender 1 and the second row of the subform is Lender 2.
The reason for this request is because there are several aspects of ZohoOne that don't properly grab data from Subforms yet. For Example, ZohoSign templates. By also having them in text fields, we'll be able to do more.
Here are the field names and API Names.
Subform Fields:
- Subform Name: Lender Details
- Subform API Name: Lender_Details
- Subform Column 1 Name: "Lender Name"
- Subform Column 1 API Name: "Lender_Name"
- Subform Column 2 Name: "Loan Number"
- Subform Column 2 API Name: "Loan_Number"
Row 1 Fields (if it exists).
- Subform Row 1 Column 1 value goes to the Single Line Text field >> "Lender 1 Name", api = "Lender_1_Name"
- Subform Row 1 Column 2 value goes to the Single Line Text field >> "Lender 1 Loan Num", api = "Lender_1_Loan_Num"
Row 2 Fields (if it exists)
- Subform Row 2 Column 1 value goes to the Single Line Text field >> "Lender 2 Name", api = "Lender_2_Name"
- Subform Row 2 Column 2 value goes to the Single Line Text field >> "Lender 2 Loan Num", api = "Lender_2_Loan_Num"
Could someone help me write this please? I will trigger the workflow to run every time a value is added to the subform.