Forum Discussion

prash4030's avatar
prash4030
New Contributor III
2 years ago
Solved

People Planning new hire entry

Hello Expert, Is it possible to make employee register fields mandatory? we want users to select certain required fields before committing save.  Let me know, thank you
Application Properties
User Interface
  • hbindu's avatar
    hbindu
    2 years ago

    It depends on the requirements where and what you want to do. In my case I added validation checks in both BeforeSaveDataEvent. 

    Below is a small example:

    If (args.FunctionName.XFEqualsIgnoreCase("SaveRegisterRows")) Then
    Dim saveDataTaskInfo = New XFSqlTableEditorSaveDataTaskInfo
        saveDataTaskInfo = args.SqlTableEditorSaveDataTaskInfo
        For Each xfRow As XFEditedDataRow In saveDataTaskInfo.EditedDataRows
            If xfRow.InsertUpdateOrDelete = DbInsUpdateDelType.Insert OrElse xfRow.InsertUpdateOrDelete = DbInsUpdateDelType.Update Then
    Dim status As String = xfRow.ModifiedDataRow.Item("Status") 
    If (String.IsNullOrEmpty(JobTitle) Or JobTitle.XFContainsIgnoreCase("TBD")) Then
    isError = True
                 errorMessage = errorMessage & Environment.NewLine & "Job Title cannot be blank or TBD for RegisterID: ...."."
    End If
    Next
    ....
    At the end of the code throw the exception...Is the above condition is met then a popup message will showup when planner clicks on the save.
     

     

hbindu's avatar
hbindu
Icon for OneStream Employee rankOneStream Employee
2 years ago

Yes, you can. you can change the color of the register fields to differentiate between read-only and allow-updates fields. You can add validation checks in the custom Event People Planning Business rule to check if the required fields have the values before saving the new entry by the planner.

prash4030's avatar
prash4030
New Contributor III
2 years ago

hi,

thank you for your reply.

i tried to figure this out through documentation on events but no luck. i configured the reference assembly for PLP Solution helper (as per documentation). do i need to use SaveRegisterRows to validate? and how to pass field names as parameter and in case of missing value, want to show a msgBox.

would really appreciate any guidance.