I have a requirement to display the current year data whenever the selection on "Year" list box is cleared.
i.e; if the current selection on Year list box is 2019,2020. On selecting clear All, 2021 data needs to be displayed.
I added a variable with below expression and applied Select in Field Trigger as below
variable --> If(GetSelectedCount(Year)=0,max(Year),GetFieldSelections(Year))
Trigger --> Field - Year, value - max(Year)
with this the latest year data is getting displayed whenever the clear all is selected but user also wanted to make multiple year selection.
Both of these requirements are not working at the same time. So, requesting your inputs on this at the earliest.