2. PHPRunner General questions
  3. Alert System
This topic is locked

Alert System

 		5/26/2008 9:18:15 PM
PHPRunner General questions
S
 smcgo4 author

Hi Folks
Hope this isn't too confusing. What I want/ need to do is have a way of checking when a user logs in if there are any records that they have not dealt with/ seen yet. If so, then to list the details of those records.
I have a table that maps to their login name. There is another table of records that are also linked to the login name. This table has a field to flag if a record has been viewed. I have played with events in the login section as well as in the list page section, so far without too much luck. Long way of asking has anyone implemented such a 'flag' or 'alert' system and if so, any pointers will be welcome.
Cheers
Steve
J
 		Jane 5/27/2008

Steve,
where do you want to show list of new records?
S
 		smcgo4 author 5/27/2008

Steve,

where do you want to show list of new records?

On a list page preferably <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=29732&image=1&table=forumreplies' class='bbc_emoticon' alt=';)' />
R
 		ringlis1 5/27/2008

One of the easier ways is to add a field to your database and use a check box in your script. Mark it something like "Completed"
Then in phprunner after the database page, you can set it up so that it will only show the records that are not completed. Then since users can only see the areas that are for them, they will only see the non completed records.
You can then make an admin page that only you can view and then you can edit a record, if an employee wants to view it again.