Date setting in MatrixBox

Erik_E

I am having problems with the following:

I need to create a matrix form in which i would like to register worked hours per job. I would like to use the standard trendscape buttons as well. These buttons will be used to set the period, but in the matrix box i always wanna see days.

So i I would set the trendscape button to week I only wanna see the current week from begin to end in the matrix box. Let's say from 22-3-4 till 28-3-4 and not further like 29-3-4 etc. If I would change the trendscape to month i would like to see only the range from 1-3-4 till 31-3-4 in my matrix box . So not like u have standard an infinite amount of dates and day only the current day in the matrix box.

Does anyone have an idea how to do this????

TIA

Abhishek.sharan

Hi Erik,
Did you find a solution to this problem. Even I have a similar query.
Please help.
Regards,
Abhishek

Urmas

Eeeee....

If I understand correctly what you want...

Use Date table with Period type = trendscape button selection.
Set matrix box header to be a text according to the start and end day of the date table record.

Abhishek.sharan

Hi Urmas,
I have a table having 3 columns (Asset Id, Date and status).
I put the Asset id as the vertical column and for each asset, for each day I want to record the Status.

=============================
Asset ||01-01-0000|02-01-0000|
=============================
ABCD || 1| 0|
=============================

How to go about this?

Regards,
Abhishek.

Urmas

Descrbing the actual code would be quite a task.

Look into standard Budget window for help.

Abhishek.sharan

I have done everything but the problem is that when I change the status on one date, it gets updated for the rewst too. The database only has one vlue for the Asset. It doesn't even update the date. I might be doing a silly mistake somewhere. Please give me a checklist.

Urmas

Use OnValidate trigger of Matrix edit box to write the status into correct database line.

You have to do it yourself - no help from the database for that.