Auto Formatting Time with script trigger
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?