world time field

[Jondb]

Hi -

I have a calculation field to show local time where my clients are, based on a time difference field in each of my client records. The calculation is: Time(Mod(Hour(Get(CurrentTime)) + Time difference;24); Minute(Get(CurrentTime)); Seconds(Get(CurrentTime)))

This field only updates when I make a change, such as clicking in the field, or resizing the window, even though I have the 'unstored' option selected in the calculation. How can I make it update itself continually to show current (local) time?

[bcooney]

Unstored calcs do not continuously update. Are you really using FM7? I believe you'll need FM8.5 at least to use the WebViewer to show this clock: http://www.clocklink.com/world_clock.php

[Jondb]

You're right - forgot to update my profile. I'm using FP9.

Interesting world clock, but it doesn't suit my purpose. Attached is a screenshot of the portal where I want local times to show. The pink column shows the time difference (this is entered when the client record is made). I want the clock in the header to show current time, and the clocks in the right hand column to show local times. Alright, it's an easy calculation to make myself, but that's what filemaker is for, isn't it?

Any ideas how I might achieve this? As I say, it works currently, but only updates itself when I resize the window.

[bcooney]

The basic obstacle you face is that FM won't update unstored calcs in real time. They update on refresh (such as resizing the window, switching layouts). It'll incure a lot of overhead to force a periodic refresh, imho. I'm out of ideas.

I found a CF that might help: http://www.briandunning.com/cf/1079

and this thread:

http://filemakertoday.com/com/showthread.php?11494-How-to-display-Real-time-Clock

the post about a robot machine and a one record pref record might be the way to go.

Edited February 9, 2010 by Guest
added another link

[Jondb]

Thanks for your help- I'll check those out.