Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 12, 2020 06:54 AM
I want to build a database for a specific purpose and am struggling to think through the theory behind it.
I need to record names and contact information for a list of people. Each person will also be assigned to a group, with its own information. Each person will also have a record of activities completed for each month. Later, I would then like to visualize trends and averages for activities completed for a given group or individual.
Can anyone tell me hoe they might layout their database to achieve these results?
Apr 13, 2020 02:52 AM
Hi @Ben_Moodie,
Welcome to Airtable Community !
To build a Base, you need first to think what is the outcome you are looking for. For example, it seems you need the following Tables:
You can then use the Chart Block on the Activities table, to show the required trends and Group by either Group or Person.
This is just an idea and you can find so much more to do once you start.
BR,
Mo
Apr 13, 2020 06:39 AM
Thanks @Mohamed_Swellam This is definitely helpful, and I think i understand the concept behind it. As I imagine it then, the one table (ACTIVITY) will be huge and almost illegible, but using filters and views will make it manageable I assume. Is that what you’re thinking?
Apr 13, 2020 06:57 AM
Yes this is what i had in mind @Ben_Moodie
Apr 13, 2020 02:09 PM
@Mohamed_Swellam has already given you a good map. I just want to add some comments in response to the question I quoted above.
.
.
Good luck.
William