Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two multi box Year & Month
So when I select Year 2015 I want the Month should be display as =Max(Month) i.e. June, but there should be other Month in the list.
Can ayone help me with this.
Thanks & Regards,
Renuka S
Maybe you can try to set this in sheet or document triggers -> Select in field month Max(month)
Hi,
I tried doing the same but the Multibox contains if condition in it,
Selection is getting selected Max Month but it does not show in MultiBox display.
Thanks & Regards,
Renuka S
See the attached app.
But frankly I don't know how it is working. Can any one explain what is happening there
In that case, create another field using your condition in the script and use the new field in your multi box and then try trigger option as Daniel said. It should work.
Still you can't see ohter months in MultiBox.
Hi Renuka,
Can you reduce the data and attach your sample application.
That would be helpful.
Thanks
BKC
Solution in attachement
Hi Renuka,
test this, I hope can help you (monthname is in Italian but it is not a problem).
Regards.