How to Build an Airtable Admin Client
Airtable is a cloud-based project management system. According to the company’s website, it is a spreadsheet-like database solution. This spreadsheet-database hybrid features powerful capabilities to create and share relational databases. With a simple and visually pleasing user interface, Airtable allows anyone to create a database in minutes. Users can store, organize, collaborate on information like inventory, sales leads, new orders placed, delivery partners onboarded, employee directories, and more.
Why build an Airtable Frontend?
While users love how they don’t need to learn SQL or how scripting works, there are situations where Airtable is not a complete solution.
- Airtable is highly customizable, yet, when it comes to user-based permissions, it is not as customizable as everything else. The platform only supports 3 levels of permission control similar to that of Google Sheets – Edit, Comment, View. It’s also not possible to hide certain fields from users.
Manually creating filtered views: Everyone that has access to a specific table will be able to see everything, which can lead to situations where you’ll find yourself duplicating tables and workspaces just to filter information to certain users, effectively doubling your work and muddying your databases.
- Also sharing these filtered views, allows users to play around with URLs and parameters in the web browser.
- API response limit: Airtable APIs allow you to retrieve only up to 100 rows. Integration and automation capabilities are limited.
All this can easily be fixed by integrating the Airtable database with DronaHQ and building a quick frontend application.
How DronaHQ helps overcome Airtable Database Challenges:
- Drag and drop admin panel – Visually design admin interface by dragging and dropping pre-built components like table grid, lists, charts, form fields, buttons.
- User Management – Granular permissions allow admins to create levels of access that a user or a group of users can have on an app. You can configure who has full access, edit access, view access, delete access and so on.
- Embed filtered views with browser caching off – Instead of manually adding filters to create user specific views or permission specific views of your table, DronaHQ allows you to embed filtered views dynamically.
- Retrieve more than 100 rows – DronaHQ’s cursor-based pagination support returns offset for the next page content instead of numeric pagination which is supported by the relational databases (like Airtable, MongoDB and so on). This feature uses the Offset value to scroll through various pages based on the previous page’s offset value.
How to build a custom Airtable app?
For the visual learners out there, we have a short YouTube video explaining the whole process in detail. In the video, we go over:
- How to connect Airtable data to DronaHQ apps
- How to design an Airtable admin panel
- How to access more than 100 rows of data
- How to create a CRUD interface to edit data in Airtable
- How to create user-based views for Airtable frontend
- How to design an Airtable Dashboard
- How to embed Airtable views with user-based filters
- How to use Actionflows to Update or Delete Airtable records
Step 2 – Configure the Airtable connector
Step 3 – Build the UI
Step 4 – Connect Away!
All that’s left to do now is connect the APIs added in Step 2 to Controls added in Step 3. To do this, you can click on any control. Click on bind data on the top right, click on “connector”, and select the connector you made on Step 1. Once you do this for all controls, your admin panel is now ready! You can preview it to ensure it works and publish it when ready to share it with your organization.
Follow along and learn how to build a frontend for your Airtable data. See how you easily build a powerful front end for Airtable as a database, learn how to send data to Airtable from an app, and create secure access controlled views for different users. Easily build front-end web apps for Airtable instead of Airtable’s limited Form view