i have 3 tables.
Table 1: Expenses(fields: Date, Details, Invoice PDF, Amount, Category)
Table 2: Income(fields: Date, Details, Amount)
Table 3: Total(fields: Date, Details, Expense, Income, Total)
What i need is:
when i’m making a new entry on Table 1, fields Date, Details, Expense from Table 3 to auto-filled on a new entry. If i change something on that entry on table 1 (on that row) to be changed as well on Table 3.
when i’m making a new entry on Table 2, fields Date, Details, Income from Table 3 to auto-filled on a new entry. If i change something on that entry on table 2 (on that row) to be changed as well on Table 3.
and in the midtime in every row on field Total the expenses/income to adding/subtract accordingly.
Its possible to be done with automations?
