Auto populating fields from spreadsheet to Nintex forms

  • 29 September 2017
  • 1 reply
  • 4 views

Badge

I have a requirement that the Nintex form should receive the data automatically from a spreadsheet. In the below example, if I enter the PT# the form is supposed to pull the 3 columns which has the same PT#. I really appreciate any work around/ideas from the professionals.

 

PT#

Title

Customer

Soldto Num

Promo Item

Product Number

Promo Start

Promo End

Pricing

Total Offer

 Supplier $ Off

PT15.6859

JAN16 DIGITALDEALS PGC TPRS            

Wayfair

630125

PGC92968

8552432

1/1/2017

1/31/2017

Promo

$  1.25

 $       1.25

PT15.6859

JAN16 DIGITALDEALS PGC TPRS            

Wayfair

630125

PGC92970

8552382

1/1/2017

1/31/2017

Promo

$  1.25

 $       1.25

PT15.6859

JAN16 DIGITALDEALS PGC TPRS            

Wayfair

630125

PGC94142CT

8408866

1/1/2017

1/31/2017

Promo

$  1.25

 $       1.25


1 reply

Userlevel 6
Badge +22
Hi,

At the present time Nintex Forms cannot lookup an Excel sheet.
The data would have to be in a SharePoint List or a Database to acheive this solution.

Reply