• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1901
  • Last Modified:

How can I display a Clock ( current time field ) on a FILEMAKER Pro screen layout

How can I display a Clock ( current time field ) on a FILEMAKER Pro screen layout.
I want to use this display within a Factory Time and Attendance booking system, This is not a timestamp field but a field that shows the current PC's system time. Is there some type of custom field I can use?
0
jverne
Asked:
jverne
  • 6
  • 5
1 Solution
 
North2AlaskaCommented:
You could create a calculation field that does  Get ( CurrentTimeStamp ).  Make the sure that you set the storage options to either "Do not store calculation results" or "Use global storage" if you want the field to always calculate.

Note:  if you don't set it as global it will have to calculate for every record when you first launch the application.  This can be a performance issue if you have a large number of records.
0
 
jverneAuthor Commented:
Thats fine when you open the file, get the current time at that instance, but I need a field to continuous display the current time - just like a clock
0
 
North2AlaskaCommented:
Anytime you make a change to a record it will recalculate.  What I have not been able to do in a simple way (there may be scripting/event triggers/etc... that could be used) is to open a layout and see the seconds tick by.
0
2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

 
North2AlaskaCommented:
What level of change would you want this to be? Minutes or Seconds?
0
 
jverneAuthor Commented:
Thats exactly what I want - to open a layout and see the seconds tick by, just like at clock.
Is there anyway to link at field to a website which provides GMT - like "NetTime"?
0
 
jverneAuthor Commented:
Seconds
0
 
North2AlaskaCommented:
You got me thinking about how to use the web.

Edit your layout and select Insert->Web Viewer...  Select Custom Web Address and put in the web address of your choice.  (I used http://www.time.gov/timezone.cgi?Mountain/d/-7/java)  Bingo.  You now have a clock displayed...
0
 
North2AlaskaCommented:
I forgot to mention.  You can even interact with the web viewer.  So, for example the  site I used has a button that can select a different time zone.  I can click the button and change the zone all from FileMaker.  Very cool...
0
 
jverneAuthor Commented:
Wow Its nearly there - I'm getting webpage cannot be displayed - Do you put "" marks around the http address in Custom Web Address setup box
0
 
North2AlaskaCommented:
Here is what is in my Web Address:

"http://www.time.gov/timezone.cgi?Mountain/d/-7/java"

Including the quotes.  But when I entered it, I just copied and pasted, so I think FileMaker took care of the quotes for me.
0
 
jverneAuthor Commented:
A Great Solution!! I used a GMT website and it worked - I will be using this solution in other projects - WOW THANK YOU
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now