Same as @Darren_Murphy.
I may add: start with drawing your “tables scheme” on the paper to clearly identify your needs
@Darren_Murphy & @AyS_0908
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”
If it’s OK for you?
It will be updated little by little.
The English Int’l prototype will come later in 2022.
This one is less important now that we can add sheets after the fact.
Darren’s list could be pinned or highlighted somewhere.
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
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
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
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”.