Matrixbox based on date, jump back to current date

MarcoV

Hi,

I'm investigating a problem regarding a matrix form, where the matrix-record is based on the Date table.

What I want to do is make a button which, when clicked, let's the matrix jump back to the current date (TODAY or WORKDATE) after scrolling around.

kriki

Didn't try this out, but it should be something like this:

CurrForm.matMatrix.MatrixRec.FILTERGROUP(6); // go to another filtergroup...
CurrForm.matMatrix.MatrixRec.setrange("Period Start",0D,TODAY); // ... to NOT overwrite a possible existing filter on period start
CurrForm.matMatrix.MatrixRec.FIND('+'); // get the record
CurrForm.matMatrix.MatrixRec.setrange("Period Start"); // remove this filter
CurrForm.matMatrix.MatrixRec.FILTERGROUP(0); // get back to normal filtergroup

Luc_VanDyck

Alain,

You have some RSS notification installed to notify you whenever there is a new message in the mibuso.com forum containing the words "matrix form" ;-)

MarcoV

kriki wrote:

Didn't try this out, but it should be something like this:

CurrForm.matMatrix.MatrixRec.FILTERGROUP(6); // go to another filtergroup...
CurrForm.matMatrix.MatrixRec.setrange("Period Start",0D,TODAY); // ... to NOT overwrite a possible existing filter on period start
CurrForm.matMatrix.MatrixRec.FIND('+'); // get the record
CurrForm.matMatrix.MatrixRec.setrange("Period Start"); // remove this filter
CurrForm.matMatrix.MatrixRec.FILTERGROUP(0); // get back to normal filtergroup

Thanx for your fast reply, this works great! =D>

kriki

Luc Van Dyck wrote:

Alain,

You have some RSS notification installed to notify you whenever there is a new message in the mibuso.com forum containing the words "matrix form" ;-)

For matrix-form problems on Mibuso, I don't even need an RSS notification.
I use the Force to feel those, Luke
And I solve matrix-problems by manipulating the Matrix like Neo does.