Transcript
Use with ChatGPT / Claude Auto-scroll A
The speaker reacts to how quickly the app is being built and introduces the idea of creating a five-minute app from scratch.
Speaker A
Anything.
Speaker B
That's insane.I blinked and you built an app.
Speaker A
So I wanted to do a, do a five minute timer and I'm gonna build this from scratch for you guys.Okay, it's starting.Crap.
A simple spreadsheet is created to track clients, project status, and deliverable links. The speaker explains the basic data structure that will become the app.
Speaker A
Okay, we're gonna start with a spreadsheet.I know there's a lot of you that are making spreadsheet or making projects for clients.
So I thought it would be fun to start off with a kind of like a client management app.So we'll call this client and then let's say we have their.That'd be like their name, this would be like the status of their project and then maybe we want to know like the deliverable so you can have a link to their project.So I'm gonna add in some dummy data here.We'll say Adam, Darren, Brad, open in progress.
So this is the status of each of these projects and complete.And then the deliverable for this one is going to be the link that I want you all to go look at, which is mine and Brad's partnership page on my website.So really simple, we're just tracking who our clients are and what status their projects are in.How do we make this into an app?
The speaker introduces Glide as a no-code platform that turns spreadsheets into web apps. They log in, start a new project, and connect the Google Sheet as the data source.
Speaker A
So this is a demo for cxc.
So I use a platform called Glide.And Glide lets you build apps from spreadsheets that are web apps.So they exist on the web.They don't require the Apple App Store or the Google Play Store.So I'm going to log in here and build an app off of this simple spreadsheet that I just created.
So all I'm going to do is press new project, let's call it demo.I'm going to build an app and then my data source is going to be Google Sheets.
And then here's my demo for cxc.So I choose that spreadsheet and then this no code platform is going to look at my data and build like a little template app based off my data.
The generated app is refined by renaming tabs, adjusting the list view, adding deliverable links, and testing edits. A new client is added to show that the app updates the underlying data.
Speaker A
So you can see here, it's added one tab with a list in it of my clients.So let me go ahead and rename this tab to be clients and then I'll update this list view to add a little image here for their name and then I can click in there and it's already given me like a template of their data there.So we have their name and then I wanted to have a link to their deliverable.But right now there's nothing in there.So let me add in right here.So here's a link to their deliverable and then it's Also given me an edit page where I can update their client name, their status and their deliverable.
And it's also out of the box, giving me a way to add.So let me go and add a new client.
So we'll add in Harold here and say his project is open and deliverable.Hasn't been added yet, so I'll add that.So now we have four people in there and then behind the scenes, he's been added to our data set here.Now we have a functioning app where we can add clients and edit them.
The app is published, branded, and refreshed to show the final result. The speaker wraps up by explaining why the app is useful and the others react with surprise.
Speaker A
And then the last thing to do is to publish this.
I can publish this app.
And copy this URL and it's made this app available on the web and I can sign in with my email address or I can just for demo sake, let me turn off the privacy for this app and I can update like the icon and change to my company branding.
And then I'll refresh this and it should have all those changes reflected.And so there we go.Now we can view these projects and add new ones.And so it's really simple to balance three clients in your head.But if you were to have 50 clients that were all in different statuses, it's nice to have them all in an app.And you can customize this to be specific to your business.So how do we do?So less than five minutes.We have a simple app created with Glide, which is what I use.So I'll pause right there for thoughts, anything.
Speaker B
That's insane.I blinked and you built an app.
I literally took my camera off for a second and was gone for 15 seconds and came back and it's.I missed the whole part where you built an app.