Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Best Practice : When should I consider add another table within one base?

Topic Labels: Base design
150 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi there
I just start my first airtable base and currently I have multiple survey forms in one table. Some of the questions share the same column but some of them are not. However, when I look in a grid view, for those columns that are not shared in multiple forms will remain blank, making the whole table looks not organize, because some of the questions in one survey are not relevant to the questions in another. In this case, would you recommend me to add another table ? I’m not familiar with the “database” concept so, I’m wondering what would be the best practice if I would like to analyze my customer profile later. Don’t want to mess it up :stuck_out_tongue:
Thank you
Lee

1 Reply 1

Welcome to the community, @Lys_Lee!

I would keep one table, but create multiple different “views” — one view for each form. Each view would be filtered to only show you the fields that you want to see for that form.

For a deep dive on when to create new tables & how to manage views in your base, you may want to check out my free Airtable training course: