I have a table, “Events”, with Google Calendar events.
I have another table, “Tasks”, with tasks I want to complete.
I also have a page “Meeting Notes Template”, which has different headings, etc., to be used for taking notes.
I want to have a button in the “Events” that will duplicate the meeting notes template, fill in the title with the title of the event in question, and populate other fields (e.g. who attended). Then, I want to be able to have a button in the meeting notes that will “Add Action Item” by creating a row in the Tasks table.
Once I’ve done that, I want the meeting notes for a meeting to have a table with all of the action items, I want each action item to have a link back to the meeting that created it and the meeting notes page that has more context, and the event to have a link to the meeting notes. I can create lookups manually, but then, for example, if I have a weekly meeting where each instance has the same title, it’s really hard to look up the right instance; using buttons should be able to fill in everything correctly all at once.
How can I do this?