Skip to main content

Creating with Glide - The App Creator in Google Sheets


 From nappy.co



I stan the Google office suite. Specifically Docs - I have been using the SaaS for 10 years to write and rewrite resumes and save internet comments.

In 2020, I came across Glide - Where I could make an app using Google Sheets.



Sheets is the Excel equivalent. While used less, I have enough data within it for testing. I imported an old spreadsheet of movies watched in 2017. I now have a Letterboxd, so this is a little obsolete.

Fun fact: This is actually not the first iteration of the spreadsheet, but the third. The 2015 and 2016 pages use a totally different organization scheme. 2017 is the first one that's reasonably organized.



There are a variety of ways to actually organize the app based upon the information given: I'm particularly fond of the detailed view:



Props to it also including my 'rewatched' column!
It did mark a few of the films incorrectly.



There are two columns in the spreadsheet I didn't often use - "Liveblog Link (if applicable)" and "Anything else?" for other notes about the experience. If they were filled in, they were transferred to this app.




If not, they weren't.



That should be "THOUSAND".


The software did not load the spreadsheet in its entirety, stopping at around film #82 ("Batman vs. Two-Face").

If you're thinking "Nice, but I can probably use it for something else...", not to worry, there are many templates available.

One thing I think is extremely cool is how the app works while you're creating it. I wasn't expecting to hit the fake phone number and Windows 10 go "Alright, how do you wanna call them?"






I revisited this in March of 2020 and found it a little harder to understand. There are instructions - " Grab Tabs Here to Show them In the Left Menu " - That aren't particularly intuitive.

Now, I am a technical person, as well as a storyteller. I know when to consider that my browser extensions may be ruining the experience, and to disable when necessary. Even after doing so, nothing seemed to work. Do I not have tabs? It looks like I have tabs.




I think it's because I do not have the hamburger menu set up on the left (3-horizonal lines). If you hover over the + on the left in the header bar that says "screen", "You can only add components in details view".

I have no idea how to get to that. The "conference" preset shows that the screen aspects are just that - Things on the screen you can rearrange. Think layers in Photoshop. 

It's a good concept, but I feel the minimalism may be more of a hindrance to new (or returning after a year) users. There's a surprisingly active community you can visit for help and design tips.


Comments

Popular posts from this blog

Connecting IoT Devices to a Registration Server (Packet Tracer, Cisco)

In Packet Tracer, a demo software made by Cisco Systems. It certainly has changed a lot since 2016. It's almost an Olympic feat to even get started with it now, but it does look snazzy. This is for the new CCNA, that integrates, among other things, IoT and Automation, which I've worked on here before. Instructions here . I don't know if this is an aspect of "Let's make sure people are paying attention and not simply following blindly", or an oversight - The instructions indicate a Meraki Server, when a regular one is the working option here. I have to enable the IoT service on this server. Also, we assign the server an IPv4 address from a DHCP pool instead of giving it a static one. For something that handles our IoT business, perhaps that's safer; Getting a new IPv4 address every week or so is a minimal step against an intruder, but it is a step. There are no devices associated with this new server; In an earlier lab (not shown), I attached them to 'H

Securing Terraform and You Part 1 -- rego, Tfsec, and Terrascan

9/20: The open source version of Terraform is now  OpenTofu     Sometimes, I write articles even when things don't work. It's about showing a learning process.  Using IaC means consistency, and one thing you don't want to do is have 5 open S3 buckets on AWS that anyone on the internet can reach.  That's where tools such as Terrascan and Tfsec come in, where we can make our own policies and rules to be checked against our code before we init.  As this was contract work, I can't show you the exact code used, but I can tell you that this blog post by Cesar Rodriguez of Cloud Security Musings was quite helpful, as well as this one by Chris Ayers . The issue is using Rego; I found a cool VS Code Extension; Terrascan Rego Editor , as well as several courses on Styra Academy; Policy Authoring and Policy Essentials . The big issue was figuring out how to tell Terrascan to follow a certain policy; I made it, put it in a directory, and ran the program while in that directory

Building, Breaking, and Building A CRM with Retool

 I like no- or low-code solutions to things. I've often wanted to simply push a button or move some GUI around and have the code implement itself.  I've thought about building something that's like a customer relationship management (CRM) system for keeping up with my network better than my little spreadsheet where I click links and then go like something. The general idea in this CRM Development is:  To have a GUI to add people to a NRM (Network Relationship Management).       Attach it to a database (MySQL is what I went with eventually using Amazon Relational Database service, but you can use PostGRES, and probably others).     Make sure components are connected to each other in the retool interface. This video is a good start. Watching the tutorial video, heard some SQL commands and went 'Oh no 😳" before going "Wait I know basic SQL", which is good, because you'll see.  When you get set up, there's a plethora of resources you can use -- Incl