?
Solved

Leave CALENDAR view

Posted on 2006-06-23
4
Medium Priority
?
228 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 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

801 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