I understand that I cannot have a birthday reminder or a medicine reminder on email. Something that auto repeats itself - seems not possible even when we use zapier or integromat - because they ask for trigger.
Unfortunately, the formula field - being a computed field does not have an updated modified time. So created time and modified time remains the same. There is no new record in a view and hence there is no trigger.
It is strange that we cannot have a ANNUAL birthday reminder OR A DAILY MEDICINE REMINDER on email using third party app because there is no trigger. The system will work once. But will not work on the second iteration because there is no change in modified time, created time & no new record is formed.
Has anybody created any such systems from which mails can automatically be send on daily/weekly/monthly basis without any manual editing?