Brent_Durland

Simplify Time Entry

Discussion created by Brent_Durland on Oct 8, 2018
Latest reply on Oct 9, 2018 by ericjlindholm

Simplify data entry in FileMaker time fields with this technique. Instead of needing to enter time in specific formats, this allows quick entries such as:

 

User enters thisFileMaker records this
99:00 AM
11:00 PM
4304:30 PM
7157:15 AM

 

This technique uses the OnObjectValidate script trigger and a custom function. See how it works by downloading the sample file in this article:

 

FileMaker Time Field Entry

 

This example also includes a method for inputting time entry using buttons, which can be very handy with FileMaker Go applications.

 

1021.jpg

Outcomes