So if this was done with just bubble you could have a date range and once an evening has passed and you add a new one, the evening that has passed will no longer show. It will start be in the DB but just will not show on your RPG.

This issue you are having is purely because bubble and airtable sort data differently and make it hard to talk to each other… this issue is greatly extenuated when it comes to reading large DB’s from airtable.

For example…

We had a platform that I was working on and everything was fine through testing, platform and speed were running decently and we handed it over to the client. The client started uploading data into two different tables and as they did that (table only had about 50-100 entries) the load times of pages and RPG’s was greatly affected.

We spent days trying to fix the speed and performance but unfortunately we just had to bit the bullet and change to bubble. Once in the bubble DB, all issues were gone and everything was much easier to work with.

Airtable is great for what it is, a place to sort huge DB’s for cheap but when it comes to working with the data and doing it quickly, it falls apart.

If you are looking for an external DB then I would recommend looking at Xano

But I would recommend sticking with the bubble DB over everything else first

2 Likes