Come, let's Glide ๐Ÿ’โ€โ™€๏ธ

A No-Code tool that helps build apps quickly with your data

ยท

6 min read

Introduction

Recently I started to explore Glide for work. Glide is another No-code tool in the block, but quite a different one in terms of how it started out. It's growing pretty fast in terms of features. Lot of use cases can be handled using Glide, and it is based on the PWA approach (Progressive web apps).

There is a massive advantage of making a Glideapp as a mobile app very easily without uploading the app in playstore or appstore. This is one of my favorite aspects of Glide.

๐Ÿ’ก
By no means this is a comprehensive tutorial talking about all features of Glide. I just plan to scratch the surface and will share more posts as I keep exploring.

Approach to Glide

One stark difference I felt when I started to pick up Glide was that, one had to start from data, and not try to build a user interface/front end first and then try to add data. That's not how Glide works nor it is not meant to be approached that way.

Instead, the whole idea is to connect your data as the first step and Glide builds an interface using the data that you provide. It also provides a decent option of automating a lot of workflows using Glide actions and Integrations with a lot of tools. See here for the tools with which Glide integrates as of today.

Glide is perfect for many businesses that has solid workflows (like Order management, Customer management, etc.,) which are mainly data driven. One can very easily build an app (both web and mobile at the same time) if they have their data in hand.

If your idea is to build a jazzy user interface for app I wouldn't recommend Glide, as in my opinion it is not meant for that. Rather than you can try doing that once you are an expert with Glide.

Let's build a small app

Time to choose a use case and start building. How about an Event Management use case? Most of us will be able to relate quite easily as I'm sure we do attend concerts, magic shows, stand-up comedy shows and much more ๐Ÿฆธโ€โ™‚๏ธ๐Ÿคนโ€โ™€๏ธ๐Ÿง˜โ€โ™‚๏ธ.

Let us start to think in terms of data. What are the tables that will be required? Just to keep things simple,

  • Host - The organizer or the team that will host the show/workshop

  • Team - Users from the Event Management company who are responsible for the events that they sign up with hosts

  • Event - The actual event related tables

  • Ticket - Transactions made by the audience to attend an event

Now let's add the columns that will hold data for each table. Again, to keep things simple, I'm not being exhaustive in terms of detail that goes in each.

A sample of table Host

Company NameAddressCityStateZip codeCategory
Houdini Magic Company178 Wood AvenueScrantonPA18505Company
Winds of the Acoustic89 Maple LaneEdisonNJ08817Individual

A sample of table Team

First NameLast NameDesignationDate of JoiningAssociated Hosts
JohnDoeSenior Event Manager01/01/2022Winds of the Acoustic
JeremyHolmesJunior Event Manager02/02/2021Houdini Magic Company

A sample of table Event

Event NameFrom DateTo DateEvent LocationCost / Ticket ($)
Magicians of the East12/01/202312/31/2023421863 Cr 5300, Coffeyville, KS 6733775
Phil's Flute Concert12/01/202301/31/2024#6644301 Vine St, Hays, KS 67601150

A sample of table Ticket

Purchased ByPurchased for EventNumber of TicketsCost
Smith WallacePhil's Flute Concert5375
Lizzie MayPhil's Flute Concert2300

Let's start building in Glide

  1. As a first step, go to the Glide website and sign up for a free plan

  2. It will ask for an App Name, I gave "Smart Events"

  3. For Data source, I selected "Glide tables". There are other options like Google sheets, Airtable, Microsoft excel too

  4. By default, it provides two tables and some sample data in each

  5. This is how it looks like at the moment

  1. There are 3 tabs in the center, Data which is used to hold table information, Layout to design the user interface and Action to describe automation if required

  2. For the moment, let's just retain the default tables and start adding the ones that we defined above

  3. Under Data tab, click on the + icon on right side and create a new table, name it as Host and add the columns as explained in the previous step.

  4. Let's now move on to the Layout tab and add a new Navigation for the newly created Host. Click on the + icon on right side

  5. I chose the option "Screen from Data" and selected "Host"

  6. Boom ๐Ÿ’ฅ It creates a screen for Host with all basic functionalities like Add, Edit, Delete. I found it to be really cool ๐Ÿ˜Ž

  7. It now looks like this ๐Ÿ‘‡

  8. Repeat the same steps, right from creating a table, adding rows, and then adding navigation for Team, Event and Tickets

  9. On creating all the tables and corresponding screens, this is how it looks like ๐Ÿ‘‡

    1. Time to publish โœจ. Click on Publish button on right side of the screen. For the name, I gave as smart-events.glide.page. Under Privacy tab, I selected Public and No Sign-in option so that end users need not sign up to access the app that I just published. There are multiple options as well from an access level. As always, this is just to keep things simple.

    2. Try clicking on my smart events app now!

    3. Woohoo, a basic app is ready in such a short span of time ๐Ÿคฉ

      ๐Ÿ’ก
      Note that there is a lot more to be done to make the app truly useful. I shall probably write a few more posts, on how to set properties for each column, how to add simple actions, how to modify edit screens, how to modify behavior on submit, how to publish it as a mobile app and so on.

Good resources

Here are some good resources that helped me pick up Glide:

Conclusion

Glide is a very powerful tool for many use cases driven by a standard workflow, or if you can visualize a workflow for the use case. The speed in which one can build an app is truly mind blowing ๐Ÿ˜ฎ.

It's definitely worth learning Glide if you want to add one more tool to your No-code kitty.

ย