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

Relation to database with only 1 row?

Hi!

I'm a new user and have a database that contains only 1 row. It contains the offset for the user's Time Zone from GMT. In my case, it is (-5).

I have another database where each record needs to get that offset number. I struggled for a few hours yesterday for something that I would find simple in another software. Can anyone point me in the right direction on how the Relation/Rollup should be configured to get that single value from the other database?

Thank you!

Calculation Database Here.

1 Answer

0vote

polle Points79930

You have to relate all the rows to pull all the information from the other databases.

If you relate only one item, then only one item will show the rollup info.

0vote

Willow commented

Can you please explain what you mean by "relate all the rows"?

I'm a new Notion user. The table where I need the relation has almost 500 rows. Do I need to manually relate these records to the single record?

Thanks!

0vote

polle commented

Sure.

If you have 10 items in your database A and 10 items in your database B, after you create the relation, you have to select and actual item in that relation column, but not just the first one, you need to relate all of them as needed to display the information in the rollup.

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