Member Junction
    Preparing search index...

    Interface DataValidationRule

    Data validation rule

    interface DataValidationRule {
        allowBlank?: boolean;
        allowedValues?: string[];
        errorMessage?: string;
        errorStyle?: "stop" | "warning" | "information";
        errorTitle?: string;
        formula1?: string | number | Date;
        formula2?: string | number | Date;
        inputMessage?: string;
        inputTitle?: string;
        operator?:
            | "equal"
            | "notEqual"
            | "greaterThan"
            | "lessThan"
            | "greaterThanOrEqual"
            | "lessThanOrEqual"
            | "between"
            | "notBetween";
        range: string;
        showDropdown?: boolean;
        showError?: boolean;
        showInputMessage?: boolean;
        type: | "date"
        | "list"
        | "whole"
        | "decimal"
        | "time"
        | "textLength"
        | "custom";
    }
    Index

    Properties

    allowBlank? allowedValues? errorMessage? errorStyle? errorTitle? formula1? formula2? inputMessage? inputTitle? operator? range showDropdown? showError? showInputMessage? type

    Properties

    allowBlank?: boolean

    Allow blank cells

    allowedValues?: string[]

    List of allowed values (for list type)

    errorMessage?: string

    Error message

    errorStyle?: "stop" | "warning" | "information"

    Error style

    errorTitle?: string

    Error title

    formula1?: string | number | Date

    Formula or value for validation

    formula2?: string | number | Date

    Second formula/value for between operators

    inputMessage?: string

    Input message

    inputTitle?: string

    Input title

    operator?:
        | "equal"
        | "notEqual"
        | "greaterThan"
        | "lessThan"
        | "greaterThanOrEqual"
        | "lessThanOrEqual"
        | "between"
        | "notBetween"

    Operator for numeric/date/text validations

    range: string

    Cell range to apply validation

    showDropdown?: boolean

    Show dropdown for list validation

    showError?: boolean

    Show error alert

    showInputMessage?: boolean

    Show input message

    type: "date" | "list" | "whole" | "decimal" | "time" | "textLength" | "custom"

    Validation type

    Settings

    Member Visibility

    On This Page

    Properties