I need help programming a function to update certain subform fields with other subform fields in the same subform.
I want to be able to publicly post a Zoho Form on my site for prospective customers to fill out that includes a Zoho CRM-linked subform.
The linked subform will include a picklist that mirrors my product list in Zoho CRM (because I cannot post a public form with CRM info).
After the prospect completes the form, it will update the CRM record with the correct number of subform rows and the picklist options the customer selected. (This is already working as desired)
There is a lookup field also in each CRM subform row that links to the actual product list in CRM.
What I have been trying to figure out is how to get those form picklist selections to correctly update the CRM fields, regardless of how many rows the customer enters.
So if the customer adds five rows worth of products, the function will update each corresponding row correctly in CRM.
See attached images for a clearer explanation.
The form:
CRM record (I need help setting up the blue arrow):