In the Process Record Values event of the Edit page (Add page not necessary because the field will already be blank). Then in the Before Record Added/Updated events on the add and edit pages.

This is how you can display a different value in a list than what is stored in the database. In this example I stored “0” in the timecard table for Clock In and “1” for Clock Out.

In the “Before record added” event for both the Add page and Edit Page, use the following code to convert the value in the database to what is expected on the page. Then in the “Before record added” event of the Add page and the “Before record updated” event of the Edit page, use the
Read More »

In the “After table initialized” event for the table, add the following code. Note, this code is for a DateTime column and sets it to a BETWEEN search type for the current day.