Selection of year and month

[chaitanyajami]

Hi all,

i have filed Year and month in list box objects and if user selects year as 2014,2015 month should be shown as only December and if user selects current year then is must show all month from jan to jun 2016, how to achieve it thank in advance

[MK_QSL]

You need to create Trigger on Year Field.

Go to

Settings - Document Properties - Trigger - Field Event Trigger - YearField - Add Actions for On Select and On change

Select In Field

Month

Search String

=IF(GetSelectedCount(Year) <> 1, '', If(Max(Year) = Year(Today()), Month(MakeDate(Max(Year),Max({<Year = {"$(=Max(Year))"}>}Month))),'(' & Concat({<Month>} DISTINCT Month, ' | ', Month) & ')'))

Check enclosed sample document...!

Or use below as a Search String

=IF(GetSelectedCount(Year) <> 1, '', If(Max(Year) <> Year(Today()), Month(MakeDate(Max({<Month>}Year),Max({<Month=,Year = {"$(=Max(Year))"}>}Month))),'(' & Concat({<Month>} DISTINCT Month, ' | ', Month) & ')'))