+11I'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.
Best answer by TheTimeSavingCo
+11Thank you! Apparently I don't have a solid handle on how roll ups work yet. This solved my problem
+11Can 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?
+31Can 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?
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
+11Bam! 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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
