I want to create trigger that will update the record. The situation is like:
I have one column named
CheckInDateTime and one more named
Status. If the administrator is not able to update the Status within 30 minutes of
CheckInDateTime I want to update the
Status column of that particular row.
How can I update that particular row?