Action and Expression

Hello again,
this is for weekly payroll.
from the dynamic list of Names in my parent table, i am trying to combine all the names in 3 different employee role columns and then pick up the name that hasnโ€™t been captured yet to put in the payroll table.
my plan is to create an action that will automatically compute all the pay for each name. the payroll table has a spreadsheet formula that will compute all once name is dropped in name column.
so far this expression is giving me one name continuously . How can I get an action to fill all the name in payroll table, either in single or bulk action?

 (Dipstick[Pump 1 Attendant]
            +
 Dipstick[Pump 2 Attendant]
             +
   Dipstick[Cashier])
            -

Select(Salary[Name],[Week]=[_Thisrow].[Week])

3X_f_d_fd7cf925189da055ea12e845914a236267cf8f67.png

0 3 233
3 REPLIES 3
Top Labels in this Space