I have an air table form where my employees are submitting their leave requests, meaning multiple entries for the same employee with different dates.
I would like to create a summary of the total number of leave taken by each employee but I'm having a hard time doing it.
Is there anyone who can help guide me on the best way to calculate the leaves by employee?
I'm assuming you have a table called "Employees" or some such that's linked to this "Leaves" table?
If so, in your "Leaves" table, add a formula field with "WORKDAY_DIFF()" to get the number of workdays each record has
After that, in your "Employees" table, add a rollup field to sum up the values from the formula field we just created. This should give you a total count of the number of work days the employee has applied for leave
That's odd. Let's say you have a record in the "Employees" table with the primary field value being "Bob".
In the "Leave" table, if you paste "Bob" into the linked field to the "Employees" table for any of the records, those records will then be linked to that one "Bob" record, it shouldn't create any more records
Could you provide some screenshots of the "Leave" or "Employees" tables, as well as the automation (if any) you're using to link the "Leave" record to "Employees"?
If you could provide a base with example data that would be best