Saturday, March 9, 2019

Custom Fields that Record Time Stamps as a Transaction is being Created

User wants to display the times when the transaction form is opened and when it is saved. This is to show how long it took to create the transaction.

To create the custom field that shows the time when the transaction form is opened:

1.    Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > New.

2.    Set the Type to Time of Day.

3.    Unmark the Store Value checkbox.

4.    In the Validation & Defaulting tab, select Current Date/Time in the Dynamic Default.

5.  In the Applies To tab > mark the record(s) where the field will be displayed.

6.    Click on Save.

 

To create the custom field that shows the time when the transaction is saved:

1.    Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > New.

2.    Set the Type to Free-Form Text.

3.    Unmark the Store Value checkbox.

4.    In the Validation & Defaulting tab, type in the Default Value:

 

EXTRACT(HOUR FROM TO_TIMESTAMP(TO_CHAR({createddate},'DD-MON-YYYY HH:MI:SS'), 'DD-MON-YYYY HH:MI:SS')) || ':' || EXTRACT(MINUTE FROM TO_TIMESTAMP(TO_CHAR({createddate},'DD-MON-YYYY HH:MI:SS'), 'DD-MON-YYYY HH:MI:SS'))

 

5.    Mark the Formula checkbox.

6.  In the Applies To tab > mark the record(s) where the field will be displayed.

7.    Click Save.

The first field displays the time a transaction form is opened and the second field displays the time it is saved.

No comments:

Post a Comment