Save the date! Join us on October 16 for our Product Ops launch event. Register here.
May 26, 2017 11:20 AM
I have created a long list of concert dates in AirTable. I group the list based on artist name, and sort by concert date, so each concert date for a given artist appears chronologically in one data set.
For an integration with another system, I need the last date listed for an artist to have a check box checked in the same row as that final concert date. Keep in mind also that as concert dates are announced, they get added to the list, at which point the check box for the previous last date must be unchecked, and the new final date check box should be checked.
My process now is that I manually review the list and uncheck the previous last concert date, and check the updated last concert date.
Any thoughts on automating this process?
May 26, 2017 11:37 AM
You can set this up as follows:
MAX(values)
. This should give you the last concert date for each artist.For more examples of this workflow, see these other threads:
May 26, 2017 03:52 PM
I see Matt slipped in as I was answering this. :winking_face:
You can also check my reply to a similar question from a couple of days ago, which included a simple base to demonstrate how this works.