A DataValidationBuilder for a TextValidation.
// Add a text item to a form and require it to be a number within a range.
var textItem = form.addTextItem().setTitle('Pick a number between 1 and 100?');
var textValidation = FormApp.createTextValidation()
.setHelpText('Input was not a number between 1 and 100.')
.requireNumberBetween(1, 100)
.build();
textItem.setValidation(textValidation);
Methods
| Method | Return type | Brief description |
|---|---|---|
requireNumber() | TextValidationBuilder | Requires text item to be a number. |
requireNumberBetween(start, end) | TextValidationBuilder | Requires text item to be a number between start and end, inclusive. |
requireNumberEqualTo(number) | TextValidationBuilder | Requires text item to be a number equal to value specified. |
requireNumberGreaterThan(number) | TextValidationBuilder | Requires text item to be a number greater than the value specified. |
requireNumberGreaterThanOrEqualTo(number) | TextValidationBuilder | Requires text item to be a number greater than or equal to the value specified. |
requireNumberLessThan(number) | TextValidationBuilder | Requires text item to be a number less than the value specified. |
requireNumberLessThanOrEqualTo(number) | TextValidationBuilder | Requires text item to be a number less than or equal to the value specified. |
requireNumberNotBetween(start, end) | TextValidationBuilder | Requires text item to be a number not between start and end, inclusive. |
requireNumberNotEqualTo(number) | TextValidationBuilder | Requires text item to be a number not equal to the value specified. |
requireTextContainsPattern(pattern) | TextValidationBuilder | Requires response to contain pattern. |
requireTextDoesNotContainPattern(pattern) | TextValidationBuilder | Requires response to not contain pattern. |
requireTextDoesNotMatchPattern(pattern) | TextValidationBuilder | Requires response to not match pattern. |
requireTextIsEmail() | TextValidationBuilder | Requires text item to be an email address. |
requireTextIsUrl() | TextValidationBuilder | Requires text item to be a URL. |
requireTextLengthGreaterThanOrEqualTo(number) | TextValidationBuilder | Requires response length to be greater than or equal to value. |
requireTextLengthLessThanOrEqualTo(number) | TextValidationBuilder | Requires response length to be less than value. |
requireTextMatchesPattern(pattern) | TextValidationBuilder | Requires response to match pattern. |
requireWholeNumber() | TextValidationBuilder | Requires text item to be a whole number. |
Detailed documentation
requireNumber()
requireNumberBetween(start, end)
Requires text item to be a number between start and end, inclusive.
Parameters
| Name | Type | Description |
|---|---|---|
start | Number | the lower bounds of the inclusive range |
end | Number | the upper bounds of the inclusive range |
Return
TextValidationBuilder — this TextValidation, for chaining
requireNumberEqualTo(number)
Requires text item to be a number equal to value specified.
Parameters
| Name | Type | Description |
|---|---|---|
number | Number | the value which the item must be equal to. |
Return
TextValidationBuilder — this TextValidation, for chaining
requireNumberGreaterThan(number)
Requires text item to be a number greater than the value specified.
Parameters
| Name | Type | Description |
|---|---|---|
number | Number | the value which the item must be greater than. |
Return
TextValidationBuilder — this TextValidation, for chaining
requireNumberGreaterThanOrEqualTo(number)
Requires text item to be a number greater than or equal to the value specified.
Parameters
| Name | Type | Description |
|---|---|---|
number | Number | the value which the item must be greater than or equal to. |
Return
TextValidationBuilder — this TextValidation, for chaining
requireNumberLessThan(number)
Requires text item to be a number less than the value specified.
Parameters
| Name | Type | Description |
|---|---|---|
number | Number | the value which the item must be greater than. |
Return
TextValidationBuilder — this TextValidation, for chaining
requireNumberLessThanOrEqualTo(number)
Requires text item to be a number less than or equal to the value specified.
Parameters
| Name | Type | Description |
|---|---|---|
number | Number | the value which the item must be less than or equal to. |
Return
TextValidationBuilder — this TextValidation, for chaining
requireNumberNotBetween(start, end)
Requires text item to be a number not between start and end, inclusive.
Parameters
| Name | Type | Description |
|---|---|---|
start | Number | the lower bounds of the inclusive range |
end | Number | the upper bounds of the inclusive range |
Return
TextValidationBuilder — this TextValidation, for chaining
requireNumberNotEqualTo(number)
Requires text item to be a number not equal to the value specified.
Parameters
| Name | Type | Description |
|---|---|---|
number | Number | the value which the item must not be equal to. |
Return
TextValidationBuilder — this TextValidation, for chaining
requireTextContainsPattern(pattern)
Requires response to contain pattern.
Parameters
| Name | Type | Description |
|---|---|---|
pattern | String | text must contain pattern |
Return
TextValidationBuilder — this for chaining
requireTextDoesNotContainPattern(pattern)
Requires response to not contain pattern.
Parameters
| Name | Type | Description |
|---|---|---|
pattern | String | text must not contain pattern |
Return
TextValidationBuilder — this for chaining
requireTextDoesNotMatchPattern(pattern)
Requires response to not match pattern.
Parameters
| Name | Type | Description |
|---|---|---|
pattern | String | text must not match pattern |
Return
TextValidationBuilder — this for chaining
requireTextIsEmail()
Requires text item to be an email address.
Return
TextValidationBuilder — this TextValidation, for chaining
requireTextIsUrl()
requireTextLengthGreaterThanOrEqualTo(number)
Requires response length to be greater than or equal to value.
Parameters
| Name | Type | Description |
|---|---|---|
number | Integer | paragraph text length must be greater than this value |
Return
TextValidationBuilder — this for chaining
requireTextLengthLessThanOrEqualTo(number)
Requires response length to be less than value.
Parameters
| Name | Type | Description |
|---|---|---|
number | Integer | paragraph text length must be less than or equal to this value |
Return
TextValidationBuilder — this for chaining
requireTextMatchesPattern(pattern)
Requires response to match pattern.
Parameters
| Name | Type | Description |
|---|---|---|
pattern | String | text must match pattern |
Return
TextValidationBuilder — this for chaining
requireWholeNumber()
Requires text item to be a whole number.
Return
TextValidationBuilder — this TextValidation, for chaining