DataValidationRule

A data validation rule.

Google WorkspaceProductivitySpreadsheets

Properties

Name	Type	Description
inputMessage	string	A message to show the user when adding data to the cell.
strict	boolean	True if invalid data should be rejected.
showCustomUi	boolean	True if the UI should be customized based on the kind of condition.

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "DataValidationRule",
  "type": "object",
  "description": "A data validation rule.",
  "properties": {
    "inputMessage": {
      "type": "string",
      "description": "A message to show the user when adding data to the cell."
    },
    "strict": {
      "type": "boolean",
      "description": "True if invalid data should be rejected."
    },
    "showCustomUi": {
      "type": "boolean",
      "description": "True if the UI should be customized based on the kind of condition."
    }
  }
}