Text markup functions

Markup functions are used for creating marked up text (hypertext) from string values and/or other marked up text.

Usage notesUsage notes

There are the following features of using markup:

1. These functions return NULL when any argument is NULL. To get a non-NULL value, wrap argumens in IFNULL(). Example: bold(ifnull([value], 'NULL')).
2. Converting markup to a normal string is not currently possible.
3. Markup functions can be used within logic functions. Example: IF(STARTSWITH([value], 'n'), BOLD([value]), MARKUP([value])).

BOLDBOLD

Syntax:BOLD( text )

Stylizes the passed text in bold font.

BRBR

Syntax:BR()

Adds a line break.

COLORCOLOR

Syntax:COLOR( text, color )

Enables specifying the color for the provided text.

We recommend using the color variables from the Gravity UI palette to specify colors. Such colors are easily discernible with both the light and dark theme.

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.

IMAGEIMAGE

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).

ITALICITALIC

Syntax:ITALIC( text )

Stylizes the passed text in cursive font.

MARKUPMARKUP

Syntax:MARKUP( arg_1, arg_2, arg_3 [ , ... ] )

Merges marked up text pieces. Can also be used for converting strings to marked up text.

SIZESIZE

Syntax:SIZE( text, size )

Enables specifying the size (in pixels) for the provided text.

TOOLTIPTOOLTIP

Syntax:TOOLTIP( text, tooltip [ , placement ] )

Adds a small tooltip to a text or other markup function results. The placement argument manages the text positioning: top, right, bottom, left or auto. The default value is auto.

URLURL

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_INFOUSER_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.