Learn how to a build a cloud-first strategyRegister Now

x
Solved

# Leave CALENDAR view

Posted on 2006-06-23
Medium Priority
233 Views
I have a Leave form where 20 employees enter their leave request.
I have a Staff form with 20 records for the 20 employes and their teams.
I have a Leave Calendar report where their leaves are displayed.

My boss wants to have a Calendar with the Staff that would be available every day.

So I need to display per day the names of the employees (form Staff) that have no records in Leave form.

Is this possible in LN?
0
Question by:Zopilote
• 2
• 2

LVL 46

Expert Comment

ID: 16970493
I'd say NO, it's not possible with the material you mention. You would need Availability records instead of Leave records. It is of course possible to construct these Availability documents more or less automatically. Each time a Leave document is updated, the Availability records for the user have to be updated as well.
0

LVL 5

Author Comment

ID: 16970557
Thanks for the prompt answer sjef.

Let's imagine I create a Form Availability.

Then I have Maria, she will be on leave from 23-30 Jan and from 15-Jul to 3-Aug...

How do I calculate that she is available the other days?
Do I need to have 365 (366) flags one per day?

0

LVL 46

Accepted Solution

Sjef Bosman earned 200 total points
ID: 16971045
You can have a multi-value DateRange field, that you can use to calculate all dates. You'd have to smuggle a bit with the first and the last entry, mainly with the last one: you'd have to find a suitable end-date for your calculations, say end of next year. Which means that you'd have to update availabilitydocuments at least once every year.

Thinking about the request again, I'd never do this. It might work for a 20-people department, but what if you grow to 200? Or 2000? Not good. A different suggestion: make a button "Who's in", make it open a DialogBox that displays all people present, using a formula like this:
all:= @DbColumn(...;"ViewAll"; 1);
absent:= @DbColumn(...;"ViewAbsent"; 1);
@Trim(@Replace(all; absent; ""))
0

LVL 5

Author Comment

ID: 16985501
Many thanks! This is a good start.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question