RANDOMIZE

Description

Returns a randomized value of the same data type as the provided input. Supports text, number, date, and boolean values.

Syntax

RANDOMIZE(text/number/date/boolean) -> same type as input

Parameters

ParameterData TypeRequiredDescription
text/number/date/booleanString/Number/Date/BooleanYesValue or expression.

Examples

RANDOMIZE("Hello") 
-- Possible output: "kJsdP".
RANDOMIZE(42) 
-- Possible output: 87.
RANDOMIZE(TO_DATE("2025-03-01"))
-- Possible output: 2024-05-14.
RANDOMIZE(true)
-- Possible output: false.

Tips

  • This function is only allowed for actions targeting sandboxes, to prevent accidental masking of production data.

Related Formula