Who is on vacation? (Page 1 of 2)

Hi sparrow, sorry for the delay but I had to make a move. It was just what I needed. I would like to ask your advice: in your opinion,from the point of view of accuracy, is it better to make two tables,one with the person's biographical data and one with the vacation days or is a single table as I have done okay?

Hi Derek, Fabio

Derek is right.

I want to note that it will be necessary to think more about the correct calculation. Next year is coming...

Hi friends, I'm trying "to steal" great ideas that I wouldn't have come up with from derek's project.
I studied the project and I'm creating one from scratch because I would like to understand and above all learn. Unfortunately I've been stuck in something stupid for two days.
It took me so long to write because I was stubborn in wanting to understand on my own but I surrendered to the evidence of my ignorance.
I know that the project I am attaching is crude from every point of view, even the aesthetic one, I need a lot to learn.
The question is this and I repeat it will also be very stupid for you experts: by inserting the start and end dates of holidays I assign them to all employees instead of a specific one.
Thanks for your patience.

Hi Derek, you won't believe this but I didn't check this because I was convinced that I set the field with the relationship. I've spent the last two weeks moving house, I must be stoned. Thank you!

You first need to create a field in your 'employees' table to hold how many days holiday an employee  is entitled to.
Once you have done that, the calculation for 'days left' is

holidayentitlement - (select sum(abs(julianday(start) - julianday(end)) +1) from holidays where holidays.id_employees = employees.id)  

(where 'holidayentitlement is the name of the new field).
You also need to consider (as Sparrow mentioned in an earlier post) what the business process is when the employees go from one holiday year (2023) to the next holiday year (2024) etc;  the example I attached earlier was simple because all employees had their holiday entitlement re-negotiated on January 1st each year but your project might need to use something like an additional 'holiday year' table.
It might be worth your while spending a bit of time with a more straightforward  'test' project to help familiarise yourself with MVD before moving on to something that is a bit more complicated;  it's what I did when I first started using MVD and in the long run, it was time well spent.
Derek.

The calculation is the same as you are already doing.
But instead of using 'start' and 'end' date, you used the reserved word 'now' to represent the current date (today)

(abs(julianday('now', 'localtime')) - (julianday(startdate))) + 1  

See attached.
Derek.

Hi,
Fixed (see attached).
But you also need to consider how the calculation works when you have more than one entry per employee in the 'holidays' table - there will be more than one 'start' date so which 'start' date should you use (in the attachment, I have assumed it is the most recent one (and so I use the 'max' function) but I'm really not sure what your calculation is trying to show).
Derek.

Hello to both of you and thanks again for the effort to help me.
More or less or understood, more less than more, but I'm thinking about it. Now I would like to understand, always starting from derek's project, how to set the grand total of days taken by an employee at the bottom of the tablegrid as it is in derek's project. Honestly, I've looked and looked but I can't figure out which part produces this result.
Thank you very much.

Thanks sparrow, that was easy in itself but I would never get there.

Hi all,

look example

Hello everyone, you won't get rid of me, I immediately have a question:
I inserted a button to print, then I created the report but it doesn't work as I would like.
For employees who have multiple vacation sessions, the first and last name is replicated for each vacation session.
What I'd like you to do instead is put the employee's name, for example as the title, and then all the sessions, without always replying name and surname.
Can you give me a hand please?
Thank you!