Text markup functions
Written by
Updated at March 28, 2024
Markup functions are used for creating marked up text (hypertext) from string values and/or other marked up text.
Usage notes
There are the following features of using markup:
- These functions return
NULL
when any argument isNULL
. To get a non-NULL value, wrap argumens inIFNULL()
. Example:bold(ifnull([value], 'NULL'))
. - Converting markup to a normal string is not currently possible.
- Markup functions can be used within logic functions. Example:
IF(STARTSWITH([value], 'n'), BOLD([value]), MARKUP([value]))
.
BOLD
Syntax:BOLD( text )
Stylizes the passed text in bold font.
BR
Syntax:BR()
Adds a line break.
COLOR
Syntax:COLOR( text, color )
Enables specifying the color for the provided text.
ITALIC
Syntax:ITALIC( text )
Stylizes the passed text in cursive font.
MARKUP
Syntax:MARKUP( arg_1, arg_2, arg_3 [ , ... ] )
Merges marked up text pieces. Can also be used for converting strings to marked up text.
SIZE
Syntax:SIZE( text, size )
Enables specifying the size (in pixels) for the provided text.
URL
Syntax:URL( address, text )
Wraps text
into a hyperlink to URL address
. When you click on the link, the page opens in a new browser tab.