Dear Community:
I will appreciate your help with the next issue.
I have two tables: Table 1 and Table 2. Table 2 is marked as “is a part of” Table 1.
Table 1 has a field that is calculated by adding records from the table table 2. I am using an app formula to calculate this sum. I would not want to use a spreadsheet formula for performance reason because there are tens of thousands of records. There is some way to update table 1 when a change is made in table 2 and the table 1 calculate the correct sum after the edit.
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
18 |