Help

Help building a table

758 2
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?

2 Replies 2
frank_johnson
5 - Automation Enthusiast
5 - Automation Enthusiast

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

Trish_c
5 - Automation Enthusiast
5 - Automation Enthusiast

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