Function of the Day

GetTableDDL Returns table information in Data Definition Language (DDL) format for a list of table occurrences specified as a JSON array.   Direct Link

GetEmbeddingAsText Converts an embedding vector from binary container data to text format.   Direct Link

GetEmbedding Sends input data to an embedding model and returns a vector representation as container data.   Direct Link

Get(LastStepTokensUsed) Returns the tokens used in the last AI script step.   Direct Link

CosineSimilarity Returns the similarity between two embedding vectors as a number between -1 (opposite) and 1 (similar).   Direct Link

GetBaseTableName Returns the base table name of a field reference.   Direct Link

Get(CacheFilePath) Returns the path of the cache file for the currently active file.   Direct Link

Get(CacheFileName) Returns the name of the cache file for the currently active file.   Direct Link

BaseTableNames Returns a list of all base table names in fileName.   Direct Link

BaseTableIDs Returns a list of all base table IDs in fileName.   Direct Link

JSONGetElementType Validates and returns the JSON data type for an element specified by an object name, an array index, or a path.   Direct Link

Get(TransactionOpenState) Returns 1 (true) if the transaction is opened; otherwise, returns 0 (false).   Direct Link

Get(LastErrorLocation) Returns the script name, step name, and line number of errors that are returned by Get(LastError).   Direct Link

Get(CurrentTimeUTCMicroseconds) Returns the current time in Coordinated Universal Time (UTC) to the nearest microsecond.   Direct Link

GetLiveText Returns the text found in the image of the specified container field using the text-recognition algorithm.   Direct Link

ReadQRCode Returns as text the value of a QR code in a container field.   Direct Link

Min Returns the smallest valid, non-blank value in a field.   Direct Link

Max Returns the highest valid value in a field.   Direct Link

List Returns a concatenated list of non-blank values for a field or fields.   Direct Link

Count Returns the number of valid, non-blank values in a field.   Direct Link

Average Returns a value that is the average of all valid, non-blank values in a field.   Direct Link