Normal Topic CALENDAR FOR SCHEDULING TECHNICIANS (Read 861 times)
KATHYWEEKS
Member
*
Offline


No personal text

Posts: 2
Joined: Jul 14th, 2004
CALENDAR FOR SCHEDULING TECHNICIANS
Jul 14th, 2004 at 7:12pm
Print Post Print Post  
I currently run QA4, but know I need to upgrade.  I have been exploring both Sesame and Alpha5. 
Does Sesame have calendar abilities?
I would like to be able to have a daily calendar on my screen, showing the technicians in a row across the top and the times down the side.  I would like to be able to take the customer's service request and then schedule it "live" on the schedule screen, and then ideally our dispatcher would be able to click on that customer when the time comes and automatically page our tech with the info.
Can this be done in Sesame?

  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: CALENDAR FOR SCHEDULING TECHNICIANS
Reply #1 - Jul 15th, 2004 at 1:29pm
Print Post Print Post  
Sesame does not have a "calendar table" widget  - but it does have a generic table subform. If you make the first field (column) the time of day and increment it automatically - and then each of the other columns are the technicians, you could easily build a daily scheduling calendar as you describe.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: CALENDAR FOR SCHEDULING TECHNICIANS
Reply #2 - Jul 15th, 2004 at 3:08pm
Print Post Print Post  
Make a database with a separate record for each Date and Time bucket, and each record has a field for each tech's activity. 

Fields: Date, TimeBucket,Tech1, Tech2, Tech3,....Techn
Display in a subform showing table mode

Rough example, ignoring AM/PM: Quote:
DATE........TIME..................TECH1..............TECH2..............TECH3
7/15/05.....08:00-08:30.....Tech1Activity.....Empty................Empty
7/15/05.....08:30-09:00.....Tech1Activity.....Tech2Activity.....Tech3Activity
7/15/05.....09:00-09:30.....Tech1Activity.....Tech2Activity.....Tech3Activity
7/15/05.....09:30-10:00.....Empty..............Empty...............Tech3Activity

...
...
...
9/11/05.....02:30-03:00.....Tech1Activity.....Tech2Activity.....Tech3Activity
9/11/05.....03:00-03:30.....Tech1Activity.....Tech2Activity.....Tech3Activity
9/11/05.....03:30-04:00.....Empty..............Empty...............Tech3Activity

Date and TimeBuckets are Read Only.  You can edit each Tech's activity real time.  The Tech Activity above an be anything, Customer Name ID, for example.  That info could then be used to call up the Customer's record with history, etc.

You could also create a process to add new records automatically for future date/timebuckets as needed.
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
KATHYWEEKS
Member
*
Offline


No personal text

Posts: 2
Joined: Jul 14th, 2004
Re: CALENDAR FOR SCHEDULING TECHNICIANS
Reply #3 - Jul 15th, 2004 at 4:22pm
Print Post Print Post  
I'll give this a try this afternoon.  Are you thinking of some sort of lookup...how would I get from the customers service call request form to the schedule form.  Visually look at the tabbed schedule form and then type in the time?  i'm Just thinking out loud.  What about the email to the tech?  is that possible? Thanks for you help,
Kathy
  
Back to top
 
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: CALENDAR FOR SCHEDULING TECHNICIANS
Reply #4 - Jul 15th, 2004 at 4:39pm
Print Post Print Post  
You can add buttons to forms for email, printing, batch processing, etc.

Almost any action you want can be triggered when you go into or exit from or change the value of a field.  Sesame is very flexible, only limited by your imagination. 

You can open up/close other forms, you can create merge documents, emails, etc.  You can make fields dynamically become visible/invisible/change color, etc. based on changing conditions.

  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged