Help

Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Re: Extract highest number from an array...

Solved
Jump to Solution
1165 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Aaron_Hess
6 - Interface Innovator
6 - Interface Innovator

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.

Aaron_Hess_0-1678485879797.png

 

2 Solutions

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Hm, I was able to get this work like so:

Screenshot 2023-03-11 at 11.20.16 AM.png

Screenshot 2023-03-11 at 11.20.20 AM.png

 

Screenshot 2023-03-11 at 11.20.10 AM.png

Here's a link to the base if you'd like to check it out

See Solution in Thread

Ah you wouldn't need a rollup for that, you could just use a count field like so:

Screenshot 2023-03-14 at 1.20.05 PM.png

Screenshot 2023-03-14 at 1.20.01 PM.png

And I've updated the base I linked above to have it as well

 

See Solution in Thread

5 Replies 5
TheTimeSavingCo
18 - Pluto
18 - Pluto

Hm, I was able to get this work like so:

Screenshot 2023-03-11 at 11.20.16 AM.png

Screenshot 2023-03-11 at 11.20.20 AM.png

 

Screenshot 2023-03-11 at 11.20.10 AM.png

Here's a link to the base if you'd like to check it out

Aaron_Hess
6 - Interface Innovator
6 - Interface Innovator

Thank you!  Apparently I don't have a solid handle on how roll ups work yet.  This solved my problem

Aaron_Hess
6 - Interface Innovator
6 - Interface Innovator

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? 

Ah you wouldn't need a rollup for that, you could just use a count field like so:

Screenshot 2023-03-14 at 1.20.05 PM.png

Screenshot 2023-03-14 at 1.20.01 PM.png

And I've updated the base I linked above to have it as well

 

Aaron_Hess
6 - Interface Innovator
6 - Interface Innovator

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