Should I Use One or Multiple Tables? No Code Best Practices

[@reallyefficient]

Ooof... this video should be a prerequisite to anyone trying to build a database...This 10 min will save HOURS of headaches later :D Great content as usual Dan!

[@davezovak3121]

Great overview! Thanks

[@bookersch]

Wished I had watched this video before I divided 1 table into 4 tables. I wanted 4 tables, each with some unique fields. I realized the mistake I had made when I tried to update 2 Single Select fields and 1 Mulitple Select field that were common to all 4 tables. To undo my mistake, I had to add extra fields to each of the 4 tables so that they all had the same fields. Then, I imported the records in CSV format from each of the 4 tables into a new single table. Once the new table had all the records, I updated 2 Single Select fields and 1 Mulitple Select field. I created 4 different views with some fields hidden to mimic the 4 discarded tables. Fortunately, Smartsuite made it easy to undo my mistake.

[@AnggitNuraulia]

Thank you sir