How do you display additional fields for an External Data column on a form?

  • 15 March 2016
  • 4 replies
  • 8 views
A
Badge

I have an External Content type connected to a USP on an External SharePoint 2010 list using Business Connectivity Services. In a second associated list, I have no problem looking up and displaying an external data column and associated columns on the list view. However, in Nintex Forms, only the source column can be seen when I configure an External Data column. There is a section for Additional Fields available, but I can't figure out how to get these to show in the form. See the example below:180045_pastedImage_1.png

The result I am looking for is to enable a user to select a project number from an External Data column, and to show the project client and description on the form. Any help in accomplishing this is appreciated.

4 replies

F
Userlevel 6
Badge +16

http://help.nintex.com/en-US/nintex2016/current/#Forms/Controls/Controls.ExternalDataColumn.htm 

ncocchiara_77
Badge +2

I need this information too but when I click on the link below I get a blank screen?

SimonMuntz
Userlevel 6
Badge +22
Hi,
Please see the updated link here :
https://help.nintex.com/en-US/nintex2016/current/#sp2016/Forms/Controls/Controls.ExternalDataColumn.htm%3FTocPath%3DWork%2520with%2520the%2520basics%7CActions%2520and%2520controls%7CForms%2520controls%7C_____8
Cool Nintex courses: https://learn.nintex.com/
Tahari
Badge

Took me ages to figure this out too, but surprisingly simple in the end.  Just add a Label or TextBox control on the form, then for the text, just insert a reference, and any of the External Data columns you made available can be added.  See screenshot where Contact Id was the external data column and you can see the secondary columns available to be inserted as well.

 

5599i08EAD8839050E36A.png

 

This next screenshot shows what it looks like on the form after you've added them.  Note that when editing (in the actual published form), the data in the fields will only get refreshed once the form is saved.  Haven't worked out how to display them immediately when the Contact Id is changed.

 

5600i54AEB77601EE0725.png

 

Hope that's useful!

 

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings