Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Leave CALENDAR view

Posted on 2006-06-23
4
Medium Priority
?
233 Views
Last Modified: 2013-12-18
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
Comment
Question by:Zopilote
  • 2
  • 2
4 Comments
 
LVL 46

Expert Comment

by:Sjef Bosman
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

by:Zopilote
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

by:
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

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

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
Screencast - Getting to Know the Pipeline
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question