I am trying to write a Javascript/appscript for an Appsheet app. I cant figure this out, if someone could please help.
I have Three Sheets:
Project
Subtasks
Notes
I would like to be able to send the Project owner an email, that includes the project name all of the tasks assigned to that project (relationship via PK/FK ID,Project Name) and all of the notes assigned to that project (same relationship as Notes PK/FK ID,Project Name)
- I have provided a sample of all the tables, their columns, and an ideal sample output
