Hi! I'm doing some work for a nonprofit with a limited budget to set Airtable to help manage their annual event.
The event pulls in a variety of pieces of information about each of the following (and this is how I have drafted the workspace):
Some of this should be carried over YTY so the bases could be re-used with new, yearly tables, and some is unique to the calendar year.
I originally planned to have a base for each of these, and sync where needed. However, until they get a paid plan, syncs would have to be manual, which doesn't seem ideal.
I'm wondering if it would be better to use a manual sync or combine bases somehow?
It's difficult to give solid advice on these kind of things via this community. I would say: think about your structure first, use rollup fields (and thus also lookup and rollup fields) and use the power of separate views to your advantage. Also, use "tags" (eg single select fields) to differentiate years, instead of making new bases/tables for each year.