Latest Updated

Description

The LATESTUPDATED function retrieves the value of a specified attribute from the most recently updated record linked.

Usage

The function is used to extract the latest value from a given attribute.

Syntax:
LATESTUPDATED(attribute)

Examples

1. Retrieve Latest Value and Apply Conditional Logic:

   IF(LATESTUPDATED(#[Actions].[Number]) > 1, true, false)
   

   Retrieves the most recent value from the Number field in the Actions table from the most recently updated record. If the value is greater than 1, it returns TRUE; otherwise, it returns FALSE.

2. Filter and Retrieve Latest Value:

   LATESTUPDATED(FILTER(#[Risk Assessment].[Assessment Score], #[Risk Assessment].[State] = "Complete"))
   

   Retrieves the most recent Assessment Score value from the Risk Assessment table of the most recently updated record, where the State is "Complete."

Inputs

Returns

Type: Any

• Returns the most recent value of the specified attribute from the most recently updated record.