Solved

Leave CALENDAR view

Posted on 2006-06-23
4
219 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 50 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

734 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