Your Best Practices, Dos & Don'ts for Newbies, pls? Thks 🙂

Hi :cherry_blossom:all
I’m defending my student project thursday 25 afternoon, featuring one last time my Glide prototype and working on the next & last project already, so, sorry if I’m not reactive to your answers, I do read them a little.

I’d like next to share with my app a short list of Best Practices with Glide.
Apart from joining this Community, of course :blush:
Like :

  • The Dos & Don’ts you’d like to avoid to newbies especially. :triangular_flag_on_post:
  • What you wish so told you before :woman_facepalming:
  • The limits of the free plan & its implications
  • Anything else you can think of
  • Easy plugins or third-party tools

Target readers: newbies who may be less “technical” than myself :grin:
Thks :cherry_blossom:& catching up later, after my exam.

Here are a few things off the top of my head:

  • RTFM :wink:
  • Use Column Grouping, it will make your life easier.
  • Devise your own consistent column naming scheme, and stick with it.
  • Find All Uses is your new best friend.
  • Unless you’re absolutely certain that you’ll never need it, always start a new app with a Google Spreadsheet.
  • Learn about Glide Computed Columns. Once you understand how to effectively use them you can start unleashing the true power of Glide.
  • Avoid Spreadsheet formulas like the plague. Let go of them, they are holding you back. Except in a very few cases, you don’t need them any more. If you think your formulas are way too complex and can’t possibly be done in Glide, refer to previous point :arrow_up:
  • Always use Custom Actions
  • Don’t be afraid to ask for help. Everybody has been where you are at some point.
  • Don’t be afraid to jump in and answer questions. Helping others find solutions to their problems is a great way to learn. You won’t always get the right answer, but who cares?
  • Be nice to others.
  • RTFM :wink:

I’m sure I could think of a lot more, but that will do for now :slight_smile:

18 Likes

Same as @Darren_Murphy.

I may add: start with drawing your “tables scheme” on the paper to clearly identify your needs

  • tabs
  • fields per tabs
3 Likes

@Darren_Murphy & @AyS_0908
Thks, guys :cherry_blossom:
I’ll let you know when I’ll share those tips in a kinda list (once translated in French) in my prototype next month, with a mention like “powered by Glide’s Int’l Community Experts” :wink:
If it’s OK for you?
It will be updated little by little.
The English Int’l prototype will come later in 2022.

1 Like

This one is less important now that we can add sheets after the fact.

6 Likes

Such a good list.

1 Like

Darren’s list could be pinned or highlighted somewhere.

Hola,
My basic and useful advice is structure, sort and relate your tables on a paper on your desktop before starting your development.

It’s is called Database Normalization when you work with DBMS formally. A better explanation about this concept can be read here: https://www.studytonight.com/dbms/database-normalization.php

5 Likes

I heard @Mark say something very profound and it stuck with me.

It’s always best to get something working first and then later you can optimize. Shooting for the best version on your first attempt can lead to troubles… something like that :wink:

I see this one a lot:
A form will add a new row to your sheet. That’s it’s purpose, to add a new row. Do not use an add row action on submit in your form. This will cause two rows to be added to your sheet, not one.

For when space bar won’t cut it

Great for working with images. Easily create transparent images

5 Likes

That’s the very principle of an MVP in a Lean Prototype Cycle: you build as quickly as possible the minimum features that can bring the highest value to the final target (users, customers) to get their feedbacks and iterate to test, learn, build again until they’re happy and you’ve found a fit together.
But you still need to anticipate enough for maintenance, quality & of course scope & scaling potentials. So as not to lose the time later you first had the illusion to have spared at the beginning.
Preparation is often better than “improvisation”. Even if the more you know, the smarter & knowledgeable you “improvise”.

3 Likes