Help building a table

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?

Hi,
Greetings!

I can assist you.

Please reach to me at frank(at)cisinlabs(dot)com Or at Skype: - cis.am3

Awaiting your response.

Regards
Frank

Hello @Nik_N
I would be glad to assist you.
Sent you PM with further details.
Thanks!
Trish

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.