Dynamic Multibox?

[#1]

Hi,

I have questions...

Is it possible to make the multi-box dynamic? I mean, when I select class in the listbox - the field names of the multibox will be change... see example below...

CLASS LISTBOX

GROCERY

APPLIANCE

KITCHEN

MULTIBOX

when I select GROCERY

     the fields in the multi box should be

               ITEM, PRICE

when I select APPLIANCE

     the fields in the multi box should be

               APPLIANCE NAME, BRAND

when I select KITCHEN

     the fields in the multi box should be

               MENU, TASTE

Thanks and Best Regards,

Bill

[Jason_Michaelides · Accepted solution]

Sure. Just add a bunch of expressions as the milti-box dimensions like:

If(Class='Grocery',ITEM,

  If(Class='Appliance',Name,

     If(Class='Kitchen',Menu

)))

If there are many more possibilities I would look at putting an Inline table in the script that matches the values to multi-box requirements, then having a more simple expression here.

Hope this helps,

Jason

[#3]

Hi, can you give me an example? Thanks.

[Jason_Michaelides]

Sure.  Please provide some sample data.

Jason

[#5]

I have a similar need. It works fine to display the items, however, I cannot select any values when a multibox field is an expression. It shows me the possible values but when I click on it, nothing is actually selected. If, instead of the expression, I add each one of the fields as separate fields It works but I can only show one or the other depending on my if check.

Any idea?

[Jason_Michaelides]

Please post a sample app to demonstrate the issue.