Flutter

Build an Office Inventory System with Airtable in 3 days using DhiWise

348
Saved hours
iconicon
Usecase-img

Airtable is an easy-to-use online platform for creating and sharing relational databases. The user interface is simple, colorful, friendly, and allows anyone to spin up a database in minutes.

Airtable is a relational database, which means that it's designed to represent the relationships between different concepts and/or objects. A linked record field represents a relationship between two different objects, ideas, or people. You can use it to link two tables together, like Artists and Albums.

It allows you to easily create a database that holds the information that matters for your work. It uses it to power the visualizations, processes, and integrations that make up a custom application that's truly unique to you.

The API provides an easy way to integrate your table data with any external system. The API closely follows REST semantics, uses JSON to encode objects, and relies on standard HTTP codes to signal operation outcomes.

Metadata:

Airtable API gives you the ability to list all of your bases, tables, fields, and views.

Rate Limits:

The API is limited to 5 requests per second per base. At this rate, you will receive a 429 status code and will need to wait 30 seconds before subsequent requests will succeed.

The Challenge

Companies have access to more data than ever before in today's digital economy.

It is hard to manage extensive data in a book, diary, or Excel sheet. Especially in the IT field, it's worthless to use a pen or paper to maintain a record.

It must be hard to manage all data like total team members, total devices, total furniture, and total assigned devices.

Now the problem is who will maintain all the records. Who will manage the whole data? How to maintain a database? How much cost the need for storage ?.

To overcome this problem, the idea of building an “Office Inventory System” came up.

The Solution

DhiWise built a Flutter Application in 3 days with just 4 steps.

  • Importing Figma
  • Adding API
  • Setting up proper navigation,
  • Building the application

Let’s dive deeper…

Time Calculation:

If this application was created by a beginner developer with all manual efforts then it could have taken up to 25 to 30 days.

Why this much time?

Because of the following reasons:

  • Table structure
  • Screen design
  • API endpoints
  • API request/response

Build an Office Inventory System using DhiWise in a few steps

DhiWise saves the cost of time for the developer to develop an application. The best part is to save time and invest it in other functionalities and tasks.

Here is the step-by-step guide on how this was done:

  1. Designed a table structure in Airtable
  2. Converted Figma designs to Flutter code
  3. Added APIs in API runner
  4. Defined constants
  5. Added Navigation and Back Navigation
  6. API Integration
  7. Bind data with a view
  8. Built an application.

1. Designed a table structure in Airtable

Employee table

Devices table

Furniture table

2. Converted Figma to Flutter

The following Figma designs were imported in DhiWise:

3. Add API in API runner

The Postman collection of API in API Runner was added and this is what it looked like:

4. Define Constant

Here, required values used in projects globally can be stored. So used globally we maintain a separate file where all properties and values are defined.

5. Add Navigation and Back Navigation

Proper navigation and back navigation was added to the appropriate screens as seen below:

6. API Inetgration

7. Bind data with a view

Here binding data with the view means the binding key to its value (field).

8. Build an application

After completion of all the navigation and API integrations, the application was finally built.

After running this project in IDE, a little business logic was added, the code was modified a bit and the working application was finally made. This application is available on GitHub, just clone it and modify the code.