Hello Guys
Please Help !!!
Let me explain my project a bit more in detail:
In my project, I am trying to set up a cash management application in contact with other departments.
In the checkout application, I have 2 main forms, each of which has its own table.
--The data entry table
--the data summary table
Also, in parallel, I am developing a canvas application on power apps
how I see things:
On a daily basis, the cashier will enter incoming and outgoing transactions in a form that is connected to the data entry table .
The summary table, on the other hand, contains only cumulated and calculated data which depend on the data of the data entry table
I have already created the 2 tables
I linked the 2 tables
I created the 2 forms on power apps
For the data entry table, here are the columns: Customer's surname and first names, type of customer, type of transaction (Cash out, Cash in), amount, commission generated, observation
For the summary table, I have several columns such as: Total cash out initial balance, total cash in, total commission, final balance
To create the colomn "total cash out" in the summary table, I configured the condition:
{ if transaction in the data entry table is equal to Cash out, Then (aggregate): SUM the amount}
So I would like the summary table to contain only 1 single line since these are only cumulative or calculated values. The values ​​will change depending on the selected date
My difficulty:
When I do a test; that's to say :
In my power apps application, when I enter data in the form, the record is created in the data entry table (dataverse), But no record is created in the summary table
I was thinking that since the tables are linked and that the validation of the data entry form contains data related to the summary table, then this should automatically create a record in the summary table. But this is not the case. Do you have any idea how to proceed please?
Looking forward to reading you very soon🤝
