Make a change to the most recent item on list

Need help Database
1

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…
image

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?

Thanks

2

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