Extracting values from one table and use in another table

I have an employees table where I input the daily value for each, among other values…
how can I get the monthly value for each and use it in another table, to make calculations?

Hello @ri6as, you can add a formula field to calculate the monthly value for each employee and then look up these values in another table using a link to table field.

Here’s an example:
Table 1:

Table 2:

Is this what you’re trying to achieve?

not exactly, in your example we have the values inserted by columns, in my case I have a line for each day/employee, so, i’ll have 30 lines for each employee (12 employees) - these are the values I want as total to use in other table/calculations!
Can this be done?

Hey @ri6as, that won’t be possible because the formula field works on a row level.

With the footer aggregations that work on a field level, you can perform simple calculations like average, sum, etc. but it’s not a good solution for your case because you can’t reference these values in another table.

If you restructure your data a bit, you could use the formula field, which will do exactly what you need.

hi,
can you point me in the right direction or show an example?
thanks

Hey @ri6as, we have a great article with useful tips on data modeling. Check it out: How to model your Baserow data.

To make the formula field work for you, consider following this structure:

But I don’t know the whole logic behind the work you do, it’s hard to point you on the right direction.

hope I’m not pushing you too much…

I have a table SALARY:
Employee_name / Date /Job / hours_worked / Hour_rate / Daily_Value
AA / c / A / 8 / 15 / 120€
BB / c / B / 8 / 14 / 112€

would like to create a table:
JOBS:
Job / Overall_Value
A / XXXX
B / YYYY

XXXX will be the aggregate value of all Employees on the Job A
YYYY will be the aggregate value of all Employees on the Job B

Would be good to have this value any time I’d need…