how to create a nice timetable entry form

pkesch

Hi to all,

I am struggling to create a nice form where the users can enter their time spent on specific projects.

the header line should contain the days of the month (1-28/29/30/31) and the day (Mo-Su).
The details should be editable as a inline editing function.

I played around with several alternatives but found no nice solution.

First alternative I used was a reference from my entry BO to a timesheet BO (multible allowed) where the timesheet had several fields (1-31) of type number.
One problem here was that I could not set the display length to 2. It always displayed the filed with a length of 6!

The other Problem was that I could not display the day of the week.

I am thinking about a nice Excel like entry stile.

Can this be done with the calender function? I could not find anything in the documentation as there are only the day, week, month views mentioned and their lookout does not match my expectations.

Any suggestion?

Cheers, Peter

greg

Peter,

If you need to display a current date but want to have it editable you can set up a date type attribute with initial value CURRENT_DATE or number type attribute with initial value CURRENT_DAY_OF_MONTH or whatever other option you may require. Check Date and Time Functions chapter in the user guide, they provide a comprehensive list of options.

Your user can then change date/day in a normal way or for day of the year you can set this attribute with a drop down choice of number 1 to 31.

You can use the same approach for day of the week or if you just want to display it for a user you can set an html type cell on the object form and put this tag there: <<CURRENT_DAY_OF_WEEK>>, you can add html tags around it.

greg

pkesch

Hi Greg,

thanks for your answer. I know this functionality I only do not know how to use it in my context.

I intend to have a timesheet report (form) similar like the one in the link:

http://www.officetimesheets.com/tour/Tour_Page1.aspx

The consultant would be able to enter the hours spent on a specific project like in excel.
The only difference is, that I would like to have such a form for a complete month (day 1 to 28-31)

Any suggestion welcome 🙂

Best regards,
Peter