Intro
Welcome to Airtable Wiz use-case series, where weâre showcasing real life products using Airtable-Stack.
This is not a guide or tutorial, but an overview of a product created using the Airtable. If you like what you see, read until the end to learn more.
The Idea
We have members in the No Code Asia community who are founders of no-code tool builders, as well as products created from no-code tools.
So we decided to showcase them on our main website â Made by APAC, a dedicated directory page of Asia-Pacific builders. Try them out yourself.
The Flow & Front End
This is where Pory.io comes in.
Quick intro: âPory is a no-code platform for creating apps and portals using Airtable__. It takes less than 1 minute to connect your data and has a growing collection of building blocks.â
For the flow, we have two: 1) Viewers, and 2) Founders. Three, if you count the website admin.
Letâs get to it!
For viewers
Like any other directory platform, you can immediately browse through the list when you open the page as shown in the screen above.
Here it is filtered by country names. Since weâre APAC, you will only see the countries from this region. There are only 6 of them at the moment - Australia, India, Indonesia, Malaysia, Singapore and Vietnam as these were submitted by their founders. If youâre from countries not in the list, it will show up once youâve submitted. Read âFor foundersâ below on how to do it.
To view more details, just click on each card. It will show the founderâs name(s), the description, country-based, and their Twitter links.
For founders
You only have one action. At the page, click on the âSubmitâ button and fill up the form. As simple as that.
The admin will receive a notification email, and they will do a quick check.
Once confirmed, you will get an approval email like below.
The Back End
Here we will touch on everything Airtable (almost). From the table to the beauty of its automations.
â__Airtable is a spreadsheet-database hybrid, with the features of a database but applied to a spreadsheet.â â Wikipedia
Airtable base
In this base, weâve set up the fields as below.
- Title - Company, app or product name
- Subtitle - One-line description/sales pitch
- Avatar - Brand/logo
- The Founders
- Call to Action URL - Links to website, sales page, etc.
- Twitter URL
- Country
- Approved â For Admin use
Airtable views
Basically, youâll need TWO views to make this work.
- All â I renamed this from the default view
- Published â Filtered by âApproved â
â
- This view will be visible on the main page.
The Form
As seen in the GIF below, all the fields are needed except for âApprovedâ and âCategoryâ which is for Adminâs view only.
Copy the link which you will add to the Submit button in Pory.
The Automations
For this project, I only did one automation, which is to send approval emails to the founders.
The trigger will be when the âApprovedâ field tickedâ .
Not too fancy, but gets the job done.
Takeaways & Challenges
This was as easy as it looks. I actually learned a lot about Airtable from playing with Pory.
I started with one of their templates, but they somehow removed them recently, and introduced âBuilding Blocksâ instead.
It should be OK even if you donât have the design fundamentals. You can always copy from existing websites out there.đ
Steal this idea
If youâre new to Pory and Airtable, this can be a fun project. I had a great time myself during my first try.
Putting the design aside, you can recycle the same structure with different ideas.
You can build:
- A job board
- A membership directory
- Local store directories
And a lot more.
Are you looking for a tech partner?
Iâm giving out LIFE-TIME deal: 50% OFF my Starter CTO package. Only for the First-5 partners, use the code: âCTOBUDDY20â.
Get 7-Day Free Trials NOW! Cancel anytime!
đ¨LIVE Count: 1/5đ¨