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

Making KPI Dashboards with PowerBI

 While this is the free tier, I cannot share or collaborate with others, nor can I publish content to other people's workspaces, but they will not stop me from screenshooting and recording these self-taught adventures,so! I'm doing this because I idly searched "Mattel careers" and "Information Technology", and seeing a bulletpoint saying the following: Analytical and reporting skills such as creating dashboards and establishing KPIs such as experience with PowerBI, Cognos, Tableau, and Google Data Lake/AWS is preferred And thought "Well, I've used Tableau, and I've heard about PowerBI,  even if its in-demandness is questionable , so how similar is it? And can I write about it?"  First, PowerBI (PIB) does have a downloadable, local version, but apparently Windows-only. I could download the .exe but I couldn't run it / drag it to applications on my MacBook.  Not a problem, we'll use the online SaaS version, and a dataset found here, ...

Perplexity AI: The App, For The Everyday Person

   Perplexity AI, according to BuiltIn , is an AI-powered search engine - and it's now valued at 1 8$Billion dollars, with a B. I had it on my phone for research testing - something I do between contracts for money - and simply kept it all this time. With it making a resurgence, I can show you if it's viable for every day use cases.  I did not use it to generate "art" or writing.  Screen Reading and Photo Identification. I have used Perplexity to read Chinese characters on my screen, asking to point out the radicals, tone, and meaning of unfamiliar characters. There are minor differences between what Perplexity answers with and what Duolingo and DuChinese deal with, but I know enough Chinese* to figure out the difference - though a recent study calls the accuracy into question. For instance, below I've asked it what the radical is in  æ°´ (shui, water)      [alt: The character in your image is  æ°´ , which is the Chinese character for "wate...

A 2-week Trial of T-Mobile Home Internet

     The Xfinity app showed usage of the past 3 months: We used less than 40% each month, for about $80 USD a month.   No thanks! That cuts into the movie budget! Before we save some money (about $15/mo), let's test how T-Mobile Internet unlimited data works for 2 weeks.    There are 15 devices for this test; Smart TVs: 4 Laptops: 4 Printer: 1 Smart Home Speakers: 3 Game Consoles: 1 Phones: 1 (There are other phones in the home but they stick with data) Other: 1 Total : 15  I made tables for 3 entries a day across 3 days to test the Xfinity service we have. Here's one;   Xfinity is pretty speedy - Download times are between 227 - 236 Mbps, Latency between 24.5 - 25.5, Jitter between 5 - 6.68, and 0 packet loss.  Let's quickly define the terms in the table;    Date/Time - The date and time of the data gathered. Download (Mpbs) - How fast your network gets data. Upload (Mbps) - How fast your network uploads data. Latency ...