Solved

Creating an activity code on a notes form automatically

Posted on 2011-02-18
4
332 Views
Last Modified: 2013-11-17
Hello,

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
0
Comment
Question by:RichardH1976
  • 2
  • 2
4 Comments
 
LVL 22

Expert Comment

by:mbonaci
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?
0
 

Author Comment

by:RichardH1976
ID: 34930646
Thanks.
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.  




0
 
LVL 22

Accepted Solution

by:
mbonaci earned 500 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:
    http://www-10.lotus.com/ldd/bpmpblog.nsf/dx/dynamic-table-1?opendocument&comments

You can download the sample database from here:
    http://www.eview.com/eview/volr6.nsf/2a8bf6b62c61b60585256f2500684630/8d16059c38b20bd485256fb8005af17b?

Here are instructions on how to refresh RTF:
    http://www-10.lotus.com/ldd/nd6forum.nsf/55c38d716d632d9b8525689b005ba1c0/dd507a5be7cc2e4285256eec005f56ef?OpenDocument

This question might also help you:
    http://www.experts-exchange.com/Q_24870689.html

If you need more help...
0
 

Author Comment

by:RichardH1976
ID: 34933020

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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

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
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

863 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now