Hi there! Is there a formula for isolating the last available single-select from each group?
I’m looking to only show the Shows that are marked as On-Air but also only want to see their currently airing season. I have a single-select for On-Air or Off-Air, and a single-select field for Seasons, but let’s say Jersey Shore has 6, and Teen Mom has 10 seasons, I only want to see Season 6 of Jersey Shore and Season 10 of Teen Mom. Is that possible?
This sounds like something that could probably be done with a rollup field - but I’m not sure I understand the context of where you want to see this data. Is it in a linked table that you are trying to display only particular shows?
I have a base (Long Form) that holds all the episodic metadata (Show Title, Seasons, Episode Title, etc) and another base (Short Form) that holds the videos associated to that show (Highlights, Promos, etc).
From the Long Form base, I’ve marked which Shows are On-Air, and from that list, that On-Air view is synced with the Short Form base. I haven’t figured out how to show which season of the On-Air show is “current”, but I’d like that to display in the Short Form base.
This worked! Really appreciate you walking me through this one Jeremy, this also taught me a lot about the power of the Lookup and Rollup fields, and saves me a lot of time in the long run, thanks so much!