How to link an input box with an existing list box column?

[#1]

Dear Experts,

I have a list box with columns (item,period(mon-yy),price). Trying to make a line chart showing price variance for the given period. As we have more than 50000 items, the search option in the list box taking long time to fetch. So we thought of having an input box and link it to the item column in the list box. We wanted to see the result of the item which entered in the input box.

Please advise,

Thanks,

Saravanan

[#2 · Accepted solution]

Hi,

1. Create one variable vInput. Use that variable in Input box.

2. Go to Document settings--> Triggers --> Variable Event Trigger

3. Select vInput varible. add Action.

4. Select in field.

Add Product in field

Add =vInput in search field.

Hope this will help you.

[#3]

Hi Anand,

The above step just created a new list box with the only value 2. But this is not our requirement. We are trying to get a value dynamically and wanted to link it to the existing list box which already linked to some charts. So, when we change the value in the input field, expecting the corresponding changes in the list box & charts attached to it.

[#4]

//Sample data

Test:
Load * Inline [
Product, Sales, Year
A, 100, 2010
B, 200, 2009
C, 500, 2011
D, 400, 2012
E, 300, 2013
F, 800, 2014
];

1. Take The Listbox Product
2. Take Input Box with by creating a new variable vInputProduct
3. Go to Document Properties->Triggers->Variable Event triggers->OnInput->Add Actions->

     Select In Field->

                   Field : Product
                   Search String : =vInputProduct

4. Take one button-> Properties->general-> Text : ClearAll
     Actions -> ClearAll
                     Set Variable ->

                     Varaible : vInputproduct
                     Value :Leave it blank

5. Create one Line chart with year as dimension and =Sum(Sales) as Expression

Hope this will helps you..

[#5]

Hi Priya,

We tried above steps, still the result is not as we expected. I am enlosing the screenshots of our setup.

Please advise where it's going wrong?

Thanks,

[#6]

Hi,

The field name u have provided in trigger is not correct.

Field name u used in list box is PART_NO and the field name u mentioned in trigger is part_no.

Make sure that field names are correct.

Hope this will help you..!

[#7]

Hi Priya,

Great, It's working now.

Thanks for your support.