Google Apps Script API
    Preparing search index...

    Interface DataValidationBuilder

    Builder for data validation rules.

    // Set the data validation for cell A1 to require a value from B1:B10.
var cell = SpreadsheetApp.getActive().getRange('A1');
var range = SpreadsheetApp.getActive().getRange('B1:B10');
var rule = SpreadsheetApp.newDataValidation().requireValueInRange(range).build();
cell.setDataValidation(rule);
    interface DataValidationBuilder {
        build(): DataValidation;
        copy(): DataValidationBuilder;
        getAllowInvalid(): boolean;
        getCriteriaType(): DataValidationCriteria;
        getCriteriaValues(): any[];
        getHelpText(): string;
        requireCheckbox(): DataValidationBuilder;
        requireCheckbox(checkedValue: any): DataValidationBuilder;
        requireCheckbox(
            checkedValue: any,
            uncheckedValue: any,
        ): DataValidationBuilder;
        requireDate(): DataValidationBuilder;
        requireDateAfter(date: GoogleAppsScript.Base.Date): DataValidationBuilder;
        requireDateBefore(date: GoogleAppsScript.Base.Date): DataValidationBuilder;
        requireDateBetween(
            start: GoogleAppsScript.Base.Date,
            end: GoogleAppsScript.Base.Date,
        ): DataValidationBuilder;
        requireDateEqualTo(date: GoogleAppsScript.Base.Date): DataValidationBuilder;
        requireDateNotBetween(
            start: GoogleAppsScript.Base.Date,
            end: GoogleAppsScript.Base.Date,
        ): DataValidationBuilder;
        requireDateOnOrAfter(
            date: GoogleAppsScript.Base.Date,
        ): DataValidationBuilder;
        requireDateOnOrBefore(
            date: GoogleAppsScript.Base.Date,
        ): DataValidationBuilder;
        requireFormulaSatisfied(formula: string): DataValidationBuilder;
        requireNumberBetween(start: number, end: number): DataValidationBuilder;
        requireNumberEqualTo(number: number): DataValidationBuilder;
        requireNumberGreaterThan(number: number): DataValidationBuilder;
        requireNumberGreaterThanOrEqualTo(number: number): DataValidationBuilder;
        requireNumberLessThan(number: number): DataValidationBuilder;
        requireNumberLessThanOrEqualTo(number: number): DataValidationBuilder;
        requireNumberNotBetween(start: number, end: number): DataValidationBuilder;
        requireNumberNotEqualTo(number: number): DataValidationBuilder;
        requireTextContains(text: string): DataValidationBuilder;
        requireTextDoesNotContain(text: string): DataValidationBuilder;
        requireTextEqualTo(text: string): DataValidationBuilder;
        requireTextIsEmail(): DataValidationBuilder;
        requireTextIsUrl(): DataValidationBuilder;
        requireValueInList(values: string[]): DataValidationBuilder;
        requireValueInList(
            values: string[],
            showDropdown: boolean,
        ): DataValidationBuilder;
        requireValueInRange(
            range: GoogleAppsScript.Spreadsheet.Range,
        ): DataValidationBuilder;
        requireValueInRange(
            range: GoogleAppsScript.Spreadsheet.Range,
            showDropdown: boolean,
        ): DataValidationBuilder;
        setAllowInvalid(allowInvalidData: boolean): DataValidationBuilder;
        setHelpText(helpText: string): DataValidationBuilder;
        withCriteria(
            criteria: DataValidationCriteria,
            args: any[],
        ): DataValidationBuilder;
    }
    Index

    Methods

    build copy getAllowInvalid getCriteriaType getCriteriaValues getHelpText requireCheckbox requireDate requireDateAfter requireDateBefore requireDateBetween requireDateEqualTo requireDateNotBetween requireDateOnOrAfter requireDateOnOrBefore requireFormulaSatisfied requireNumberBetween requireNumberEqualTo requireNumberGreaterThan requireNumberGreaterThanOrEqualTo requireNumberLessThan requireNumberLessThanOrEqualTo requireNumberNotBetween requireNumberNotEqualTo requireTextContains requireTextDoesNotContain requireTextEqualTo requireTextIsEmail requireTextIsUrl requireValueInList requireValueInRange setAllowInvalid setHelpText withCriteria

    Methods

    Settings
    Member Visibility

    On This Page
    Methods