Timesheet application

pkesch

Hi to all,

did anyone already realize a timesheet application?

I have an application in mind where all employees could enter the time they spent on projects in an excel like interface? I would like to have this implemented with the "inline editing" functionality.

The problem here is to label the fields as they could be different for each day of the month (e.g. 1st of September could be a Monday, Tuesday.....) and in case of a weekend (Saturday or Sunday or Public Holiday.. the fields should be marked in a different colour).

After my experiments I think it could not be done or at least it is not so easy.

Does anyone has an example bsv?

By the way, the calendar view does not help too much here as it has its limitations.

Best regards,
Peter

pkesch

by the way....

I think this would be a nice demo application which would be (may be) a bit more useful as almost every company needs such a functionality..

(just thinking and hoping to get one 😃 )

tazzmaxx

I would be very interested in this as well. I have a time utility that I use and it generates a cross tab type entry interface (see below) which is very handy for entering time for specific projects over the course of a week. I am not sure if a cross tab type data entry form is possible in Aware. I was thinking that an editable grid would be helpful for this but the summary functions are not availble in grid mode yet.

             Mon 1/1     Tues 1/2    Wed 1/3   Thur  1/4    Fri  1/5

Project 1 2.5 2.0 4.5 3.5 2.0
Project 2 1.5 2.5 3.5 3.0 4.0
Project 3 4.0 3.5 0.0 1.5 2.0
Totals 8.0 8.0 8.0 8.0 8.0

pkesch

exactly what I would need / what I am looking for!

aware_support

I am not sure I understand what the problem is - perhaps if you can elaborate on what exactly you want to achieve, it would help

Aware IM does support dynamic calculations of totals, summary etc while you are doing inline editing - just check the Ordering sample application.

You can have a fixed set of days of the week on your form - for Monday, Tuesday etc. I believe you can even display labels in different colors if you include HTML tags in your labels. So, not sure where the problem is.

pkesch

Hi support,

as far as I know html attributes are NOT supported in Labels. This is the main problem.

Just imagine an entry-form for one week, starting with Monday and ending with Sunday.
Now, Monday could be every day of the month (1-28; 29; 30; 31).

As HTML attributes are not supported in Labels how to change the text?

I also agree with "tazzmaxx" that this is a typical task for a cross tab which is not supported in AWAREIM for inline editing.

A cross tab is a virtual table which presents table entries as columns.

In a timesheet application it does not make sense to have a table for the week. It makes more sense to have a table (BO) which would have the following fields:

Project (reference to a projects BO)
user (reference to a user)
date (day of the year)
hours (hours spent on the project)

Now the trick is to create a inline editable form where the user can simply enter the hours spent on his projects, marking Saturdays and Sundays in a different color and display the summary of the hours by days (like the example from tazzmaxx).

It would be great to have such possibility in AWAREIM.
And, having such an application would immediately boost the number of users.

Regards,
Peter

aware_support

as far as I know html attributes are NOT supported in Labels. This is the main problem.

This is not true. It IS supported in version 4.0. For example, if you have an attribute called Name, go to its presentation dialog and enter the following into the "label" text box:
<font color=red>Name</font>

The label will be displayed in red.

I don't see why other things present a problem - you may be underestimating the power of inline editing in version 4.0. Once again please have a look at the editing of PurchaseOrder line items in the Ordering application.

For your table:
Project - shortcut to the name of attribute of the Project BO. When the user edits this field Aware IM will automatically display a drop down with all existing projects.
User - shortcut to the user name. Same as for project - a drop down will be displayed
Date - calendar will be displayed.
Hours - a number to be entered

Then you can define simple presentation rules that would display number of hours in red if the day is Sunday or Saturday.

I really can't see a problem here.

pkesch

Hi support,

thanks for the fast reply. When I made the statement that HTML is not supported in Labels I was referring to the following post:

Gabbitas

Hi Pkesch and tazzmaxx,

Would be very interested to know how you overcame the user interface problems you talked about here?

I am facing the same challenge of finding an elegant way for a user to input hours worked against his projects. I would like it to be simple and look similar to a paper time sheet so it is recognisable to users.

One thing I have thought might work well is if a user was presented with a scheduler that would display dates along the top and a list of projects down the side. Then if it was possible for "inline editing" on a scheduler (which it's not) the user could just click in the appropriate cell and enter the hours worked for that particular day and that particular project.

Support - is the possibility for 'inline editing' of scheduler items (subject) on the roadmap? If not could I request this feature in a future release?

Thanks