AnsweredAssumed Answered

Data entry into a time field - the colon problem!

Question asked by dsimonson on Nov 29, 2016
Latest reply on Nov 30, 2016 by dsimonson

I am working on a method to avoid users having to enter colons into their time fields.  They hate it!  They want to enter only numbers.  My solution requires a lot of time entries (medication times, blood pressure times, etc.), and is to run in FM Go. 

 

There was an excellent discussion of this issue back in 2013

Re: Data entry filter for time field? Also delete seconds value?

 

I am planning on using a script like this as a variation of the calculations provided:

==

IF (Parameters::Time = "")

(Show a dialog and return to the field)

End IF

 

Insert Calculated Result [Select: Let(

@T = RIght( "0000" & Filter( Parameters::Time ; "0123456789") ; 4) ;

Left( @T ; 2 ) & ":" & Right( @T ; 2 ) ) ]

==

 

My problem is, I would like to use this in a script trigger set off by "on object validate" for any of the many time fields (not just Parameters::Time) on my layouts.  But I don't want to have to change the calculation for every field, so I thought about using the "self" reference.  Doesn't work. 

 

How can I create a script that can be called by any field without having to specify the field each time?

 

 

Outcomes