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])
User | Count |
---|---|
41 | |
36 | |
29 | |
23 | |
16 |