Hi Sunil,

You would probably need to create a lookup list (1 or 4 depending on how many columns you need putting in it i.e one for each Product Name /Material code etc or just one list containing all these columns). List bulk edit could be used to import data from Excel into the Lookup lists.

Once data inside the lookup lists your master lists could be customised using Nintex forms and the Lookup columns namely (Product name etc) would be rendered as the lookupvalues and will give you features like when the user types it will display matching products.

hth,

Shrini

Hi Srini,

Thanks for your quick solution.  I have some queries :

1.  As you mentioned "List bulk edit could be used to import data".  Where this option available?  Is it a Workflow control or Form Action?

2.  I want to upload the excel periodically (say weekly) and it should overwrite the existing items.  Is it possible?

Please guide.

Thanks

Hi Srini,

Thanks for your quick solution. Need clarification please.

1. As you mentioned "List bulk edit could be used to import data". Where

this option available? Is it a Workflow control or Form Action?

2. I want to upload the excel periodically (say weekly) and it should

overwrite the existing items. Is it possible?

Please guide.

Thanks

Sunil

Best Regards

Sunil Tamanekar

Roche Products (India) Pvt. Ltd.

Phone: +91-22-33941024

Mobile: +91-8451952002

EMail: sunil.tamanekar@roche.com

Hi Sunil

When you click on the list you would be given this option where you could click edit list and add rows in bulk. You could use excel rows and paste it here.

If you want an automated way (i.e.) every week then you would need to explore the option of Query excel services action and may be read an populate the list.

hth,

Shrini