I'm working on a database used for handling technical support calls and I was wondering if there would be anyway to add a real time timer onto the form so that a CSR would know how long he/she has been on the phone, I've looked around but doesn't seem like you can do any real time stuff. Thanks.

It would be easy enough to mimick 'real time' by having the CSR click a button when they get a call (button takes them to the correct layout to take notes) and click a "done" button when the call ends... The start button enters the time in a start field, the done button in a end field.

Had time to play tonight so I came up with a little elapsed timer demo. This demo will allow you to view an elapsed timer, and still enter fields in the same layout. Not sure how much B/W this would take up on a shared file, and also note that if the timer updates while typing you can loose characters. You can adjust the refresh by changing the pause time, set at 15 seconds right now. Also the displayed time is only updated by increments of the pause time (15 seconds), after stopped the exact time is available in the elapsed time field. Also note tested on Mac OSX, not Win.

Rod

Timer.fp7.zip

Thanks a alot!!! Will give this a try. Appreciate all the help.

Hey guys.

Ive come across a complication regarding what i want to do, Im not sure how to do this.

I need to create a timer system that counts up to 96 hours from the start time, which also needs to be exclusive to each record, meaning that for each record i can have separate timers counting separately. And i need to implement a calculation that enables the field 'Delivery' to contain the word 'due' when the timer has counted up to 96 hours from the start time, and for that result time to appear.

This is for a delivery system, in which the delivery must be carried out 4 days (96 hours)after the order has been made. So 96 hours countdown from when the order is made, the feild 'Delivery' automatically shows the word 'due'.

rodinbangkok, your demo is really nice. i was wondering if its possible to develop your timer demo according to what i need to do?

your help is very much appreciated guys.

I don't think you need a timer. You need a calculation field that has the word 'Due' in it:

Case(Get(CurrentDay)-recdate > 3, "Due","")

If the record is 4 days old, a portal could display all records the have 'Due' in the calculation field.

Steve

Thanks alot for your help, but unfortunately im such a noob at this.

What i did is i created two fields, one containing the current date and the other with the auto-enter creation date enabled, showing the creation date.

Case(GetField ( Current Date ) - Creation date > 3; "Due";"")

I tried inserting dates that would not prompt Due, but it still shows.

Edited November 27, 200520 yr by Guest

Define a new field of type "date". Select 'Options', select the Auto-Enter tab, and check Creation Date (and time if you desire, or timestamp which is a combination).

Steve

Make sure that the calculation is 'Unstored'

Steve

Rod,

Perhaps you can help me out. We want to create a web form that will allow people to answer questions within a certain time limit. I see you have a script for a timer. It runs on my Windows XP machine, but I can't see the open the scripts. Are they locked or is it because you designed them on a Mac. If it is the later, and you'd be willing to share them, perhaps you can send me the text file. My e-mail address is [email protected]. Thx! don