Functions
Functions are executed during file generation and insert the result of their execution into the document at the specified location. You can use the function editor to create functions, which can be accessed via "Insert" - "Functions". Functions can be inserted both in the editor and in email templates. Below is a list of all available functions with descriptions.
-
=NOW()
Returns the current date in the format DD.MM.YY.
-
=NOW(template)
Returns the current date in the specified format. The template for the output string must be passed in parentheses.
See formatting options.
For example, =NOW(j F Y) will return "10 March 2025".
Additionally, there are several predefined constants that can be used instead of parameters. -
=EVENT_DATE()
Returns the event date in the format DD.MM.YY for which the document is created.
-
=EVENT_DATE(template)
Returns the event date in the specified format for which the document is created. The template for the output string must be passed in parentheses.
See formatting options.
For example, =EVENT_DATE(j F Y) will return "10 March 2025".
Additionally, there are several predefined constants that can be used instead of parameters. -
=EVENT_NAME()
Returns the name of the event for which the document is created.
-
=EVENT_DESCRIPTION()
Returns the description of the event for which the document is created.
-
=UNIC_ID()
Returns the unique numerical generation ID. Each generation has a unique sequential ID. If needed, you can reset it to 1 by clicking here.
-
=DOC_ID()
Returns the numerical document ID (up to 7 digits) used for generation. Each document has a unique sequential service-wide ID.
-
=DOC_UUID()
Returns the UUID of the document used for generation. The UUID is a unique 36-character identifier for the document.
-
=CREATER_ID()
Returns the numerical generation ID (up to 7 digits). Each generation has a unique sequential service-wide ID.
-
=CREATER_UUID()
Returns the UUID of the current generation. The UUID is a unique 36-character identifier used to access the file in the Drive.
-
=RND_NUM(length)
Returns a random number with the specified length. Note that this function generates a pseudo-random number, which may eventually repeat.
Example: =RND_NUM(5) -
=RND_STR(length)
Returns a random uppercase Latin string with the specified length. Note that this function generates a pseudo-random string, which may eventually repeat.
Example: =RND_STR(10)
If a function is not working, check for correct syntax. A function must start with an equals sign. You can also try rewriting the function, as formatting issues may introduce invisible characters. To prevent this, wrap the function in curly braces, for example: {=NOW()}.
Modifying Data
If the file has already been created, you can modify not only variables but also the function result by specifying your own value. However, if you want the function to return a new value, you need to delete the old value in the file editing window. When regenerated, the function will return the updated value.