I have 2 Table which are TImkeeping_Data and Approve
For Timekeeping, it has these columns:
DATE | EMPLOYEE_ID | WORKING_TYPE | NUMBER_OF_PROJECT | PROJECT_ID_1 | PROJECT_PM_1 | HOUR_1 | DETAIL_1 | PROJECT_ID_2 | PROJECT_PM_2 | HOUR_2 | DETAIL_2 | TOTAL_HOUR | STATUS |
For the Approve Table, it has these columns
WORKINGDAY_DATE | PROJECT_PM_ID | EMPLOYEE_ID | EMPLOYEE_NAME | WORKING_TYPE | PROJECT_ID | HOUR | DETAIL | STATUS | ACTUAL_MD |
So right now I've created several actions to add a new row for each project. For example, an action to add a new row of PROJECT_ID_1 from the Timekeeping to Approve table and another action for PROJECT_ID_2.
My question is: is there any other way to make this quicker like looping or anything like that to reduce the amount of action Appsheet has to run when sync?
Schaue das meiner Meinung nach beste Erklรคrvideo fรผr Schleife mit Aktion: Looping mit Action
thanks for the advice but the solution in the video seems to only work with items from a list like an enum list. It's not for the value in multiple columns.
I'm imagining something like looping through the column like AppSheet would count the amount set of columns and then loop through it.
For example, AppSheet would count that there are 2 sets of columns in the example, and then add a new row from timekeeping to approve a set of Project 1 columns like this
DATE | EMPLOYEE_ID | WORKING_TYPE | NUMBER_OF_PROJECT | PROJECT_ID_1 | PROJECT_PM_1 | HOUR_1 | DETAIL_1 |
and then it runs again to add a new row for a set of project 2 columns to approve like this
DATE | EMPLOYEE_ID | WORKING_TYPE | NUMBER_OF_PROJECT | PROJECT_ID_2 | PROJECT_PM_2 | HOUR_2 | DETAIL_2 |
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
16 |