Functions run at the moment of file generation and substitute the result of function execution into the document where they are written. Functions can be inserted both in the editor and in the table. Below is a list of all functions with descriptions.
Returns the date in the format DD.MM.YYYY.
Returns the date in the specified format. The template of the resulting string must be passed in brackets.
See formatting parameters.
For example: =NOW(j F Y) returns 10 March 2021.
There are also several predefined constants that can be used instead of parameters.
Returns a unique digital ID for the generation. Each generation has a unique sequential ID. If necessary, it can be reset to 1 by clicking here.
Returns the result of the ChatGPT prompt. The prompt should be specified in parentheses without quotation marks. The prompt text may include variables that will be replaced with their values prior to prompting ChatGPT.
Examples of using the function:
=CHATGPT(If the word starts with the letter "I", then write it in capital letters, otherwise return it as is: %name )
=CHATGPT(=%coefficient * %points. Respond with just a number)
=CHATGPT(If the number is greater than 3, then return "FOR PARTICIPATION", otherwise write the number and the word "PLACE": %points )
The prompt to ChatGPT can be anything according to the required action. As ChatGPT represents a chat, it is better to specify the format of the result in the prompt immediately.
Limitations on use:
- The maximum length of the prompt is 500 characters
- The maximum response is 1000 characters
- File creation time may be increased due to ChatGPT response waiting time.
Returns the digital document ID (up to 7 digits) used for generation. Each document has a unique sequential ID (for the entire service).
Returns the UUID of the document used for generation. The UUID is a unique 36-character identifier for the document.
Returns the digital generation ID (up to 7 digits). Each generation has a unique sequential ID (for the entire service).
Returns the UUID of the current generation. The UUID is a unique 36-character identifier for the generation. It is used to access the file in Drive.
Returns a random number of the length specified in brackets. Please note that the function returns a pseudorandom number that may eventually repeat.
Returns a random string of uppercase Latin characters of the length specified in brackets. Please note that the function returns a pseudorandom string that may eventually repeat.
If the function doesn't work, check the correctness of the spelling. The function must start with an equal sign. Also, try to rewrite the function, as there may have been substitutions of non-printable characters during text formatting.
If the file has already been created, you can change not only the variables but also the result of the function execution by specifying your own value. But if you need the function to return a new value, you should delete the old value in the file editing window. When creating a function, it returns a new value.