Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can anyone help me out with approach to get dynamic list box based on field selection.
Ex: I have a list box with all field names. Now once clicked on any of the field in the list box a new list box should be visible holding selected field values.
Regards,
Prajna
Create a list box and dynamically show it based on the Field selection
Add this as a conditional option in Layout Tab
Count(DISTINCT FieldNames) = 1
the list box will only show if a selection is made in the FieldNames List Box
Hi,
I have to create a list box and under layout I have to give Count(DISTINCT FieldNames) = 1 ????
Then what should be chosen for dimension and FieldNames referrred can be $(Field)??? or what exactly it signifies?
hi,
create a list box and on properties Layout>> Show, check conditional and put condition
=Count(DISTINCT YourFiledName) >= 1 , it Mean this list will be visible only when you will select 1 or more fields in other list, you dont need any dimension ,or any other step, try this and let us know, its works or not..
Hi,
Now the main list box has say 10 field names. On click of each field name I should get a list box holding data for that particular field.
So in the exp =Count(DISTINCT YourFiledName) >= 1
yourFiledName holds what name??
Regards,
Prajna
the field name which you will select..
and You wrote " On click of each field name I should get a list box holding data for that particular field."
what type of data, or you mean the selected field name?
let me know in detail. your fields name. or if you can attach an example doc..
for ex: I have field names likes this in a list box called list box1
list box1
Branch Name
Account Type
Now when I click on field Branch name.. A list box with Branch Name data should appear. As shown below
Branch Name
B1
B2
B3
B4
next on click of Account Type.. A list box with Account Type data should appear.
Hi,
I would do:
1) Create a variable
vCurrentField: =$(Field) it is a formula
2) 1st list box:
Dimension: = $Field
3) 2nd ListBox:
The Expression: = $(=vCurrentField)
Fabrice
May be like attached sample?
hi..
I tried this em not getting any result
Regards,
Prajna