Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Add severalnew rows in a table, in base of another refered table

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?

0 1 121
1 REPLY 1

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:

Top Labels in this Space