AnsweredAssumed Answered

Auto Formatting Time with script trigger

Question asked by DavidRoy_1 on May 28, 2013
Latest reply on May 30, 2013 by philmodjunk


Auto Formatting Time with script trigger


     Hi all,

     I have several time fields (Time of Day, Allow Override) on multiple layouts in my solution and am trying to make the solution friendlier to the users.  As such I'd like to write a script that will auto-correct and reformat times entered into the field into the way filemaker wants to see the data, so that the users aren't shown an error. 

     For example:  I'd like someone to be able to type 5, or 5pm, or 5 pm, or 5:30 pm, and in each instance the script will correct the data and display it as 5:30 pm

     I've searched around, and have found several leads, but haven't been able to find a good answer to this.  Is anyone willing to write a short how-to?