Creating an activity code on a notes form automatically

Posted on 2011-02-18
Medium Priority
Last Modified: 2013-11-17

I have received some great advice on this site so far so I am going to take a different approach when asking my questions.  

I have a document that is created by users with a number of days and date range.  I would like the form to create some kind of way of recording activity codes per hour they have worked.   My first idea was to use a combo box based on how many days the users enters and then this gives the user the chance to select the criteria (code).

Before I start looking into this I thought it would be worth asking if there was a better way of compiling this.

Thanks, Richard
Question by:RichardH1976
  • 2
  • 2
LVL 22

Expert Comment

ID: 34930506
It's really a good idea to get advices about the concept before you even start working on it, but you'll have to give us much more details.

So users have an option of entering either a number of days or a date range (start and end date)?
Then you want to get the number of working hours of a date range?

Explain this sentence a little better:
"I would like the form to create some kind of way of recording activity codes per hour they have worked."

What is activity code?
What would you like the options in combo box to be?
What is criteria?

Author Comment

ID: 34930646
I have a form which shows;
Employee Name:  Joe Bloggs
Start Date:      05/01/2011 Wed     (Date)
End Date:      05/01/2011 Wed             (Date)
Week:      2011-W01                       (Works out Week Number)
Days Worked :      1 Day                       (Units of days worked    0.2 would be 2 hours)

This records days employees spend on accounts which has been working great.  I would like to break up 1 day into 8 hours for so I can assign an activity code like "Training2 ect.   But not sure if this is the right way to make this work.....

I am struggling with the concept of if notes is capable of dealing with this in any other way.    I realise I could use a combo box to assign the whole day to a  document but I am struggling with a way to break the time up and create a 8 (hours) combo boxs.  My vision would be that this would be available at the bottom of the form so we can pick and chose when to use it.  

LVL 22

Accepted Solution

mbonaci earned 2000 total points
ID: 34931145
So you want to be able to specify activity code for each hour of each working day, right?
Maybe it's best to use dialog box/table combination, as explained here:

You can download the sample database from here:

Here are instructions on how to refresh RTF:

This question might also help you:

If you need more help...

Author Comment

ID: 34933020

Thanks for you help.  Exactly what I needed some good ideas.

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.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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…
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.
In this video I will demonstrate how to set up Nine, which I now consider the best alternative email app to Touchdown.
Free Data Recovery software is an advanced solution from Kernel Tools to recover data and files such as documents, emails, database, media and pictures, etc. It supports recovery from physical & logical drive after a hard disk crash, accidental/inte…
Suggested Courses

624 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