Databases
StackOverflow2013
Postsdbo
POadding a timer to implement reminders in application
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POadding a timer to implement reminders in application
    text
    copied!<p>I have a reminders table in my apps database</p> <pre><code>FieldName = 'id' FieldName = 'title' FieldName = 'description' FieldName = 'start_date' FieldName = 'start_time' FieldName = 'end_date' FieldName = 'end_time' FieldName = 'repeat' (true/false) FieldName = 'occurs' (Integer = 1-Daily, 2-Weekly, 3-Monthy, 4-Annually) FieldName = 'completed" (true/False) </code></pre> <p>Is there a way to use a TTimer to display the title and description of the reminder whenever the event occurs? If so, please explain in code/seudo code, or text.</p> <p>a reminder is either a onetime - or - re-occurring event</p> <p>if one time (occurs = 1 daily) , the date and time is stored in the Start_Date &amp; Start Time The reminder should display at that time. After displayed, table field "Completed" is set to true.</p> <p>if re-occurring, the date and time is stored in the Start_Date &amp; Start Time and the End Date and End Time is stored. The reminder should display at that day and time, each day (1), week (2), month(3), or year(4) </p> <p>If daily, reminder should display at that time every day, until end date is reached</p> <p>If weekly, reminder should display at that time, on that particular day (of each week), until end date is reached</p> <p>If monthly, reminder should display at that time, on that particular day (of each month), until end date is reached</p> <p>If Annually, reminder should display at that time, on that particular day (of each year), until end date is reached</p> <p>when end date is reached, Completed is updated with True</p> <p>thanks, i hope this is easily do-able with out any additional components or libraries</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload