The Formula

lets(
	latest_filtered,max(map(map(prop("Month Release Notes"),current).filter(not(empty(current.prop("URL")))),
		timestamp(current.prop("Date")))),
	map(map(prop("Month Release Notes"), current).filter(timestamp(current.prop("Date"))==latest_filtered),
		current.prop("URL"))
)

Summary

• The formula first finds the latest date from the "Month Release Notes" where the "URL" is not empty.
• Then, it filters the notes to include only those with the latest date.
• Finally, it extracts the "URL" properties from these filtered notes.

The Breakdown

1. Define the latest_filtered variable:

   • map(prop("Month Release Notes"), current): Maps over the "Month Release Notes" to create a list of items.
   • filter(not(empty(current.prop("URL")))): Filters the list to include only the items where the "URL" property is not empty.
   • map(..., timestamp(current.prop("Date"))): Maps over the filtered list to extract the "Date" property and convert it to a timestamp.
   • max(...): Finds the maximum timestamp from the resulting list of dates.

   This part of the formula extracts the latest date from the "Month Release Notes" where the "URL" property is not empty.

2. Filter and map the items based on latest_filtered:

   • map(prop("Month Release Notes"), current): Again, maps over the "Month Release Notes" to create a list of items.
   • filter(timestamp(current.prop("Date")) == latest_filtered): Filters the list to include only the items where the "Date" property matches the latest_filtered timestamp.
   • map(..., current.prop("URL")): Maps over the filtered list to extract the "URL" property of each item.

   This part of the formula retrieves the "URL" properties of the items that have the latest date.

Examples & Variations

[FF] Formula Example

[FF] Formula Example (1)

Demo