HI,
I want to implement always select one value using trigger. I have put the following expression in the select field
if(GetSelectedCount(CrimeDates) = 0 and GetActiveSheetId()='Document\SH29',max({1}OffenseDateConv),GetFieldSelections(CrimeDates))
What I want is that if there is no selection, then the maximum value of offense date should be picked into the crimedate. However if a selection has been made from the calendar (crimedate), then the selected date should be used.
In the above expression, if I exclude the second condition (GetFieldSelections(CrimeDates)), then on pressing the clear all button, the max offense date is selected in the listbox but if I put the second condition GetFieldSelections(CrimeDates)), the trigger does not work properly. It does not pick the max value on clearing and it does not select multiple values from the listbox. it clears the listbox if I select multiple values
Can someone please tell me whats wrong with the expression
Arif
