Selection issues in the field

[jagannalla]

Hi,

In my app I've two fields i.e Product and BusinessDate. When app is opened I want to select MinString value of Product and Max value of business date for particular product. I had written open trigger for this. It is working perfectly. I'm display business dates which belongs to particular product in Multibox using the condition. =If(Product=GetFieldSelections(Product),BusinessDate). So that I can see only dates belongs to particular product which I selected.

Now When user selects another product I want to select Max business date in multibox and also user should be able to select another date for same product.

If you observe carefully max dates are different for each product. And the max date of product A is a possible value of product B.

Please find attached app with sample data.

LOAD * INLINE [

    Product, BusinessDate

    A, 1/27/2015

    A, 1/28/2015

    A, 1/29/2015

    B, 1/28/2015

    B, 1/29/2015

    B, 1/30/2015

];

[tresesco]

Try this in listbox/multibox:

=Aggr(Only({<BusinessDate>}BusinessDate),Product,BusinessDate)

[jagannalla]

No help on this also.

[tresesco]

Yes, now I notice that, though it shows only related dates; it doesn't allow selection. Meanwhile, try to teach users about 'Show Alternatives' option in the listbox general tab. That could help identifying the related values.

[jagannalla]

Hi,

It is good idea, but they need in drop down level to choose dates. We can enable Show Alternatives for listbox but we don't have option for multi box.

Thanks,

Jagan