Transform Data

Relay.app has a powerful transform data step that lets you transform your data in any way you want. This is very useful in case you need to do things such as multiplying a number, converting a number to a string, or adding a couple of days to date.

You can find the 'Transform data' step in the 'Utilities' menu

Here is a short video on how to use and configure the transform data step:

Data Transformation examples

1. Format a Date the way you need it

Use the "Format as text" option in the transform menu to format a date or date-time into a specifically formatted string

Format a date

2. Extract the (company) domain from an email address

Extract the @domain from an email address

3. Add/subtract/multiply/divide numbers

Perform arithmetic operations on numbers

4. Format a number as a currency

Format a number as any currency

5. Convert comma-separated-values into a List

Use this powerful data transformation to split comma-separated values of text (e.g. Jane, John, Mike, Alex ) into a List that can be used with an Iterator.

Split comma-separated values into a List

Full list of Data Transformations

Updated : 2025-11-28

Input	Transformation	Output
Text	Adjust case	Text
Text	Append text	Text
Text	Base64 decode	Text
Text	Base64 encode	Text
Text	From A to B	Text
Text	Get value at pointer	Text
Text	Hash	Text
Text	HMAC	Text
Text	Length	Number
Text	Lowercase	Text
Text	Pad end	Text
Text	Pad start	Text
Text	Parse as date	Date
Text	Parse as date/time	DateTime
Text	Parse as Email	Email
Text	Parse as HTML	Rich Text
Text	Parse as JSON	Text
Text	Parse as Markdown	Rich Text
Text	Parse as number	Number
Text	Parse as phone number	Phone
Text	Parse as URL	URL
Text	Prepend text	Text
Text	Replace all	Text
Text	Replace text	Text
Text	Split and take	Text
Text	Split into list	List
Text	Trim	Text
Text	Uppercase	Text
Text	URL encode	Text
Rich Text	Plain text	Text
Rich Text	Plain text (as Markdown)	Text
Number	Absolute	Number
Number	Add	Number
Number	As currency	Text
Number	As ordinal	Text
Number	As text	Text
Number	As words	Text
Number	Ceiling	Number
Number	Divide by	Number
Number	Floor	Number
Number	Logarithm	Number
Number	Modulo by	Number
Number	Multiply by	Number
Number	Parse as duration in unit	Duration
Number	Parse as Unix milliseconds	DateTime
Number	Parse as Unix seconds	DateTime
Number	Raise to power	Number
Number	Round	Number
Number	Subtract	Number
DateTime	Add	DateTime
DateTime	Add duration	DateTime
DateTime	As date/time text	Text
DateTime	As ISO 8601 string	Text
DateTime	As Unix milliseconds	Number
DateTime	As Unix seconds	Number
DateTime	Difference to now	Duration
DateTime	Extract date	Date
DateTime	Extract day of week	Text
DateTime	Extract time	Time
DateTime	Nearest working day	DateTime
DateTime	Next working day	DateTime
DateTime	Set time	DateTime
DateTime	Shift to time zone	DateTime
DateTime	Start of	DateTime
DateTime	Subtract	DateTime
DateTime	Subtract duration	DateTime
DateTime	Time since	Duration
DateTime	Time until	Duration
Date	Add	Date
Date	Add duration	Date
Date	As date/time text	Text
Date	As ISO 8601 string	Text
Date	As Unix milliseconds	Number
Date	As Unix seconds	Number
Date	Difference to now	Duration
Date	Extract day of week	Text
Date	Nearest working day	Date
Date	Next working day	Date
Date	Set time	DateTime
Date	Start of	DateTime
Date	Subtract	Date
Date	Subtract duration	Date
Date	Time since	Duration
Date	Time until	Duration
Time	As ISO 8601 string	Text
Time	As text	Text
Time	As text with format	Text
Duration	Add	Duration
Duration	Add to date	DateTime
Duration	Add to date	Date
Duration	As ISO 8601 string	Text
Duration	As number	Number
Duration	As text	Text
Duration	Subtract	Duration
Duration	Subtract from date	DateTime
Duration	Subtract from date	Date
List	Join list items	Text
List	Maximum list item	Number
List	Maximum list item	Duration
List	Minimum list item	Number
List	Minimum list item	Duration
List	Size	Number
List	Sum list items	Number
List	Sum list items	Duration
Name	Get family name	Text
Name	Get given name	Text
Email	Extract domain	Text
Email	Lowercase	Email
URL	Add URL parameter	URL
URL	Extract domain	Text
URL	Remove URL parameter	URL