Autoupdate fieldcontent

I need to have a field with a time stamp (no problem) and when counting time from the startingpoint till after 5 minutes (300 seconds) I need a list to open with differnet choises as a reason for why it took that time before anything happend.

I used an IF (Field > 300 ; Message ; Message) and it works fine, but it does not AutoUpdate. If I do nothing, nothing happens. And the script is useless.

Ex. When I send info to the startingtree I also send a timestamp and the next start I send a new timestamp. If there is a differense between the two timestamps of five minutes I would like to log that from a automatic choise (chechboxes) Say. 1 Clearing of oil on tracks 2 breakdown 3 Car Towed Etc.

Peter Norling Sweden

Users would have to press a button or you would need to use EventScript to trigger the script when another field is modified.

Thank's for your answer. I think that FM is a wonderful program to work with, but sometimes you need to find another way around to find a solution.

Perhaps this is the solution that need to be solved in a different way.

I will continue and if I find a solution I will publish it here at this forum

Best Regards

Peter Norling Sweden

I offer observations not solutions.

When you say that you send a timestamp how exactly do you do that? Is that a scripted button which grabs the current time and drops it in the field? Perhaps you could do what it is that you want by adding onto that script.

Another thought - in between the two time stamps are you entering data into the database? If not then you could have a background script running to count off the time and check whether or not your timestamp field has changed

Background scripts seems as an interesting solution.

I use a Field = Creation Timestamp that is created when New Start (New Record) i being klicked upon and then I select the stratnumber (popup list) and after both fields (Track 1 & Track 2)are complete I press the Startbutton and send info to external device.

And then i click New start again and a new Timestamp is created.

Difference between these two is what I would like to calculate (and that's no problem) But the thing is, if you get a popmeny when you are focused on the start then it will distract you - that's not good.

So, if this can be done with automatic counting of time, then:

If (Timestamp are equval or over Timestamp + 300 (seconds) ; Show Custom Dialog Box (script) ; otherwise do nothing )