topic Re: Dimension limit Change in Listbox in Archived Groups

Dimension limit Change in Listbox

vengadeshpalani — Tue, 22 Jul 2025 17:59:49 GMT

Hi pls help to find the Calculated field expression for this scenario

Table1

Table2

i have two date fields when i click date1 fields, it change Date2 field dimension limit >=min(Date1)

Output

i click 11/03/2016 in Date1 so Date2 list box change to

vinieme12 — Mon, 19 Dec 2016 08:05:48 GMT

=AGGR(only({1}if(Date2 >= GetFieldSelections(Date1) , Date2)),Date2)

vinieme12 — Mon, 19 Dec 2016 08:08:31 GMT

to show all dates in case of no selections made use below

=AGGR(only({<Date2>}if(GetSelectedCount(Date1)=0 , Date2 , if(Date2 >= GetFieldSelections(Date1) , Date2))),Date2)

MK_QSL — Mon, 19 Dec 2016 08:43:51 GMT

Go to Settings

Document Properties

Triggers

Field Event Triggers

Select Date1

Click OnSelect - Add Action(s)

Add - Select in Field

Field

Date2

Search String

=If(GetSelectedCount(Date1),'(' & Concat({<Date2 = {'>=$(=Max(Date1))'}>}DISTINCT Date2,'|') &')','')

Do the same for OnChange for Date1

Hope this helps.