In order not to lose sight of how many requests each employee has already submitted and, above all, how many days of vacation they still have left of their annual vacation entitlement, an employee overview is very helpful. In the second table, there is a row for each employee that serves as this overview. The table is linked to the first table and can therefore display and summarize information from this table.
This is very practical because you can use brazil rcs data formula columns to easily calculate the remaining vacation days. After you have assigned the approved and open vacation requests to the people, you can use two formulas to add up the vacation days already taken and calculate the vacation days still remaining. This way you always have an overview of the unused vacation days of each employee. However, to make this calculation work, you must not assign rejected vacation requests to any person.
Individual views for each employee
SeaTable offers a high level of data security , which is further increased by the server locations in Germany . As long as a database belongs only to you, no one else has access to the data - unless you specifically release it. So that you don't have to inform your team members individually about the outcome of their vacation request, we have already created notification rules in a previous step. But now your employees also need access to your vacation requests.