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

How do i relate columns (or values) of other tables?

Topic Labels: Formulas
329 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello guys!
I need help on this:
I have several tables (5) the main one (PAIN EVENTS) and another 2 of them are MEDICATION AND RESCUE MEDICATION.
In the main one I list the other two in columns.
In the medication tables, in both, I have added a rollup column that makes me the sum of the total pills that you have entered …

QUESTION: I would like to have another TABLE that will add both columns of the MEDICATION table AND the RESCUE MEDICATION table. (From the rollup of each one of them …)
But it tells me … “you need a link field to create a rollup”
AND I’M ALREADY LOST.
I have also tried in formulas:

in formula … SUM () how do I enter the values ​​that the rollup columns of other tables give me? In parentheses. Can be done?

Anyway that’s my problem now.

Thanks.
AIRTABLE_1 AIRTABLE_2 AIRTABLE_3 AIRTABLE_4 AIRTABLE_5

0 Replies 0