Add rows to this table using values from another tables

[Uribe]

Hello experts!

I have three source tables and one destination table:

DESTINATION TABLE:

Date	Name	Future Task	Price Checked	Task Assigned	Task Discarded	Key
03/30/24	Peter	2	1	2	1	123qwe2
03/29/24	Mary	1	1		1	654asd

SOURCE TABLES:

Future Tasks:

Date	Name	Future Task	Key
03/30/24	Peter	Buy	122wer
03/30/24	Peter	Sell	poi123
03/29/24	Mary	Buy	0978we

Prices:

Date	Name	Price	Key
03/30/24	Peter	50.25	qwe987
03/29/24	Mary	30.21	klmlkm654

Tasks Assigned and Discarded:

Date	Name	Task Assigned or Discarded	Key
03/30/24	Peter	Assigned	09q8we
03/30/24	Peter	Assigned	90lkasd
03/30/24	Peter	Discarded	cbn3556
03/29/24	Mary	Discarded	qweqw123
03/29/24	Peter	Discarded	qweqw124

I need the destination table to be filled everyday automatically with counts from the source tables per person per date.

I tried with actions on the source tables, but I it will add several rows for the same person on the destination table.

I thought about setting app formulas on the destination table, but can't figure out how the app will add one row per person per date with the counts I need.

Hope you could point me in the right direction.

Thanks in advance!