When you have your data neatly set up on Airtable, especially when they are particularly financial data and numbers, you would want to connect to them on Excel (or Power BI), and do the analysis (or charts) from the latter.
Excel’s Power Query can ETL (Extract, Transform, and Load) data from your Airtable database, and here’s how to even work around the 100 Rows Limit or Pagination.
What you need are:
So I created a throwaway Airtable account for the API key, a throwaway workspace from that account, and and loaded the Simple Project Tracker base template, just for this demonstration.
You can get your API key from your account page (https://airtable.com/account):
The Creator plan is a current experiment that gives a new solo user almost all of including blocks, without the usual time constraints of a Pro trial.
Once the person adds collaborators to the Creator workspace, it morphs into a 30-day Pro trial, to experience the power of Airtable Pro with others. Once users are added to a workspace, all users will have 30 days of premium use before payment is required.
*If no collaborators above read-only are added, the Creator-plan (Pro features) will remain in effect indefinitely.*
I’ve seen a lot of topics and/or feature requests to hide tables within a base. I want that as well. But on top of that, I don’t see topics here about hiding view items that you’ve actually created, not just those created and made personal view by other users. I’m not referring to how to toggle on and off the Views pane. I mean the different views that you’ve created, whether they be Grid, Form, Calendar, Gallery or Kanban, can they be hidden to declutter the Views pane, or better yet, maybe have the ability to group them in folders?
I have created several views of the same table and they somehow already cluttered my Views pane. I don’t want to delete them because I have certain use for each of them.
And today, look, you can now group views into Sections:
Thank you Airtable for listening to your users. Now I wish I could have the ability to hide this “Create a vew” pane/section.