I have a complex base with about 16 tables. I am trying to figure out the best way to be able to set a reminder for a record in ANY of the tables easily. I want to be able to set the time & day of the reminder in a REMIND ME field in any record of any table and get notified by email when it is due.
I was thinking I could create a REMINDER Table and link it to the other tables and then set a view in for Remind me is before (NOW) and then set an automation to send me an email whenever a record enters the view.
What I am having a hard time with is how to link the tables properly. If someone can explain in detail how to do this with just 3 tables EVENTS, TASKS, & the REMINDER table, I can extrapolate the rest.
Any help is appreciated.