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
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)
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?