
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 10, 2023 02:18 PM
I've got records of song names. I have a field with the dates we've played the song. I want another field to extract the most recent date the song was played, but don't know how to get there. How do I extract the highest number from an array? Seems like it should be a simple MAX() command, but that doesn't work.
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 10, 2023 07:21 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 13, 2023 10:20 PM
Ah you wouldn't need a rollup for that, you could just use a count field like so:
And I've updated the base I linked above to have it as well
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 10, 2023 07:21 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 11, 2023 01:50 PM
Thank you! Apparently I don't have a solid handle on how roll ups work yet. This solved my problem

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 13, 2023 10:38 AM
Can I post a followup question? Can I use a rollup with a formula to find how many times I've played a song in the last 3 months?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 13, 2023 10:20 PM
Ah you wouldn't need a rollup for that, you could just use a count field like so:
And I've updated the base I linked above to have it as well

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 24, 2023 10:43 AM
Bam! awesome thank you! Not sure if I'm more literate in Airtable, therefore this forum is more useful; OR if the community is growing but I've gotten a lot more useful response on here
