Tim,

If they just want a warning as a basic sanity check, you'd really just want to enter field level validation on the LABTRANS.REGULARHRS field. Even if you're entering a start and end time (instead of the regularhrs), it would trigger the message when validating the End Time field as in this screen shot:

1. Go to System Configuration  >>  Platform Configuration >> Database Configuration
2. Under the More Actions menu, click "Messages".
3. Click "New Row", and enter the following values:
   
   • Message Group: MYGROUP
   • Message Key: MYKEY1
   • Display Method: MSGBOX
   • Message ID Prefix: BMXZZ
   • Message ID Suffix: E
   • Message ID: (this value will autopopulate)
   • Display ID: Checked
   • Value:  Labor Entry is greater than 12 hours. Are you sure you want to save this entry?
   • Buttons: Check the boxes for Cancel, Yes
4. Click the OK button to save the new message. (It is not necessary to do a dbconfig.)

1. Go to System Configuration  >>  Platform Configuration >> Automation Scripts
2. Under the More Actions menu, click Create >> Script with Attribute Launch Point.
3. Enter these properties for the Step 1 of 3 screen:
   • Launch Point: LABHRS1
   • Object: LABTRANS
   • Attribute: REGULARHRS
   • Events: Validate
   • Script: New
4. Click Next, then enter these properties for the Step 2 of 3 screen:
   • Script: LABORHRS1
   • Log Level: Error
   • Script Language: python
   • Click "New Row" under Variables and enter the following properties:
   • Variable: REGULARHRS
   • Variable Type: INOUT
   • Binding Type: ATTRIBUTE
   • Launch Point Attribute: REGULARHRS
5. Click Next, for the script, enter the following:

   regularhrs = mbo.getMboValue("REGULARHRS").getDouble()if (regularhrs > 12):   warngroup = "MYGROUP"   warnkey = "MYKEY1"

6. Save and then test by making a new labor entry.

This gives users the standard behavior with a sanity check and will allow them to either "Use My Value" or "Go Back".

If you want  to enforce it so that a user cannot enter an entry > 12 hours, you could change the code in step 5 from "warngroup" and "warnkey" to "errorgroup" and "errorkey". If you do this though, you may also want to consider adding extra code that checks the user's  security groups and allows them to save an entry >12 if they're in a specific security group (e.g. - a  supervisor, etc.)

Tim,

If they just want a warning as a basic sanity check, you'd really just want to enter field level validation on the LABTRANS.REGULARHRS field. Even if you're entering a start and end time (instead of the regularhrs), it would trigger the message when validating the End Time field as in this screen shot:

1. Go to System Configuration  >>  Platform Configuration >> Database Configuration
2. Under the More Actions menu, click "Messages".
3. Click "New Row", and enter the following values:
   
   • Message Group: MYGROUP
   • Message Key: MYKEY1
   • Display Method: MSGBOX
   • Message ID Prefix: BMXZZ
   • Message ID Suffix: E
   • Message ID: (this value will autopopulate)
   • Display ID: Checked
   • Value:  Labor Entry is greater than 12 hours. Are you sure you want to save this entry?
   • Buttons: Check the boxes for Cancel, Yes
4. Click the OK button to save the new message. (It is not necessary to do a dbconfig.)

1. Go to System Configuration  >>  Platform Configuration >> Automation Scripts
2. Under the More Actions menu, click Create >> Script with Attribute Launch Point.
3. Enter these properties for the Step 1 of 3 screen:
   • Launch Point: LABHRS1
   • Object: LABTRANS
   • Attribute: REGULARHRS
   • Events: Validate
   • Script: New
4. Click Next, then enter these properties for the Step 2 of 3 screen:
   • Script: LABORHRS1
   • Log Level: Error
   • Script Language: python
   • Click "New Row" under Variables and enter the following properties:
   • Variable: REGULARHRS
   • Variable Type: INOUT
   • Binding Type: ATTRIBUTE
   • Launch Point Attribute: REGULARHRS
5. Click Next, for the script, enter the following:

   regularhrs = mbo.getMboValue("REGULARHRS").getDouble()if (regularhrs > 12):   warngroup = "MYGROUP"   warnkey = "MYKEY1"

6. Save and then test by making a new labor entry.

This gives users the standard behavior with a sanity check and will allow them to either "Use My Value" or "Go Back".

If you want  to enforce it so that a user cannot enter an entry > 12 hours, you could change the code in step 5 from "warngroup" and "warnkey" to "errorgroup" and "errorkey". If you do this though, you may also want to consider adding extra code that checks the user's  security groups and allows them to save an entry >12 if they're in a specific security group (e.g. - a  supervisor, etc.)