Notion Answers

Help between Notion users


Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution

Question

1vote

database structure advice

I am trying to design a procurement system. I have one main database containing the major items, eg computers, office chairs, etc. Within each of these items is a sub-database containing all the options and quotations we receive, eg under computers you would have supplier 1 with its price, supplier 2 with its price, and so on. On the main database, I want to roll up data from the sub-database such as average price, minimum, maximum, etc.

When I tried to do this with relations, the main database tend to add a column for each relation. So for example, for computer items there will be a column relating to the sub-database within the computer page, then another column for office chairs. I find this unwieldy.

Is there a better way to do this?

1 Answer

0vote

polle Points79460

That is the correct way to do it.

Relate all the Notion databases you need, then Rollup all the information needed from those databases and at the end just hide the columns you don't need to have visible all the time.

Please log in or register to answer this question.

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!

Connect