Make a change to the most recent item on list

I am trying to build a functionality where when creating the next item on a list (a session) you set the most recent session (the one you just made) to active and the one before to inactive.

So by making session 2, session 1 becomes inactive.
By creating session 2, session 3 becomes inactive and so on.

I cannot figure out how to make this happen. Heres what I tried…

I was hoping the drop down would allow me to enter “-1” but it does not. This, in theory, would work but it looks like bubble doesn’t allow it.

Any suggestions?


Are you able to sort the list by date, descending and then instead of count select item # 2?