Hi everyone, could you help me? I hav an app to control the budget and expenses. I want to build a dashboard which will evaluate if the budget has been exceeded. I have some tables…
-Expense Class (Home, Services, Food, Car, etc.). An expense class has many Expense category
-Expense Category (Electricity, Repair, Gas, Medical care, etc.)
-Budget (How much money I plan spend in each Class/Category for any period “Month / Year”)
-Budget evaluation ( each row is a “moment” in time when I check id the budget has been exceeded for the selected period)
-Detailed budget evaluation. My problem is with this step. This table will show the expenses and budget for each “Class/Category” for a selected period. I want automatically create a row for each “Class/Category” every time that a row for Budget evaluation (previous table) is created.
What do you recommend?
You haven’t detailed how your process is implemented. Assuming that a user manually adds the Budget Evaluation row, you can add an action to the Form Save behavior - i.e. when the row is saved an action (or set of actions) is executed.
In this case you can attach an action of the type “add a new row to another table using values from this row” as shown in the image below:
User | Count |
---|---|
35 | |
9 | |
3 | |
3 | |
2 |