Skip to main content
Nintex Community Menu Bar

Auto populating fields from spreadsheet to Nintex forms

  • September 29, 2017
  • 1 reply
  • 16 views

Forum|alt.badge.img

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

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • August 16, 2019
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.