MOSTRECENTVALUE or LAST Function
complete
A
Andrea Dollen
Please provide a function to retrieve a value from the most recent linked record (or last linked record).
The format would be something like
MOSTRECENTVALUE([Date field to evaluate], [Field to Display])
This would allow you to:
- Retrieve the status of the most recent linked record and display in the parent record.
- Do trending by comparing a current value to a value in the most recent record.
- Retrieve the most recent result from a series of linked metrics.
- Etc!
Brian Dollen
complete
This has been added in today's release!
Syntax:
RELATED_RECORD_SORT( [Linked Record].[Field to Display], [Linked Record].[Field to Sort By], "sort_order")
Sort order supports Asc and Desc, defaulting to Desc if not specified.
Example:
RELATED_RECORD_SORT([Linked Record].[Title], [Linked Record].[Number], “Asc“) → sorts Linked Records by the Number field and returns the value of the Title from the record with the lowest Number value.
P
Paul Harren
Brian Dollen: I don't believe this function fully satisfies the need. How can it represent the most-recently-linked linked record? Recency of connection doesn't correlate to a field to sort by.
Brian Dollen
Paul Harren: Since the team architected this to work off of any date field to sort by, all you'll need to do is create a formula field inside your target table to check when the last time the Linked Record field was updated.
Ex: Table 1 has a RELATED_RECORD_SORT formula and a link to Table 2
Table 2 has the backlink to Table 1, and a formula of LAST_MODIFIED_TIME([Link to Table 1])
Back in Table 1, you can use this formula as your method to sort by, and it will give you the first or last linked record by datetime linked instead of a different static date value.
P
Paul Harren
Brian Dollen Hello. This wouldn't work in my case, as Table 1 and Table 2 linkages are both many to many. So a "last modified" could apply incorrectly, I'm thinking two users making a link from record 1 to record 2/3 respectively at the same time.
My goal is for SmartSuite to detect a specific linkage that is made (let's say linking "Apple" to "Basket"), and creating a new third record type that links to—both— Apple AND Basket.
P
Paul Harren
Please! This will allow an entire system to work for my client.