Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to auto-display a note with NOTE_TYPE = 'TOP' and EXP_TYPE_CODE = 'Capital' for the most recent month as defined by
vCurGLMonth.
I would also like the FISCAL_MONTH_YEAR selection across the stop (7/16, 8/16...) to automatically have the vCurGLMonth selected.
This is not working:
=date(FISCAL_MONTH_YEAR, 'MMM-YYYY') & ' ' & only({<[NOTE_TYPE] = {'TOP'},EXP_TYPE_CODE={'Capital'}>}NOTE)
Please help.
Added a button to for the trigger to work...
Created a list box object for FISCAL_MONTH_YEAR and made it always one value selected
Would you be able to give an example of what you would see when you select 08/16 for example?
I think there is something wrong with your data model..... When I select EXP_TYPE_CODE (Capital)... I still see both capital and Operating note and that is why the Only expression isn't working...
Workaround?
=date(FISCAL_MONTH_YEAR, 'MMM-YYYY') & ' ' & only({<[NOTE_TYPE] = {'TOP'},NOTE={'*Capital*'}>}NOTE)
But you may want to fix the data model
Oops. You are right. Here is the file with the fixed join. I still am trying to figure out how to automatically display the note associated with the vCurGLMonth.
This?
=date(Only({<TRX_DATE = {"$(=vCurGLMonth)"}>}FISCAL_MONTH_YEAR), 'MMM-YYYY') & ' ' & only({<[NOTE_TYPE] = {'TOP'},EXP_TYPE_CODE={'Capital'}, TRX_DATE = {"$(=vCurGLMonth)"}>}NOTE)
Halfway there. Thanks. 2 more questions...
So the note populates but how do I show the month/year selection at the top with the vCurGLMonth?
This isn't working as a document trigger:
Also, how can I restrict the month selections to only allow one month to be selected at a time? My calculations won't work if multiple months are selected -per the requestor's design.
Added a button to for the trigger to work...
Created a list box object for FISCAL_MONTH_YEAR and made it always one value selected
Thanks. I was using an expression for my date list box so the Always Select One Value option wasn't there.
Thanks for the right trigger syntax =Only({<TRX_DATE = {"$(=vCurGLMonth)"}>} FISCAL_MONTH_YEAR)