Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi pls help to find the Calculated field expression for this scenario
Table1
Date1 |
---|
11/01/2016 |
11/02/2016 |
11/03/2016 |
11/04/2016 |
11/05/2016 |
11/06/2016 |
Table2
Date2 |
---|
11/01/2016 |
11/02/2016 |
11/03/2016 |
11/04/2016 |
11/05/2016 |
11/06/2016 |
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
Date2 |
---|
11/03/2016 |
11/04/2016 |
11/05/2016 |
11/06/2016 |
=AGGR(only({1}if(Date2 >= GetFieldSelections(Date1) , Date2)),Date2)
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)
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.