I need help to create an email comprised of data that exists on three different forms, all of which have relationships between them.
Specifics:
- The email address the email is to be sent to is on the DONOR form.
- The email is triggered to send via a checkbox on the DONOR form.
- The email needs to include data located on the WISH LIST form.
- The email needs to include data located on the FAMILY form.
Relationships:
- The DONOR form has a lookup field to associate donors (DONOR form) to families (FAMILY form).
- The FAMILY form contains a WISH LIST subform to associate families to wish lists.
I am completely lost at how to make Zoho Creator traverse the relationships and get the data from these forms into one email. Any and all help is VERY appreciated!!!!
Thanks,
Steve