Rollup for Text (First, Last)
complete
R
Rhonda Rosenof
I would like to be able to use something like a rollup function to select text that is in either the first or last record. An example would be one table with a list of projects and a second table with a list of weekly updates. I could then wrap up in a view to just see the most current of the updates.
Peter Novosel
complete
Hey Rhonda Rosenof! I'm happy to update you here - you can get the value you're looking for with one of our new formula functions called RELATED_RECORD_SORT. Here's an example:
RELATED_RECORD_SORT(
[Tasks].[Updates],
[Tasks].[Last Updated],"DESC"
)
That formula will get the value of the "Updates" field in the related Tasks table that has the most recent Last Updated value.
Jon Darbyshire
Thank you for posting, Rhonda Rosenof! I have a few more questions for you:
- Can you provide more details on how you envision the rollup function working with text records?
- What specific information from the weekly updates would you like to see in the rollup view?
- How frequently would you need to use this rollup function for text records?
R
Rhonda Rosenof
Jon Darbyshire - Just want a simple text field for "update comments". Would probably use this once a week, but NOT having this available is preventing me from using this application for tracking tasks, opportunities, or anything else where I want to keep track of regular updates and see the most current one on a report.