How to create an agent to update a view

I have a problem with mi refresh, my idea is create an agent to update my data in a view…For Example, I create an appointment and I assigned a date, if the paciente doesnt come at that date, the state of the appointmet in the view it going to change, now its going to be CANCELLED…please I need help!!!

I accept another suggestion to do the update

Subject: How to create an agent to update a view

An agent to change the status seem like a reasonable approach (if I understand the question). You can create a scheduled agent to process all past appointments or you can create an agent which someone runs manually to cancel past appts. It could be @functions or LotusScript. Is that what you had in mind.