Help

Need some help to build a table and function as i need to

Topic Labels: Automations
773 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Nik_N
4 - Data Explorer
4 - Data Explorer

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?

0 Replies 0