---
sourceDocument: Australia Customer Success Management
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/de-DE/acct-lifecycle-events

 Release :

    - australia

ft:locale :

    - de-DE

ft:publication_title :

    - Australia Customer Success Management

ft:clusterId :

    - actle

bundleId :

    - actle

workflow :

    - Customer and Industry


---

# Field and record level validations

# Configure data validation using the Data Validation Assist table {#ariaid-title1}

* Freigeben Version: Australia
* 
* Aktualisiert 12. März 2026
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 Minuten Lesedauer

Create field and record level validations in the Data validation assist table.

## Vorbereitungen

Role required: admin

## Warum und wann dieser Vorgang ausgeführt wird

Several pre-defined validations are available with the base system. When data is imported during the account onboarding process, these validations are used to validate the data. But you can define additional validations based
on your requirement.

## Prozedur

1. Navigate to AllCustomer Success ManagementData Validation Assist SupportData Validation Assist table.
2. Select New to open the Data Validation Assist record.
3. Select the Validation type that can be Field level or Record level.
4. For Field level validation type, you can select one of the following Validation sub types:  
   * Reference: Select the Reference table, Reference table field, Staging table, and Staging table field. Specify the reference fields in the staging table. A reference field stores a reference to a field on another table. When you define a reference field, a relationship is created between the two tables.
   * Choice: Select the Target table, Target table field, Staging table, and Staging table field. Used to validate if the value specified in the Excel is present.
   * Date: Select the date format, Staging table, and Staging table field.
   * Datetime: Select the date and time format, Staging table, and Staging table field.
   * Boolean: Select the Staging table and Staging table field. Checks for a true or false result.
   * String character limits: Specify the Max length, Staging table, and Staging table field. Used to validate if the string length doesn't exceed the limit specified.
   * Integer or decimal: Specify the Staging table and Staging table field. Used to validate if the field is an integer or a decimal number.
   {#account-lifecycle-data-valid-assist__ul_w4l_hzk_xbc}
5. Select the Mandatory check box to specify if a validation condition is required.
6. For Record level validation type, you can define custom scripts to validate the staging table records.  
   The following is an example of a sample validation script.

       (function executeCondition( /* glide record */ stagingTableGr) {
           var obj = {
               validationPassed: true,
               message: ''
           }; /*      validationPassed : return true if validation passed else return false      message : populate error message if validationPassed is false else return empty string     */
           if (global.JSUtil.notNil(stagingTableGr.task) && global.JSUtil.notNil(stagingTableGr.u_company)) {
               if (stagingTableGr.task.company.name != stagingTableGr.u_company) {
                   obj.validationPassed = false;
                   obj.message = 'The Account is not matching with the Case Account.';
               }
           }
           return obj;
       })(stagingTableGr);

7. Select Submit to create a validation assist table.