Solved

Leave CALENDAR view

Posted on 2006-06-23
4
222 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

Technology Partners: 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

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

705 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