Process - help - Find 2 Appointments compare Time and report

itdeptcorp

Hi,

I have to create a process and wanted to ask for some help/advice.

We have an appointment object which we do not allow the user to "change the start or end times" after it is saved. If they need to change the Start or End times they use a process which Creates a new Appointment and hides the original.

We have to figure out a process which Find the 1st one, and then compares it against the New one - Looking for original Total Time Vs New Total Time.

Here is the approach - Please let me know if this is correct.

Process 1 - Find Appointment (first one which state=closed) for this User and Todays Date - Take Best 1
Process 2 - Find Appointment (second which state=open) with same conditions User and Todays - Take Best 1
Process 3 - Appointment.Variance=ThisAppointment.TotalTime-ThatApoointment.TotalTIme

? Is this the correct way to do this?

Thanks guys/gals..

tford

Seems like you are on the right track, but I'm not sure which instance will then carry the Appointment.Variance value. Easy enough to find out by testing your proposed approach.

itdeptcorp

We are going to try to create a BO called AppointmentCalc (Not Persistent)
Perform the calcs in there then save to a 4th BO called Attendance.

Lets see how much hair I pull out!