Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?
SaaS
What do you need help with?
Hello,
I am brand new to Baserow, and I am struggling with a simple rollup calculation from fields in a different table.
I have seen that in Baserow, to perform operations with fields in other tables, you must first create a link field to the other table and then reference it. However, additionally, I have to manually select rows in the link field for the formula to calculate, which is inefficient. I want the formula to automatically include all values from the other table as new ones are added, without manual intervention. How can I achieve this?
I guess that it should be a different solution. Can anyone help me with this?
Thanks in advance
Hey @miguel.berzosa, welcome to the Baserow community! 
Records must be linked manually since you need to define the relationships—this cannot be automated: Link to table field.
But I’m not sure this is exactly what you mean here. Could you please elaborate on this?
Hi Olga,
Thanks for your prompt reply!
My issue here is the following:
I want to have an external application which is creating new rows with new data. As the new data is written in the table, I want to have another table that is making calculations in order to provide statistics. For exaple: In the firs table I will be receving the result of an external operation that can have to status: Success or Error. I want to have a counter in the other table that will provide me with the statistics on the number of success operations and the number of error operations.
I managed to create such counter using a Formula Filed in the second table that is pointing to the link field. However, in order to get the most updated calculation I have to manually select again the new rows recently created by the external application.
How can I solve this situation?
I now understand your case. I’m not sure how to automate it, but we can check with @frederikdc and @cwinhall for their ideas. 