So I have an app that I am trying to develop that uses the calendar and a list of entries. Each entry has a date-stamp on the day it’s entered. These entries feed into another spreadsheet that adds more data, and that data is used as base for a calendar (however the calendar is not editable so I cannot add stuff from the calendar, only through the list).
- Entry date
- Reminder date (= entry date + 20 days).
- Due date (= entry date + 60 days).
Is there a way to display these two additional dates on the calendar? it seems I can only choose one of the 3 but not all 3.
Additionally, is there a way to send a reminder email on the reminder date? (I can create the action do do it, but i dont know how to trigger it without “updating” the calendar table which is pre-filled in the google spreadsheets, not through the appsheet app.