Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2009-05-14
11
Medium Priority
?
1,775 Views
Last Modified: 2012-05-07
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
Comment
Question by:jverne
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 
LVL 12

Expert Comment

by:North2Alaska
ID: 24383873
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
 

Author Comment

by:jverne
ID: 24384549
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
 
LVL 12

Expert Comment

by:North2Alaska
ID: 24384836
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 12

Expert Comment

by:North2Alaska
ID: 24384953
What level of change would you want this to be? Minutes or Seconds?
0
 

Author Comment

by:jverne
ID: 24384955
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
 

Author Comment

by:jverne
ID: 24384975
Seconds
0
 
LVL 12

Expert Comment

by:North2Alaska
ID: 24385182
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
 
LVL 12

Expert Comment

by:North2Alaska
ID: 24385208
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
 

Author Comment

by:jverne
ID: 24385321
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
 
LVL 12

Accepted Solution

by:
North2Alaska earned 2000 total points
ID: 24385467
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
 

Author Closing Comment

by:jverne
ID: 31581385
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question