Function of the Day

DayOfYear Returns the number of days from the beginning of the year of a date.   Direct Link

DayOfWeek Returns a number representing the day of the week on which a date occurs.   Direct Link

DayName Returns text that is the full name of the weekday for a date.   Direct Link

Day Returns a number from 1 to 31, for the day of the month on which a date occurs.   Direct Link

Date Returns the calendar date for a month, day, and year.   Direct Link

VerifyContainer Returns 0 (false) if container data was changed or deleted outside the FileMaker Platform; otherwise, returns 1 (true).   Direct Link

TextEncode Returns a text file as container data from text using the specified character encoding and line endings.   Direct Link

TextDecode Returns text decoded from container data using the specified character encoding.   Direct Link

HexEncode Returns data as text in hexadecimal format.   Direct Link

HexDecode Returns either container or text content from text encoded in hexadecimal format.   Direct Link

GetWidth Returns the width, in pixels, of the content in a container field that holds images.   Direct Link

GetThumbnail Returns a thumbnail image of the content in a container field, according to a specified height and width.   Direct Link

GetHeight Returns the height, in pixels, of the content in a container field that holds images.   Direct Link

GetContainerAttribute Returns the file metadata of the specified container field.   Direct Link

CryptVerifySignature Verifies whether a digital signature is valid for the data.   Direct Link

CryptGenerateSignature Generates the digital signature of the data.   Direct Link

CryptEncryptBase64 Encrypts data with the specified key and returns text in Base64 format.   Direct Link

CryptEncrypt Encrypts data with the specified key and returns container data.   Direct Link

CryptDigest Returns a binary hash value generated by the specified cryptographic hash algorithm.   Direct Link

CryptDecryptBase64 Decrypts Base64-encoded text with the specified key and returns text or container data.   Direct Link

CryptDecrypt Decrypts container data with the specified key and returns text or container data.   Direct Link

CryptAuthCode Returns a binary HMAC (keyed-hash message authentication code) using the specified cryptographic hash algorithm.   Direct Link

Base64EncodeRFC Returns data as text in the specified Base64 format.   Direct Link

Base64Encode Returns data as text in Base64 format.   Direct Link

Base64Decode Returns either container or text content from text encoded in Base64 format.   Direct Link

VarianceP Returns the variance of a population represented by a series of non-blank values in a field.   Direct Link

Variance Returns the variance of a sample represented by a series of non-blank values in a field.   Direct Link

Sum Returns the total of all valid, non-blank values in a field.   Direct Link

StDevP Returns the standard deviation of a population represented by a series of non-blank values in a field.   Direct Link

StDev Returns the standard deviation of the sample represented by a series of non-blank values in a field.   Direct Link

Random Returns a number between 0 and 1, including 0 but not including 1.   Direct Link

GetRecordIDsFromFoundSet Returns record IDs from the current found set as a list or a JSON array.   Direct Link

Get(LastErrorDetail) Returns text about errors that are returned by Get(LastError).   Direct Link

JSONParsedState Returns 0 if JSON is not parsed, -1 if parsed but invalid, or a positive number representing the JSON type if parsed and valid.   Direct Link

JSONParse json - any text expression or field that contains a JSON object or array.   Direct Link

GetTextFromPDF Returns the text found in a PDF file in the specified container field.   Direct Link

SubtractEmbeddings Subtracts embedding vector v2 from v1 and returns the result as a normalized vector.   Direct Link

PredictFromModel Returns the predicted value from a trained regression model for the specified text embedding vector.   Direct Link

NormalizeEmbedding Normalizes an embedding vector. If specified, the dimension parameter reduces the number of vector dimensions to use before normalizing.   Direct Link

GetRAGSpaceInfo Returns information about the specified RAG space or all RAG spaces, if no space ID is specified.   Direct Link

GetFieldsOnLayout Returns a list of the fields on a layout as JSON data.   Direct Link

AddEmbeddings Adds two embedding vectors and returns the result as a normalized vector.   Direct Link

ExecuteSQLe Executes an SQL query statement for the specified table occurrence in a FileMaker Pro file and, if an error occurs, returns ? followed by an error message.   Direct Link

Get(SystemStorageAvailable) Returns the available storage, in bytes, on the system drive where the FileMaker software is installed.   Direct Link

Get(RevertTransactionOnErrorState) Returns 1 (true) if the Set Revert Transaction on Error script step is on; otherwise, returns 0 (false).   Direct Link

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

JSONMakeArray Converts a list of separated values into a JSON array of the specified type.   Direct Link

GetLiveTextAsJSON Returns the text and position as JSON data for each line of text found in an image in a container field by using the text-recognition algorithm.   Direct Link

GetTokenCount Returns the token count for the specified text. Use for guidance only; actual counts used by models may vary.   Direct Link

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