Text markup functions
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.
We recommend using the color variables
You can also specify the color in any web format, such as HEX, keyword (e.g., green
), RGB, etc. In this case, however, we cannot guarantee that the colors will be discernible.
IMAGE
Syntax:IMAGE( src [ , width [ , height [ , alt ] ] ] )
Enables inserting an image located at the src
address to the table. The width
and height
values are provided in pixels. If one of the dimensions is NULL
, it will be calculated automatically in proportion to the other. If both dimensions are NULL
, the image will be inserted with the original width and height. In case there are issues when uploading the image, the function will display the alt
text.
Images can be added from the *.yandex.ru
, *.yandex.net
, yastat.net
, yastatic.net
, or storage.yandexcloud.net
domains. The easiest way is to upload and publish the image in Yandex Object Storage (see the pricing here).
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.
USER_INFO
Syntax:USER_INFO( user_id, user_info_type )
Returns the marked up text by user_id
to display username or email depending on the user_info_type
value:
email
: Returns email.name
: Returns name.
If the user has not been found, the function will return the original string from the source.