Building Mobile Apps (without code) with Jack Vaughan from Glide Apps | Makerpad Webinar

right eight haven't and 1/8 said no but I would like to you great that's really ok ok we got 28 people don't think we should probably just get going and then we're gonna filter in as an one so so let's give you a quick outline at the core so my name's Tom er and work on the education team here make pad for the purpose of this cool my name is make pad team so you don't actually get to have a name the first of all we're just gonna run through I sorry on this person on the other so the webinar is Jack Warren he is on the education team glide up so the glide wizard if you want to know anything about Glide he is your man to go to far exceeds my knowledge so basically to start off we're gonna just go through a really quick introduction to glide apps what is what you can do with it then we're going to talk about you may have got a hint from the poll about the template store so one of the things that's pretty good with a glide apps once you get used to building apps then you've got this option available to you to publish templates or so Jess you're going to more detail on that then we're going to cover some design tips around how to design your apps well then we're going to talk about user specific columns user profiles tab visibility navigation some data editor updates and then we're gonna have the ability to ask some questions at the end but also if you have any questions about anything we're talking about throughout feel free to far away in the Q&A and then if I think something is relevant both go ahead and answer that straightaway hopefully that is a bit of a good overview Jack if I missed anything yeah no that's great yeah awesome so I will that further ado I'll hand you over to the master himself which everyone cool thanks umm so yeah there's a as with most webinars you know guys this whole range of experience levels the people who are on right now so I will do my best to give you an overview of glide and also cover a few sort of new features that we have arguably speaking if you're a complete beginner might be a bit complex for you and if that's the case don't worry about it just let it kind of wash over you and think more about like what you can do with this not do you fully understand how to do it right now we've got some like we've got enough we've got some good documentation over at glide apps to calm slash learn where you can go through a number of like sort of videos and documentation to learn the basics and so just try and enjoy and open your mind to what's possible today cool so I'm going to show my screen and give you sort of basic overview of of glide and let me just try and get the right window here here we go cool you all see this great okay so the essential premise applied or the simplest way of thinking about it is that you're using a spreadsheet that to create an app which might seem a bit strange in the beginning but more you get into it the more it kind of makes sense as spreadsheet it's really just the most common and ubiquitous way to manage data nearly anyone you know has at least known about spreadsheets and has always certainly used them so we use Google sheets to generate an app view and then provide a number of kind of design capabilities and then other functionality on top of that so if we look at this spreadsheet here we've just got the standards if you're new if you've been using glide for a while you'll be aware of this kind of data in here this is like a simple employee directory with people who work in the company their title their number their email photo where they work their manager you see and these are basically properties of each person so this is a person this is a person this is a person right so this is a very simple way of like structuring data in spreadsheet just listening information and if we go to glide and we click from a Google sheet we're gonna create a new app from Google sheet we can also go from templates which I'll talk about in a minute we click a new app from the Google sheet and I'm going to pick make pad employees and select glide will generate a default app as a starting point for me and then I have various things that I can do with that from this point so glides picked up a couple of things it's picked up the image links that were in my spreadsheet the name of the person and their title and then is applied a kind of layout but I can change that layout to do layouts and had different kind of designs on the top and then when I click on one of these people we can see that the properties of that person Murray Rao let's make sure that the image is working there it creates a nice detail screen so this is the the basics of glide and how it works and we give you a lot of components then you see on the right-hand side here what Glide is done as it said okay well let's look at the number column here in our sheet so the number of Murray route this one here it's applied a component to that number so it shows up but we can still move that down change it we can add a different component you can see that we've got linked components title components and there's a whole host of other different components that you can add to allow people to do different things in your apps and then the last little thing again because this is sort of like super quick introduction if this is kind of going of your head or you're not sure don't worry about it just try and enjoy today you can watch videos over at glide apps calm the the other little thing which is quite powerful is our data editor so as I click on here you probably noticed this looks very much like a spreadsheet right like we've got columns we've got rows but there's a little bit more going on here so if you use spreadsheets for any length of time you've probably come across formulas or functions and maybe even scripts and macros to do really kind of clever things with spreadsheets to wrangle data to you know do lots of really interesting things but it's not totally accessible and sometimes it's a bit hard to learn and sometimes it feels a bit like writing code and glide is you know unofficially an O code tool and so what the data editor allows you to do is to add kind of interesting columns that do certain things here you can see we've got an if-then-else column you could probably imagine roughly but what that's going to do we have a relation that's a concept that some of you may know about I look up lots of different sort of you call computations that you can create without code so that's a kind of quick super fast overview of Glide Tommy is there anything that you want to add there or you think I missed out for new new people no probably the correction it is as simple as possible it is just to make everyone aware that if you can enter information into a Google sheet then you can create line up so if you are seeing this for the first time and see probably up on the screen and see some information in like Google sheet that Jack showed if you can enter any information you want to show up in an app so text images links phone numbers and then ton of other things you can create light up without needing any technical any further technical know-how at all so you might be seeing like a fancy looking at on the screen but all you need to do is be able to input data into a Google sheet yeah pretty much yeah for sure and what we're actually gonna be going over today is some of the latest features that we have so some of them might be a bit complex for you but again just try and put it in the context of you can do something really simple like this app where you list information and then you can do more interesting things where you have actions relations subcategories like really interesting layouts and stuff like that so yeah so today I'd really love to talk to you guys a little bit just initially about the Glide template store so some of you have built templates some of you would like to build a template but if you go over to Glide apps comm slash templates you'll see a whole host of different templates that Glide is made and increasingly a lot of the members of our community and our guide experts have made and these are sort of they're aimed to give you a great starting point so if we click on glide simple store and we preview the template if I'm a new user of glide and I come to this template and I want to build a store this is going to get me up and running right away all I need to do is copy this template and start editing stuff and once I've copied it I'll get the Google sheet and the app and I can just be up and running so it makes the process even quicker than what I've just shown you there but we want to encourage you especially if you're a well anyone any level is to to start making templates right because if you're a a no code maker and you're already messing around with this stuff and you're already like honing your chops you may as well make some money out of it right so we're taking submissions from anyone in the world who's who's making guide apps and I think it's a really good opportunity so what kind of things do we want so a glide template could be anything right there's some really interesting ones in here but generally speaking you want to think about a problem to solve you want to think about like a business problem to solve or personal problem to solve and then build an app that helps that and you'll see lots of different things in here and I'd encourage you to have a look but just as an example some of the kind of archetypes you could build an app for dentists you could build an app for hairstylists or an Airbnb manager hizzouse Progress one of our collide experts did that while ago and he also did one for a real estate company and people buy these templates you know so it would really encourage you to start thinking about that but and all it would probably take is just a couple of days work maybe one or two days work putting in some some good design time and then this app will be out there and the template store and people will hopefully buy it so I mentioned about the coming up with ideas for templates and many of you will probably have loads of ideas swinging around your head already but if you're not sure but you're like oh I'd love to build a glide template then we could just chat a little bit now Tom about like the id ideation side of things and guys you know you know put stuff in the chat as well about this but essentially one of the best things I've found to come up with ideas is to talk to businesses talk to small businesses so find someone that you know uncle you know friend whatever who who runs a business and talk to them about what they do their process is there how they talk to their customers that sort of things and sort of work out you can even ask them what spreadsheets are you doing using like that's that's the perfect place to start like how are you using spreadsheets and could it be built into an app right yeah exactly just to hop in Jack just so yeah couple of questions so how does health pricing work on the template so you set your own prices how much do you take back and also Matt Porter as a question it says once you purchase a template and extend it can you sell it as your own template that's a really good question Matt so like just speaking so I'm not in any way part of the legal team for glide so we'd have to sort of clarify that I think a lot of templates share a whole host of features right so because we provide features so if it's a bit like the music industry like oh you use my chord you know it's a bit tricky but I think I think you should probably contact us if you're worried about that I don't think it should be an issue I think you'll know intuitively what what's copying on what's not um for sure what was the other one pricing that was it so yeah this pricing work obviously I haven't done much work to this app here so I'm not going to actually submit this but if you noticed I've gone to the settings area and I've gone to the general tab and at the bottom here we see this submit template store if I click there I'm taken to kind of a wizard where I can put in the title of the description a video demo and the category and then the pricing is basically tiered pricing you can only be really kind and or develop your audience because you know these template people who buy our template you know can email you and stuff and the more you give to them the more they'll appreciate what you do or you can sell for one of these tiers and these may change in the future I'm not sure of the slit but it's fairly sizable like we take a very small cut I think I can't remember sorry about that yeah so that's that's it it's easy and then we'll review them as often as possible and then give you feedback if it's not accepted but I'm going to give you a kind of a rundown of some tips about how to create good templates nice mr. cool so just going back to we just open the app here actually I can just turn this off for a sec there's anybody at this point I have any more questions about the template store or potentially creating creating templates yourself Phil so can you make an app on glide and publish it to sell on the App Store sorry say that again I was reading somebody okay so Phil says that so can you make an app on glide and publish it sell on the app store so not yet but we are working on it you're talking about the iOS and Play stores I presume that's definitely part of our future we aren't native yet but we've got it's well within the capabilities for sure in the future what perfect yeah let's let's go on to some design stuff yeah so just quickly about the about actually submitting templates they're the they don't need to be totally unique so you might be looking through the template store and being like oh man all the ideas like they've been taken I can't come up with new ones like you can you can you can set your app apart in other ways right design is a huge one right but also use sort of a use case so is it as a simple example like conference apps right everyone makes conference apps that's a really like standard thing to make but if you make a conference app for a specific niche like doctors or you know chiropractic on conference we don't have a conference for that and if you can make a compelling app that really is tailored to them maybe the design maybe the layout that's really legitimately a valuable app for a customer that they will buy over the kind of standards stock conference template because it's easier for them it's also it might feel like cheating for you but actually what you've done is you've inspired someone who's not used to creating apps to go oh my god this is really possible so let's talk a little bit about the the actual design side of stuff because that can really really help so let me share my screen again man so many windows ok you can all see this right yep cool so this is just like a really simple app that I put together just a single screen and just wanted to highlight a couple of design tips really the for those of you who know about Glide you may not be using all of the components that I mentioned here some of the ones that particularly get sort of they don't get used enough in my opinion from the apps I've seen are the text component so if we look at this text component here you can see that it's tied to or with displaying the word welcome in it and we can change the alignment of that we can change the different size of that text here to all caps and also if it's really long we can truncate text lines as well which is which then triggers that kind of more button there and you can create some really nice simple text layout so you see this kind of h1 here with a simple subtitle underneath is very simple but actually it's so much more beautiful than just like a simple basic text component that just goes here's some information you know so using the temp the components that we already have in glide to make things look a little bit more beautiful insert is is a really good thing to do this also extends to like the basic table component right at the bottom here you can see that I put just three properties in a basic table component and that makes things just look a little bit neater and well put together this extends to cards as well if I look at this inline list here this is the cards layout I don't see enough people using that but it's incredibly flexible as a layout there's lots and lots of different design options here and also combined with overlays as well so down here you can see that I've got a tag I've got a favorite button I've got an avatar avatar text and we've got this nice shadow behind it so just really encouraging you to kind of explore some of the functionality in the design layouts that particularly tiles and cards if you haven't already and then a kind of overlooked one is graphs because you might not think are graphs that's for like a data heavy app like I don't need that but actually sometimes it's it can just make your app look really beautiful and it doesn't have to show incredibly useful data it could just be really simple things and then this just is like very colorful the design team did an amazing job with the color themes in these charts if you look here there are a whole load of different things based off different people and artists we've got Hockney we've got Missy Elliott I think we've got RuPaul in there as well which is really cool and you've got like a color theme designed by the glide team to make it look really good so you're just not much effort to make something look pretty the other thing I wanted to talk about is unsplash right because we've got a slightly overlooked feature and data editor in an image column which is unsplash if you guys don't know about it it's like amazing royalty free images from around the world and you can actually add images in glide so I've just done that and i've added a desire saw to this cell here like and you can search for anything that you want so particularly for templates one of the things that we'll really want his good dummy data so like so that you can understand what this app is about but also great images just sells out so well staying with images if we look at the top here what we've got is we've got this kind of sort of wobbly line going on here and if you've kind of you're new to glide you might not seen that before all that is is just a simple image right which is if I just go to the data editor and open it up it's just that right it's an image with transparency in the background so the bottom part this white part is not it's just transparent to PNG right and then what I've done is I've taken the top of this theme the bold layout right this would work in the dark layout as well and it just sort of extends it so these little little things are really good and you can build your own kind of separators right so this is this is not doing anything right but it's maybe quite nice down here as well like this is just an image but it's kind of making it look a little bit more custom right you might think about doing those sorts of things maybe worth mentioning where do you find it's the best place for it to actually get images like this images like this thing here or yes the one pretty on the home screen so people would try to replicate and look and feel of this one you've got here where were they fired so I I actually just made this in figma if you guys don't know figma it's totally free absolutely amazing design tool and all I did was let's go to this I had two shapes a rectangle and this which I think I got from a design library you go to figma crush comm is amazing load of templates made by designers nice and yeah I just put those two together today so yes I think it's a great tip I think it's one of those things that it's simple with until you see it use them you don't think of it you've got one question from Amica but image zoom in and out feature one with this feature should be available yeah how to zoom images onto the full page oh yeah you can do that so here I'm in the image component if I understand you correctly you want to zoom and pinch and zoom and like that so this isn't a great image to do it with but I'm gonna click on the image component and a lot of people miss this panel this second tab here right features if we go in here we can see that we can add visibility conditions which I'll go over today if we have time but I can also add actions right and there's a lot here and one sec where is it enlarged image sorry I missed that one right and then we click on it and then we're in the full scale image there and then I can't do this on my screen I don't think oh yeah I can look good yeah zoom in and out nice yeah that um does that answer your question on it Oh Canberra is great as well yeah nice good point on canva is great where is a lot more accessible than figma actually so if you're new to I would suggest that absolutely cool no that's great I didn't know by that either great awesome and if anyone else has any design tips like Wacom in the chat as well like there's loads of stuff out there amazing resources great websites that just give you stuff so just you know let us know like what do you use that'd be cool to know nice Adams just poked in the chat a blob maker dot that seems like something cool and it's got lots of feedback cool nice thank of it great so um should we dive in some of the latest features then come let's do it let's talk about user specific features and this is something that comes up a lot about you wanting to have apps where users can log in and do stuff and how can you personalize that sort content around people logging in yeah so there's two facets to kind of like developing an app that's really rich in terms of the user experience that it's not just an app that you're looking at passively but it's actually an app that you are a user of and that's user specific columns which I'm going to go through now and then I'm going to go through user profiles two separate things right so if any of you have used Glide before you know that with a list what you can do is you can kind of feel to that list and show only certain people certain items so if I logged into an app for example this one it doesn't really make sense as a use case but like I could make Tom as a user only see these three and me as a user only see these three right but that's hiding the whole item what if you wanted to go on to a thing and see something like private notes right or your own favorite rating these two elements here would totally not make sense if they were saved if they were synced between Tom and I right so Tom wrote something in here and then I wrote something in here what it would do it would overwrite it right doesn't make sense same with favorites same with like and stuff like that and it's only recently that we actually enabled this ability with the user specific columns so if I go over to the data editor and again if some of the skills of your head don't worry we've got documentation on it and you can kind of look at that later you're probably used to the concept of favorites right when I flavor an item or Tom favorites an item it's totally separate data and if we look at this column here is favorited we can see that it's blue right the icon is blue roze all the others are gray and that denotes that this is a user specific column and the way that you kind of preview different user data is by this preview as feature here so as Tom I'm logged in as Tom and this works in the data editor as well I'm going to favorite a bunch of items and if we go to the top item here this should be favorited I'm not sure what I did there and then if we switch to a different person to me that'll be unfavorite it you see that switch there if I go back to Tom its favorited and his private notes come back so this is a really useful feature so instead of just linking a component like action or hours right this is just linked to a normal column in our sheet that is just the same for everyone instead of that if we go to the private notes column we can see that this is linked to the private notes column in the data editor and if we scroll along to the right-hand side we can see that we've got private notes over here and it's blue so again one more time I'm just going to cut this out and we'll see that this becomes mine so if you think about this you could potentially have thousands and thousands depending on how many users you have in your app of the same cell right we have thousands users of this app this one cell would be unique to every user and this means that items in your apps like private notes like favorite can be unique right and there are a number of components that we've added recently which really benefit from this if you think of the nature of a liked component or a rating component then those don't make sense if everyone shares the data that's linked to them so this is just like a simple Pokemon go like mock app right and if we go to who we logged in us we're logged in as Tom here we go to Bulbasaur you can see that Tom hasn't liked it yet but if we do this let's say Tom likes all the saw gives it a rating of two that he's caught it and then add his signature I don't know your signature Tom but I'm gonna make it look really messy it's exactly right there's a good approximation isn't it it's very hard to do this with the mouse actually it's gonna have it see Tom's beautiful signature there and then if I preview as me all of these things change you see so this is completely separate and all of these components here the like rating core talked about oh yeah that's just a simple switch component the location component and the signature component they all benefit from user specific columns and then the last little thing and then I'll take some questions about it because I it might be a bit strange for you if you haven't looked at this before is that you can then filter different tabs based on that information right so if we go back to me so let's say I've caught this and I've also caught Venusaur right I can go over to this tab and this tab will be totally specific to me right these are the things that I've caught or that I've liked or that whatever property you're linking here and if I switch to tom he's just caught Bulbasaur right and this will update immediately depending on whatever happens here and all that we're doing in this list is in the features here we're just going to say Court which is a user specific column is true that's the condition so it's saying only show items where the user specific column of Court is true for this current user right so really really neat feature there does anyone have any questions about that because I appreciate it a bit strange especially if you're new to collide right now it's a bit of an advanced feature yes I've popped the link to the user specific columns from the Glide nice ducks into the chat so you did want to go and reference any that you can dive in and look and thing ups and questions we have can you only put images like this on data or sheets can you input images like this on data and sheets I'm not sure I understand that it's you back to the previous oh maybe he's asking or she is asking about does the user specific I didn't say this actually user specific columns don't live in the sheet right so we've got this interesting relationship between glides data editor and your Google sheet and the kind of long-term roadmap of Glide is obviously that will have different data sources like we've started with Google sheets but we are just starting work on something that we call native tables which basically means that you could theoretically build a glide app without a Google sheet and this would be beneficial for a lot of reasons for example if your app suddenly had thousands of users and thousands of rows collide native tables would totally scale to that rather than Google sheets which sometimes causes issues we have a number of apps which have thousands of users and thousands of rows then it gets a little bit tricky because Google sheets but I think so anyway all that to say that if we look at these columns here the blue ones we won't find in our Google sheet because they have to be computed and stored totally in glide right so we don't see them here we see everything up - evolves from right but then everything after that part from height number is it's just in the data editor I don't know whether that answers the question there is an - the glide apps libraries are there's a lot of info around the data editor specifically from the menu so just link this for you so you starting and it's probably a good place to go payment functionality yes subscriptions not native to glide but absolutely we have the Buy button so let's say you wanted to buy Bulbasaur you search the component for buy button right and then there's a number of different things you can connect your stripe account you can change the functionality to either by and check out straight away or you can kind of add it to your shopping cart but no not yet in terms of subscriptions you would have to sort of manage that yourself nice giving plans enable integration with air table that is something we would like to in the future I wouldn't say it's closed like I say we we would love to have other sources other than Google sheets um but it's yeah not sure exactly how far off that is but a little while kooky but yeah we love yes master how to rename favorites so I think it's a reference to renaming components oh yeah yeah yeah I'll give you a quick one on that so I've just added the favorite component down at the bottom here we can just change it so it defaults to favorite right but I can just do like or whatever and it'll change or add to my library whatever and then we go back to here we'll see well this is still called favorites but we can change that as well in the component but yeah absolutely you can change that so my library there you go my library awesome map water as asked how the signatures stored I think he has a specific use case in mind so I wanted to know yeah sure so you can see this is stored on like our service and that's you'd have to ask the glide team you can email support a glide apps for the specifics and the security of that but as far as I understand it user specific data is very secure and yeah at the moment we're working towards building like a file manager or something like that where you can have more access to this because if I if I go back to previewing as me there's no way I can access that photo in that column they're like I can't go to a media library and manage that yet but we would like to do that in future and then a few responses maybe a question for support this about gdpr and HIPAA compliant you know yeah so we're we're very conscious that we'll work we're actively working on that right now it's there's a lot of angles to approach that from as you know if you know anything about it this number requirements and glide is still relatively young company but for sure we're working on that right now and if if you're a member of our community there's some chats going on about that at the moment and you can you can learn what we're we're looking at right now awesome and there's a lot of questions what we're gonna do we'll push on through some more stuff and then at the end we'll try and get back through some more questions as well that's okay with everybody cool thanks Tom we talked about um tab visibility now yeah I was gonna quickly go be user profiles if that's okay profiles absolutely that's user profiles and user specific columns are like the main features you want to get into any templates that you make yeah they're just it just makes your apps so much more valuable and the people who buy your app will be just so much more inspired or you know it'll be so much more useful you know but it's it's hidden you know it's kind of like people sort of expect it in a way when they build in that but when they buy an app or or use it so if we think about basically user profiles lets you specify a table where your data about your users is right so if we go into the data editor here in this template and we go to users we can see that we've got the different users names their emails their image some kind of information here like access level and a rubbish biography that I must have written at some point and these are the properties of your users right and for example if you're building an app for a school you'd have the name email photo then you'd have like the student number the image the class the tutor the parent the year group and whatever use case you're building for I'm sure you can imagine like what are the properties of the people that you're building your app for the properties are the people who will be using your app and then whatever those properties are you can build your app around them right so a really simple example of this is if I go back to that table here we've got this column here which I just made up it's not a glide thing it's just a simple column it actually lives in my sheet like you'll find it if we go to the Google sheet as well and I've just written Jack here I am an admin and if we look here Tom at the moment is free right and that means that Tom and I can experience this app very differently so currently we're looking at this app as Tom right and if I scroll down we can see I just want you to notice these two components here we have an horizontal scrolling inline list pre courses this one here and then we have a button which says unlock all courses right and if I change it to me see they go away and then the button disappears and now this is a different course the different component right we've shown and hides hidden components based on the user property and we've hidden those components use using the property that I just showed you in the data editor so this might be a bit confusing but if I go to that inline list and I go to the features panel this is this inline less that we're looking at here it says in this visibility condition here it says show component when the access level is premium or admin right so that means that this component here will only show when the user which is currently me because I'm logged in as me is admin but if I go to Tom who is free it disappears okay so this hopefully gives you an idea that like this is just one component right that this also extends to tabs and this is the big announcement that we did last week which is an incredibly powerful feature where you can do the same with whole tabs and this means that you can actually build technically speaking completely different for different users right I could build an app I could build this app out as like a restaurant ratings out for Tom and then I could build it out as like a football manager app or something like that for me because I could it would be really like extensive work but and you wouldn't necessarily want to do that but it's just to show you the power of this component and tab visibility so just as a reminder that what we did is we went into the component we clicked into the features panel and we went over to visibility and we added a condition based on a property that we just came up with ourselves so you will have any properties that you want and you can create conditions so let's show you the tabs right if we look here Tom's logged in we can see his nice little user profile up there and then up at the top we see these tabs right but if I'm an admin and I log in as me we see this really nice admin tab here right where I have only stuff that's pertinent to me if I'm like the manager of the app and this could extend to like a whole different range of things right you could there's so many use cases for it you could also enable editing rights if we go to the courses page here you can see this little editing button up at the top right and I can edit it but if I put Tom back in you can't edit it because he's just a user and here we've only got two properties we've got free and premium but imagine if you had like totally different types of properties like different teams or categories or whatever you can change the app as much as you want based on the properties of your users so really really powerful a more design or cosmetic kind of thing if we look here it's probably really small for you guys on the screen but can you see it says welcome Tom it's great to have you here and if we switch back to me it says welcome Jack it's great to have you here so little really nice touches like that can be really powerful in your app it's like oh wow this app is like pretty sophisticated but for you as a builder all that's doing is if we go to home and we scroll along to this welcome message here this is using glides template column and we can see the words welcome and their name it's great to have you here and if any of you have done any mail merging in the past you'll know what's going on here we're just replacing the word name with the current user's name that's all it is so that is that is it and to do when you do that adds a huge amount of value to your app that's awesome yeah I don't think I'll actually use that before I think time tab visible that neat yeah Wednesday so this is a it was a hugely suspected feature and actually if you guys aren't members of the community I'm just going to put the link in the chat now the guy community is absolutely awesome like there's just such great tips and and chat going on in there and I posted the thread the other day actually I'm gonna see if I can find that there's anybody working on apps with user profiles integrated at the moment and I feel free to share any links in the chat we'd love to take a look so I just put in by the way guys if you put in questions in the chat I might miss them and tell might miss them so like if you really want to mansard where you put them in the Q&A as well as possible yeah if there's any any ones you like just upload them so you can stream stop the real and we'll get some questions in a few minutes as well so that link I just put in there it's like the most one of the most commented ones because everyone's talking about the different use cases for it and all the things that they're going to do with it so like you know there's just a ton of different things you do membership or gated content like I just showed you there someone in our community did a really creative thing talking of gdpr they created a custom kind of like onboarding flow screen where they had to opt-in for stuff and then they hid those tabs as I said you can create admin tabs but you can also do like teams so for example this app here what we've got if we if we just preview this app as this person here we can see that they're on the red team but if we preview as this person here I'm spelling his name wrong I always spell Keith's role you see there on the blue team and we see their items and you guys probably know how that works but what's really cool you probably didn't notice is this tab just appeared right if I go back to the first one there's no tab at the bottom but suddenly there's this secret tab right and this can be this can be extended to teams so anyone who's in the blue team if we look here at the users there's lots of different people in different teams you can this extends to across entire team so you could have like a thousand people in your app and three teams and then you can just customize what it looks like for all three teams a bit more in-depth I can't go into it too much now but hopefully it makes sense in terms of the possibility nice gone if you just three minutes we push on and they guess then was two other questions at the end okay so so right like if I'd be interested to know actually like was anyone using Glide a year ago in the like just say yes and the chat be really interesting to know like for those of you who I call Philippa great nice one and Tom yeah I'm glad you were yeah awesome no cool so for those of you who were using it you'll remember the time where we basically just had tabs at the bottom of your app right bit crazy in some ways because as soon as you went over five tabs it looked a bit whack right he just had too much stuff squishing up there so then we added the app menu where you can add these things outside but there are a number of other things those are like tabs our traditional navigation right but there are a number of other things that we've added over the past like six months and certainly updated a lot recently which are kind of undiscovered features in my opinion which can really do a lot of cool things and that's the link to screen action and lists as menus right and I'm going to go into how these work now so if you look at this screen here we we're looking at a button which has the link to screen action on it there's nothing else on this page if I go at the features panel here we can see we've got the link to screen action enabled and then I've chosen the sheet that I want to go to and that's it basically right and then if I click go we'll go to that screen and I can then customize this screen exactly how I want it's totally totally separate but if you notice we're still in the same town right we're still in the same tab but we've gone to a different screen and then I've done the same thing on Nicks this button as well so I've gone to the next chapter and the next chapter right and we're still all in the same tab so theoretically you can have as many screens as you want in a single tab and you can have this on as many buttons as you want so just with that on its own you can see that there's a whole host more now that you can do with navigation using the link to screen action I mentioned here in the in the in the customization of this button that you can either link to a sheet you can link to a relation and again that's something you can learn about more in our documentation or you can link to the current item which is often a weird one everyone kind of thinks what why on earth would you want to link to the screen that you're currently on that's really weird well it makes sense when you think about reading more or like discovering more so this is a list of people if we go to Murray we can see how properties here this is like a standard employee directory and then we see this button that says read more so what this is doing is looking at this row here it's looking at this whole row but she's got a lot of stuff in this row and she's got a massive long biography as well and we don't want to show it all initially we want to allow people to read more so what we've done is we've got a button here which has the link to screen action enabled and it links to the same item and when we do that we see all of her properties right so sometimes I see sheets where like say each of your items employees is not a good example because you know you might not have loads of properties for each employee but if you imagine I can't think of something Tom you probably think of a good example but imagine this row here had like hundreds of columns or as many columns as Google sheets allows you to do right where you have all these different properties of this single thing to show that on a single tea like Anna and then maybe a good one is a great thing of confidence yeah so you can do things with relations so you could pull in other lists but if if your item truly has unique properties that you want to like sort of show in line then you might want to use this this screen or this this button to link to more things so it could be like read more about her background read more about her projects read more about her and in each one of those screens you can show things that are relevant to them so I'm sure you guys can think of examples and then the other thing which i think is particularly cool I love this this is like arguably the most undiscoverable feature guide' cuz it's like right down in in the menu system here so we go into what we've got here we've got an inline list and in line lists usually show items right so on this tab we're showing items and when we click on each person we see that person right but if we if we go into the features of this list we can actually see that this list has an action enabled on each item and the default action for each list is view details and beauty the view details means go to this screen where you see all of the details for that item that's what view details is but if I click on this you can see we've got access to all the other actions so I could instead of you know going to the detail screen we could say like you know send email and now you see email so now this list is not a menu to go to different people it's like click on Marie to send her an email or you could do all of these other ones here so that's a really cool thing but if we go back to the details there's this tiny little check box here which is so powerful which is independent screen configuration right per item and if I click that nothing happens but what I can now do is I can configure each of these screens individually right so traditionally with lists whatever I do to this screen if I deleted this component here would apply to all of the other list items that doesn't make sense let me just go back and I don't wanna go too fast here for people who haven't used Glide before so I've turned off that feature there if I go to Marie and I take away a number for example right so and now I go down to Tams Tamsin doesn't have a number either Sarah doesn't have a none other right but if I undo that and bring the number back now all of them have a number again so your design decisions traditionally work for all of the items in your lists but if we turn this on that's not the case anymore I can go to Tamsin delete like everything about Townsend and go to Marie and it won't affect Marie so that might be like now okay whatever that's kind of cool but what that allows you to do is turn a list into a menu so what we've got here is we've got an inline list with that independent screen configuration per item turned on and that means that we can use this list layout in kind of whatever style that we want we can change the design we can add different things about it right we can add you know huge text or put it in the middle bla bla bla but this is now acting as a menu and if we go to the home screen it's completely different to the about screen it's completely different to the location screen it's just totally different right and if you haven't used Glide before this might be like I'm not so sure but for those of you have this is kind of pretty incredible and combined with the link to screen action you can do a whole host of a whole host of things so like I often give like a really stupid example but theoretically and this isn't to like show you like a practical example but you could for example have a tab that only shows up once a year in your app and it would only show up for Tom who's using your app and then like inside of that app there's a button that only shows after you enter a secret password and then inside of the screen inside of that button you have like a list of items and then on one of those items you see where I'm going with this like you can have this infinitely nested kind of structure to your app that gets really complex and this is just something to bear in mind because it's super powerful but also it allows you to create really delightful experiences for your users like you could even do Easter eggs in your apps like why not do that you know that would be really cool someone just discovers there's a secret page when they do this certain thing in the app so yeah I just want to do a time check and check on any questions Tom that we have I could talk a little bit about a couple of data editor things or we can round it up and just with questions let's do a couple minutes on the date editor just know that's something which is really useful to get grip of and then we can add in some good words for all the questions left in there so we have done a fair few videos on the data editor so you can watch those and understand a little bit more about it again just for those of you who need to collide with Docs glide apps comm which has written text and videos or if you're just a video person if you get to glide apps comm and learn to glide sort of got a growing library of resources and the data editor here has kind of some of the most videos in it and you can watch the introduction why is that not there I know it's that there we go cool so computer columns right like the difference that I want to highlight to you guys between columns is the difference between we create a new column here we're gonna say this is a normal column we're gonna say it's just a text column right we could like make glides recognize that we're gonna do a number column a date/time column we're just gonna say text that's fine and we're not gonna click column is user specific I always find that really hard to say actually user specific I always feel like I'm falling over my words and then if I write something in here and I edit my sheet we're gonna see that the normal column has appeared and that text is there so this normal columns in glide are the same as your sheet columns right and you can create them from both places which is cool but if I I'm just gonna I can't delete from that I'm gonna delete it from here if I add a new column I'm just going to reload my sheets so that disappears it's taking a sweet time if I add a column now and we'll just do text again and then you make it user specific that will only live in the data editor and that won't appear here right then the third type of column right is the computed column and that's everything that you see down here and we're growing this all the time we started with relations and then template and then some more sophisticated stuff like if then else and lookups started coming in and one that we added recently is the distance column which is a really cool column so I go over to this column here I think this is isn't it no that's not yet we're just good one sec okay cool yeah so let's say in this app I want to see where I am right what I want to know I made a separate app for this sorry guys one sec this is some of these features that went down like a storm and it first committee came out yeah it was heavily requested by a lot of people so the classic example would be a city guide what you'd love to see a city guide is when you go to an item not just not a map but when you actually visit that item you want to go like how far is this away from me and when I click on it like take me to Google Maps that's like a really standard feature and this is calculating the distance obviously I'm in the UK and this is in San Francisco so it's a little while away but this is coming from the distance column right which is really powerful so if we go over to the app here why can I not see it is it did I miss it distant sorry thank you did so if we do here and this is obviously specific to each user so this is only going to be relevant to me right and you can change it from kilometers to miles current location change the separator and yeah we we restrict it because it's obviously like intensive to do these computations for for each user so it's kind of you get a certain amount if you're free and then it's on Pro but it's a really useful thing that we've added recently and there's also the the location component as well so if I say use my current location that will log my current location to the sheet so they're very related those two things but one is it is a real-time thing that updates so if I move the distance column we'll work out how far it is all the time whereas right now the component you're saying here will just log it once so the second one the component could be much more useful in forms for example so yeah that's a kind of sorry one good question wrong personal question for you dive into every else's re distance is when he plans to do routing inside of a glide app what oh you mean like can I go from here to here and give me the route yeah so now you've got a you've got obviously a really good map and pin locations it'd be good to just like yeah great point yeah for sure we've been asked for that for sure no immediate immediate plans but like as I'm sure with all the tools that you guys use you know you're always using it you're like oh man I wish I had this you know I wish it had this so like all of these know care tools are inundated with like great feature requests and we love it and one of the things that's really important to us is that we're listening to our users and knowing like what's most important to you guys and the thing that we use for that is surprise surprise a glide app and if you go to features staging got glide after i/o I'm gonna put it in here fuel you can upvote and add your own feature requests so for example if I go here I'm gonna search for the most requested feature which is push notifications and deep links and then App Store as well and you can go onto these and we're all like our community of commenting about it and you can bookmark it and then you can make suggestions and you can also see things that we've shipped recently as well so that's a great resource to and we listen to that usually amazing nice some awesome features especially if you haven't used like the app and well there's this just feature pushed all the time so yeah it's great that you can as like a maker if you've got several apps and say you're publishing it for a client and you you have like a deal to maintain those apps or if you're publishing it for yourself then regularly you can go back and just keep updating your app and release new features yourself all the time yeah so that's why I love because you guys ship stuff really fast yeah and and for those of you who are thinking about like you know I might not want to make template but like this is a really useful feature like maybe you could use it in work we have glide organizations which is basically the Google Docs or you know you could say it's like the Google Docs for making apps right where you can collaborate on apps with your employees and everyone in your company can use apps and make them for free until they start getting used and then when they used we charge per user so that's a really useful one to think about yeah amazing should we through some of these questions we've got left in the queue Q&A yeah so the first plan Boyd's can create an internal community in app so follow my friends they follow me the employer actually approach mmm yeah so you mean like I'm interested what the specific features are about that so we have chat and comments but like what are the features of a community that I guess I'd be just like building is some sort of a newsfeed where you can follow follow people and you can bring what they're posting into your feed I guess yeah so for sure like the community in that we want to make it way more interactive like we experience and the comments experience but I'd need to think a little bit more about the details of what's not possible right now to do because the beauty of Glide is that there are a lot of things that you can kind of hesitate you to use the word but hack together that we might not have thought of like we quite often see people doing things and were like oh interesting we never knew that you could do that functionality with what we've provided but I agree that I would say right now there's probably a few things so yeah I'd be interested to know what it is that's missing here at the moment the template was curious about the lot to user ID column on the sheet ah yes good question so when you use features like favorites and other things like that glide needs to know where that row is in your sheet and I can't show this now but I'll try to explain it so say I went into an app and I favorited the top item or maybe I favorited the second item or something like that and then the person who made that app reordered the rows in their sheets right without using Eydie columns what would happen the next day when I went in that app that the favorite would be totally wrong I would I would have favorited the different item and I'd be like what doesn't make sense and this would extend to comments and things like that and you'd see your comments on something that you didn't comment on because go I can't the way that sheets is structured easily work out what's happened in that way but when you add a row ID and the row ID column gives this kind of random long string of data a unique ID we can track it so that that's what that's for it's a really useful way of adding so these apps work on Android can you sell your app on the Play Store can you so this is kind of what we are said further at Mia not not yet but that's something that we wanted to so the moment that Glide apps work on the on the web basically so you can add them to your homescreen like you had a website to your home screen and that makes it a whole lot easier to share and update than app stores so it's kind of like a different type of app that's usually how we describe it Oscar can you into a globe within a web flow site I think you'd be on about an embed I mean if you can embed apps yeah not embeds no that's something we've heard before like kind of really interesting topic for sure the the CMS side of web flow can be I believe connected through you're the one to answer this time to be honest what do you think like position yeah you can sync your web flows CMS with the Google sheet and then show the same like info in your website and you're glad that that's I think that's the thing to reminder Brunner's well like we have as a peer integration but people think that that gives you everything that doesn't actually give you much like zapier are as a peer integration is just about sending data to zapier like in a in a like a quick ping right like it bear in mind your Google sheet which is like the most used integration in zapier because hasn't like that's your app right so anything that happens you can pull in data to Google sheets and just make an amazing app through that's powered by zapier so that's definitely wondering if you're a good integration to practice with and make some cool Glatz with I actually demoed this no code comp last year where I use Phantom Buster with a Google sheet to create a dynamic glider which contained a list of all of your products on up voters so you would watch for every New York vote in front of ton and then scrape down info and then upload into a Google sheet and then you'd see the latest that those new applied up because that Google sheet was self updating so if you can use an integration to keep pushing data into a Google sheet you're glad would just automatically update itself yeah someone saying can you provide the link to that I think yeah sure I'll find it for you afterwards have the presentations somewhere prashant can you email me at Tom and make pad doc oh and I'll email you hold it and you have a public road map from Grant a public road map about what we're working on yeah so we would like to do that for sure as you can understand like things change so we don't want to like over-promised something we would like to do that at some point the best place to go to kind of get in a sense of that is the link to the feature request app that I showed you there because like you know something's really popular on there it's pretty likely we're going to do it we can't give a timeframe on those things but I wish we could but yeah okay so should you build out our tables on Google sheet cider on the glide side sorry you broke up there Tom say that one more time so should we build out our tables on Google sheet side or the glide side basic column it's not the fancy ones yeah so we would really like it's at the moment that the data editor is getting better all the time like we're working on it all the time and I would personally say right now it's easier to work in Google sheets if you're just inputting data for sure but we're aware that this kind of back-and-forth between Google sheets to do certain things like I find myself working on Google sheets to do saying then go to glide to do saying you know is could be improved so yeah I would say if you're inputting data Google sheets and then wrangling that data with the computer columns guide Watson how many different access levels can we have can we rename them from say premium to anything else yes for sure so I just showed premium and free but you could have like as many as you want that's what I probably decline yes just a column in your sheet it's a property of that you define and you can have as many columns or so as many properties but you can have as many different types so if you had like a thousand different users of your app you could have like 50 different types of users or 50 different teams or 100 different teams and then it would take longer to design the app for those different yeah one layer I'd like to think about it is just imagine you're using it for locations you had like a list of hundreds of locations it's just the same you can have hundreds of permissions and then just have a conditional to say only show it if this condition is now yeah okay user profiles we have a sheet with emails of listing owners how do we create user profiles for them without the need for them to unboard where is that question let me try and read that off photography sheet with emails of listing owners how do we create user profiles for them without the need for them to unboard themselves a great point yeah for sure so explain it in words rather than showing you so I have a there's a tutorial it's kind of old now and again it was made before user profiles exists that existed but it's the build Instagram with Glide video that we have and in that video what I essentially do and you can watch that is you you create a page screen which is a detail screen which is looking at the user profiles sheet and then you filter that screen to only show the row that is the current user there's probably really abstract to explain in words or you use row owners and so then the user will only see their row so if Tom logs in you'll see a detail screen with his row if I log in I'll see it and then you can surface those properties and entry components like text entry or number entry and then they can write their bio you can write their name whatever and that's pretty powerful as well because if for example like if I surfaced the premium or free property to Tom Tom wouldn't have to buy the app to make Pro you could just like change his property and then unlock all this content so that's another way of thinking about building your apps is letting your users like choose what kind of app they want to have you know that quick look but contemporaries be used odd and just one app by the purchaser multiple times or can you once you purchase it can you clone it I guess yes yes I believe you can yeah when you yeah once you've once you've done it yeah you can okay the welcome page looks is the way you can show an aggregated ranking it sees X for example you give three stars and Tom gives one star can you show community gives two stars so you're talking about essentially the the roll up column which we have which does a number of different computations like average max min things like that but doing that over a user specific column so currently the roll up column only works over normal columns and not computed columns like or use of specific columns but we are that's that's very much on our list because at the moment you can't get the average rating for an item but we we need to do that come can we change the heart icon along with the text I think this is relation to the favorite function yes no not yet but I it's a great it's a great point so put it in the feature request app if it's not ready there any plans to add some solution to how to manage product variations for the e-commerce part oh I see I'm afraid that's so natively we haven't worked on that but I think is possible I think I did it the other day but I now can't remember how I did it yeah that's an example where to ask in the community I think I've had to get creative I think yeah it's it's possible but again it's not like we've built out okay I mean is there a download option that can be inserted for users I'm not sure what that's in relation to exactly oh for a file or something like you want to download a PDF no there isn't a download component that you can open a PDF and then like I believe the share screen or something like that on iOS for sure you can then like had it or whatever but no not not native when can we link back to the home screen I'm sure you can yes you mean with the link to screen action not yet no I don't think it would be a unique version of that's Creedence so but yeah it's that's another thing that we know we should do at some point so you can have nested structure can you open a web page we're gonna glide up to keep the user in the app yes for sure so so previously it opens in if you're on iOS it opens in that kind of standard Safari that opens up yeah we've just added this component called web I think maybe we're still working on it there's something webview or web action or something like that that you'll find the problem with that is that a lot of websites stop themselves being embedded and currently the way that we've built that is as far as I understand we've embedded you know new tricky it's good enough but do not want any tab but one only menu display is it possible so no tabs on the bottom just yeah yeah so you just need to create a like a screen with just one tab so then we'll just get rid of the guide will just remove the tabs at the bottom if you have one tab you can still have tabs in the app menu but like the tabs at the bottom will disappear and you get that nice full screen I think it was in the app that I showed the inside is the and then you just have images or buttons with the linked screen action and as menus yeah that's cool love that feel how long it take you to make the feature request app from scratch oh yeah you want to build that from scratch right yeah so that's on my long list for sure to do a long tutorial on because that's just we were using a premium service that was like a hundred bucks a month to do feature requests and then Mark and I were like you know come on like we must because to do this now and then he put something together that I yeah so now we can do and we can keep expanding it so it's great I will do at some point that idea what sorry so if you're good with Glide how long would it take you to though there if you just to build it if like full-time working on it like if I'd already built it yeah like maximum yeah that's probably cool I'm glad they're plans to reduce live-streaming engagement features yeah great great one so you can already in bed I mean it's not amazing that you can embed like YouTube and I believe twitch and other things as well in the video component but I'm not that I'm not super familiar with that world so I'm not like aware of all the different functionality provides but if there are specifics you can ask those and I'll answer but yeah that's a great as a great idea we'd love to I want to use the profiles but I haven't figured out how to connect other people's profiles even touched on this previously so just by catching what other people haven't figured out how to connect other people's profiles like friends list oh yeah so I mean favorite component could just do that like you could you could have a your profile right and then you belong like say it's the employee directory you could have your profile where you edit information about it in the way that I described and then you can have a list of people and then you just add the favorite component to one of those people and then all of them will have the favorite component and then you just change the favorite component to be add to friends list and you can also do stuff you don't have to use the favorite component you could use the switch component and just not have that heart and you could just have a switch that says add to friends list and then you can filter another area based on your user specific yes or boolean this - cool is event booking for fitness classes possible yes yeah yeah this I've heard a lot of people doing booking stuff Robert Patito one of our experts has done I mean just go to the template store I think the stuff in there I just have a quick look booking salons BBQing looking toward limit rentals yeah I think I think it's possible like our calendar component could do with an upgrade for sure our calendar layout but yeah there's bookings are possible nice cool I think we've done a pretty good job at whizzing through all of those questions hopefully that was helpful we've gone an hour and 15 minutes plus a little intro that we did before with talking about nonsense so that's enough of your time everybody hope that was enjoyable and I'll see a ton of resources both on the glide site Jack there's some killer tutorials on YouTube probably the best you'll find anywhere so treat yourselves to them and don't compare them to mine because that'd be wrong with you and then if I'm always says this and I always tell him that I do one company and Tom does 300 companies so it's kind of okay its quality in quantity so yeah if you only go I suggest that glide is a great place to start we use or we teach you how to use glide as well in our basics of no code do can we just see if I can share my screen quickly and so on make vodka we do a series of boot camps and in our learn the basics if no code boot camp we feature glide heavily and we recommend it as like a really good place for people to start so if you haven't signed up make by yourself on the mailing list and then she look at some of our freed cereals and then obviously we're unsure up speed and fancy diving in further and there's the pro membership there for you as well but yeah highly recommend glide and then once you want to dive into some other apps then we've got some other stuff on make pad Garrison's just said about discount code doesn't work for making our deals you can contact them support a glide apps calm and get that figured out or make better than know where the issue is lying that but yeah also though awesome great thank you so much guys really really enjoyable session Jack thank you very much for your time I really appreciate you coming on to speak with us all and give you a masterclass as always in glide events and things myself so go update your apps now now and guys if you build anything make sure you reach out to obviously the community on glide make pad or email us you need any help I'm always available the time and make bad Co we have a circle community that you could join as well and yeah hopefully would be doing some more these webinars soon so look out for him anything you want to add Jack so that's it thanks guys and yeah just reach out to us if you want to join in the community at glide apps community glide apps common would love to see that and if you have questions just tag me I think I'm just Jack Vaughn at Jack wall and you can find me on there somewhere he's everyone we find the nice everyone enjoy the rest of your week stay safe and speech awesome see ya bye

Channel: Makerpad

Views: 5,891

Keywords: Makerpad, Apps without code, mobile apps without code, Glide Apps, Glide, Building Mobile Apps, Build Mobile Apps

Id: XQFwnuqPf8A

Length: 74min 11sec (4451 seconds)

Published: Thu Jun 25 2020