Solved

Creating an activity code on a notes form automatically

Posted on 2011-02-18
4
330 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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

707 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

14 Experts available now in Live!

Get 1:1 Help Now