Creating Rules Based on Acceptable Values

When creating rules based on acceptable values, the following sections: Rules Details, Acceptable Values, Acceptable Expressions, Criteria, and Alert Details must be completed as outlined below in each tab:

• 1. Go to Data Governance, and click + Create New Rule.

  The navigation menu may differ depending on the Neodeluxe products your firm uses. 

  2. Enter the new rule’s Name*, and Description*.

  

  The Is Active* dropdown field is automatically filled with Yes.

  3. Select the Rule Type*: Based on Acceptable Values.

  

  4. Select the Project Type* that contains the field where the rule will be applied. 
• 1. Select the Section* where the field is located.

  Available options in the Section* dropdown are displayed according to the selected Project Type*.

  2. Select the Field* that will be verified by the rule.

  

  • Available options in the Field* dropdown are displayed according to the selected Section*.
  • The Acceptable Expressions section is displayed below only when the field type of the selected Field* is Multiple Lines, Multiple Lines (Large), or Single Line.

  

  Users can configure either the Operator* and Acceptable Values* fields in the Acceptable Values section OR the Acceptable Expressions section, but not both simultaneously, when the field type of the selected Field* is:

  • Multiple Lines, 
  • Multiple Lines (Large), or
  • Single Line.

   

  

  Configuring Acceptable Values

  Users can configure only the Operator* and the corresponding field in the Acceptable Values section, when the field type of the selected Field* is: Number, Percent, Decimal, Currency, or Date.

  In this case users CANNOT configure Acceptable Expressions.

   

  

  For more information about configuring regex in the Acceptable Expressions section, check the Acceptable Expressions tab.

  Available Operators According to the Field Type 

  When establishing the acceptable values expression, the available operators to compose the expression depends on the type of field of the selected Field*.

  Field Type of the selected Field*	Operator*
  Multiple Lines Multiple Lines (Large) Single Line	Equals Not Equal To Contains Not Contains
  Number Percent Decimal Currency Date	Between  Equals Greater Than  Greater Than or Equal to Less Than  Less Than or Equal to Not Equal To

  Configuring Acceptable Values for Multiple Lines, Multiple Lines (Large), or Single Line Fields 

  When the field type selected in the Field* option is Multiple Lines, Multiple Lines (Large), or Single Line admins can create an expression using operators, to define when the rule alert is triggered. Follow these steps:

  1. In the Acceptable Values section, select the Operator* to compose the acceptable value expression that will be evaluated by the rule.
  Available operators for these field types are: Equals, Not Equal To, Contains, Not Contains.

  

  For example: If you select the Claimant Relationship to Client field in the Field* dropdown (which was configured as a Multiple Lines field in the corresponding Filevine Project Type), available operators are: Equals, Not Equal To, Contains, and Not Contains.

  

  2. In the Acceptable Values* field, manually write each value and press the Enter key.

  

  3. Or, click Upload CSV File to upload a CSV file that contains the acceptable values.

  

  • You can upload a CSV file and/or write your own acceptable values. Uploading a CSV after having some manually written values will overwrite any manually entered values.

  For the CSV:

  • The file min size must be 1 Byte.
  • The file must have at least one cell with content.
  • The file must not contain subtitles or blank spaces, and you can only upload one file at a time.
  • When adding an additional file, the information from the new file will be overwritten.

  Configuring Acceptable Values for Number, Percent, Decimal, Currency, or Date Fields 

  When the field type selected in the Field* option is Number, Percent, Decimal, Currency, or Date admins can create an expression using operators, to define when the rule alert is triggered. 

  Follow these steps:

  1. In the Acceptable Values section, select the Operator* to compose the acceptable value expression that will be evaluated by the rule.

  Available operators for these field types are: Between, Equals, Not Equal To, Greater Than, Greater Than or Equal to, Less Than or Equal To.

  For example: If you select the Referral Attorney Fee Percentage field in the dropdown Field* (which was configured as a Percent field), available operators are: Between, Equals, Greater Than, Greater Than or Equal to, Less Than, Less Than or Equal to, and Not Equal To.

  

  2. In the displayed field, indicate the value(s) to complete the expression according to the selected operator.
  • Between: Fields to complete: From* and To*.

  

  • Equals and Not Equal To: Fields to complete: Acceptable Values*.

  

  

  When the field type of the selected Field* is Date, when selecting Equals or Not Equal To operator, use the Date Picker field for selecting the acceptable date or enter the date in mm/dd/yyyy format.

  

  • Greater Than, Less Than, Greater Than or Equal to and Less Than or Equal to: Fields to complete: Amount*.

  

  

  

  

• A regular expression can be configured using the appropriate syntax, and can be used instead of acceptable values to define a sequence of characters that specifies a matching pattern. When the entered data in the Filevine field matches the pattern, the rule alert is triggered.

  The Acceptable Expressions section can be configured, when:

  • The field type selected in the Field* option is Multiple Lines, Multiple Lines (Large), or Single Line AND
  • An option in the Operator* dropdown has not been selected.
  • When the field type of the selected field in the Field* option is none of the specified above, the Acceptable Expressions section is disabled.
  • When the Operator* is selected, the Add Regular Expressions button is disabled. In order to allow this setup, ensure no option is selected in the Operator* field.

  For more information about Regular expressions, please visit: Understanding Regular Expressions.

  Follow these steps:

  

  1. In the Acceptable Expressions section, enter the Regular expression that will be evaluated by the rule.

   

  • Regex’s special characters are highlighted with the following colors:
    • Blue: + * ?
    • Green: ( ) Expressions within ( ) are highlighted in green.
    • Violet: \\ \.
    • Orange: . \d \w \$ [ ] and similar expressions. Expressions within [ ] are highlighted in blue.
  • When the regex is invalid, the field is highlighted in red, and a message is displayed.

  

  2. Test the expression before adding it, by entering sample texts in the Test Expression field.

  The sample text is highlighted in green when the entered value matches the regular expression and in red when it does not.

  3. Click Add Regular Expression to add it to the Acceptable Expressions. 
  • Add additional acceptable expressions by repeating the process outlined above.
  • Up to 100 regular expressions can be added at most.

• Configuring the Criteria section is optional in Rules Based on Acceptable Values. However, if a criterion is needed to evaluate whether a rule applies to a project, before checking if the entered value matches the acceptable values or the regex for the field, users can set up one or more criteria, each with one or more conditions.

  

  1. Configure the Criterion 1 by selecting the Variable*, Operator* and indicating the Value*.
  2. Click +Add Condition when required to add another condition in the Criterion 1 and complete the Variable*, Operator* and Value*.
  3. If required, click the Add Criterion button to create additional criteria.
  • A rule is applied when one or more configured criteria are met (For example: Criterion 1 OR Criterion 2 OR Criterion N). If none of the criteria are met, the rule does not apply to the project.
  • A criterion is satisfied only when ALL the conditions within it are met (For example: Condition 1 AND Condition 2… AND Condition N).
  • The N in Criterion N will dynamically change based on the number of criteria added.

  For a better understanding of criteria restrictions and ensure proper setup, we recommend visiting: Understanding Criteria in Rules

• 1. Enter the Alert Message that will be displayed if the rule is broken. After completing the setup, click Save.

  

  • The message should inform users that the entered value is not accepted and how to complete the field correctly.
  • Customize the alert message by clicking on the variable you want to add. Paste it into the Alert Message* field, the variable is enclosed in curly braces allowing to create a dynamic message.

  For example: When you click on Project Name, the variable is copied to your clipboard. Paste it into the Alert Message* field, in this case {{project_name}}. The alert displayed in the Neodeluxe Sidebar will show the project name where the alert was triggered.

  • After saving the rule, it is listed as a Draft, and it's fully editable.
  • Associated alerts will not appear in the Neodeluxe extension while the rule is in Draft.

Have Questions or Issues?

If you have any questions or you are experiencing issues with accessing or using Neodeluxe Data Governance AI, please contact our Product Support Team:

• Email: help@neostella.com
• Submit a Request: Click here to submit a ticket

Our Product Support Team is available Monday through Friday, from 8:00 AM - 5:00 PM CST.