How to automatically add new entries to another table


Hello Community!

Currently we have a membership plan section on our AirTable Base.
But now We’re planning on adding a way to track the previous membership of our member.

here’s a sample base for the aforementioned situation.

If you’ll notice, we have a table named as “Membership Plan” What we want to do is for every change of the membership plan, we’ll store their previous membership on a column named “Previous Memberships”