Looping with Action

[TankerChu]

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?

[Tommy62]

Schaue das meiner Meinung nach beste Erklärvideo für Schleife mit Aktion: Looping mit Action 

[TankerChu]

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