I’d like to use airtable for a Chat messaging app but when i see the pricing page and it says 5000 records per base i am wondering how to set up the base and tables to ensure i don’t go beyond the limit.
As chat messaging between members will be very frequent it will keep adding the comments as rows. Is there any way to insert the new comments/chats in a more optimal way to ensure we don’t hit the limit soon? Any tutorial link for Chat/message oriented app?
Anothr question i have is if we use a filter date (say records > 30 days), the filtered table shows lesser number of records. So, does Airtable treat the current records after the filter is applied or will it consider the unfiltered records?