Dear Appsheeters,
I have a table named [Employee Payroll] Where every month our team will input each employee, payroll period, and Payroll Amount based on their own salary master data.
Is there any way for me to create an action button, that generate those payroll records automatically for selected or for all active employee without creating other buffer table? the input will be Payroll Period and Payment Date.
I need your advice.
Thank you.
These search results might help.
I think I have done a similar thing.
I have an app where multiple transport companies are managing their fleets as a whole.
Then they have a pool of drivers that are assigned to various vehicles throughout the week.
At the end of the week (beginning of the following), I have a report generated for each company with how much revenue they generated and how much each of them has to pay each driver.
The determining factor is the vehicle.
To achieve this I used some layered bots with looping with actions.
Is this what you are looking for? But there are multiple buffer tables.
You would need a buffer table
“SELECTOR”: [id],[month_end],[all_active_employees_id]
[all_active_employees_id] will be an EnumList with a formula in the Initial Value that would generate a list of unique ids for all the employees you want the payroll to be generated (maybe pulled from a shifts table) for the [month_end] of this record.
Then using looping with actions, with INDEX(), for each first id in [all_active_employees_id] you add a new row into the payroll table, then delete the first id in the [all_active_employees_id] using INDEX() again and start all over by creating the payroll record for the second employee_id (which now is the first one in the list, since previously you just deleted the 1st one)
You do that until ISBLANK([all_active_employees_id})
I hope it helps!
so there’s no way to do it without using Buffer Table right?
Thank you for your kind advice.
None that I can think of.
Thank you for your solution.