Multiple selection in single list box using tigress

[#1]

Hi All,

i am looking for below requirement solutions can anyone help me with solutions.

I have Inline table like Product

ProductID, ProductName

1, Computers

2, Mobiles

3, Laptops

4, Large Acc

5, ACs

and i have another table comes from Excel:

Products Table:

Product_ID

2,

3,

5

When ever excel can reload defaulting excel sheet-> Product id's has to select in my listbox...

Can anyone help me asap.

Please note using macro i need it.

Thanks,

Surya.

[senpradip007]

PFA. Hope it will help.

[sateeshkumar · Accepted solution]

Hi,

put this code in onOpen document trigger

select in field:  productId

search string:   ='(' & Concat(Product_ID,'|') &')'

this will work

Regards

Sateesh A

[rahulpawarb]

Hello Surya,

As a workaround, please follow below steps:

1. Open Document Properties and locate Triggers tab.

2. Select OnPostReload from Document Event Triggers and press Add Action(s)... button.

3. Press Add button and select Selection as Action Type , Select In Field as Action

4. Enter below values:

    Field: ProductID

    Search String: = '(' & Concat(Product_ID, '|') & ')'

Hope this will be helpful.

Regards!

Rahul

[Anonymous]

Hi,

I have attached qvw.

Trigger-

='('&Concat(flag,'|')&')'

Some changes in script, PFA.

Thanks

Paridhi