Skip to main content

REPT

Use the REPT function to generate a text value containing a specified number of repetitions of a given text.

Use

REPT( text, number_times )
Repeats text a given number of times.

ParameterRequiredDescription
textYesthe text to repeat
number_timesYesthe number of times to repeat text

ReturnsText

Examples

Visual Progress or Priority Indicators

You can use REPT in an Input Mapping formula to convert a numeric priority level into a visual indicator that is easier for an approver to recognize in their Inbox.

  • Scenario: A "Help Desk" trigger form captures a "Urgency" level as a number from 1 to 5. You want to display this to the technician as a series of red exclamation marks.
  • Formula: REPT("!", @Trigger.out.UrgencyLevel)
  • Logic:
    • "!": The text to be repeated.
    • @Trigger.out.UrgencyLevel: The numeric value provided by the user.
  • Outcome: If the user selects an urgency of 4, the technician will see "!!!!" on their review form. This provides immediate visual context without the technician having to interpret a raw number.

Standardizing Data for Reports

You can use REPT in a Variable Update formula or a Reporting Connector to create consistent visual separators or padding for exported data.

  • Scenario: You are using a Reporting Connector to export a "Summary Log" variable to Excel. You want each log entry to be clearly separated by a dashed line of a fixed length.
  • Formula: CONCAT($CurrentLog, REPT("-", 20), @Activity.out.NewEntry)
  • Logic:
    • REPT("-", 20): This generates exactly 20 dashes ("--------------------").
    • CONCAT(...): This joins the existing log, the repeated dashes, and the new entry into one continuous text string.
  • Outcome: Every time a new entry is added, a perfectly uniform separator is added, ensuring the final report is professional and easy to read.