Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Help building a table

315 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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