cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
hagarm
Nintex Newbie

Trouble with Nintex Form external data column

Jump to solution

I am having trouble with the Ninex Forms 2013 External Data Column.  I setup my external content type Read List operation with a filter.  I used a filter type of Wildcard, but I'm still not having any luck.  It works when I have the Nintex form external data column control set to 'default' but I get blanks when I select 'Dropdown'.

What I ultimately want to do, I'm not even sure if it's possible.  I'd like to make the external data column be dependent on another field's value.  So in other words, the filter use a the current logged in user to limit the values in a pick list.  Is this even possible?

Thank you in advance for any assistance!

0 Kudos
Reply
8 Replies
gadams
Nintex Newbie

Re: Trouble with Nintex Form external data column

Jump to solution

I use a stored procedure for the read list operation on the external content type.

I have a filter which based on User Profile then Username (or Accountname if you want it DOMAIN\USERNAME format).

In the return parameters the key field which is passed to the read item operation is marked as the system identifier.

The read item operation on the same external content takes an input filter with the same column also marked as the system identifier.

Note that this is reliant on usernames being a field in the database table.

I can get it to work with the external data column control being in default display mode but not in drop down mode.

It does however let me prefilter the results from the external content type based on the user.

Hope this helps.

View solution in original post

Reply
Not applicable

Re: Trouble with Nintex Form external data column

Jump to solution

Can you give a more detailed explanation? I have the same issue. I cannot access the value of the external data column

0 Kudos
Reply
gadams
Nintex Newbie

Re: Trouble with Nintex Form external data column

Jump to solution

Hi Nancy,

I'm battling the same problem.

I'm working on a solution which uses a site workflow using Nintex form for start form.

I can connect the External Data Column control to workflow variable.

However when I try to use a calculated value control, in the formula builder the external data column does not appear in the named controls even when the EDC column does have a name.

I'm trying to see what I can do via javascript.

The other thing is that the EDC control allows for additional fields but I do not know how to access those.

Cheers,

Gavin

0 Kudos
Reply
Not applicable

Re: Trouble with Nintex Form external data column

Jump to solution

I can finally  access the external data column value on the nintex form now, using javascript.

My next step is taking the external column value and do a query on the external lists  that will return the name,hiredate from it and I prepopulate it once the Employee is selected using javascript.

0 Kudos
Reply
Not applicable

Re: Trouble with Nintex Form external data column

Jump to solution

Could you post your working sample JavaScript for the access of external data column value on the Nintex form?

We have the same problem as well.

0 Kudos
Reply
gadams
Nintex Newbie

Re: Trouble with Nintex Form external data column

Jump to solution

Hi Darwin

Code sample

So I have an external control named: edc-StudentUsername

I have 3 single line text box controls:

- slt-StudentPreferredName (Client ID javascript: StudentPreferredNameCalculated)

- slt-StudentID (Client ID javascript: StudentIDCalculated)

- slt-StudentUsername (Client ID javascript: StudentUsernameCalculated2)

In the user profile service there is a custom property StudentID which I populate via user profile sync.

Parent clicks on the select external item button (popup window) for the external data column control.

This retrieves the student username from the database query.

JavaScript then takes the value from the control and uses spservices.

(References in the form settings as a custom javascript include).

Then following javascript is in the form settings:

Hope this helps.

Cheers,

Gavin

NWF$(document).ready(function() {

NWF$("#" + ECTStudentUsername).bind('DOMNodeInserted', function(event) {
 
var studentusername = NWF$(this).find('div').attr('displaytext');

var calControl = NWF$('#' + StudentUsernameCalculated2);
studentusername = studentusername.trim()
calControl.val(studentusername );
var profile = {};    NWF$().SPServices({        operation: "GetUserProfileByName",        async: false,        AccountName: studentusername,        completefunc: function (data, status) {            NWF$(data.responseText).find("PropertyData").each(function (idx, val) {                var $val = NWF$(val);                var name = $val.find("Name").text();                var value = $val.find("Value").text();
                profile[name] = value;              });        }     });

var studentID = profile["StudentID"];
var testcontrol = NWF$('#' + StudentIDCalculated);
testcontrol.val(studentID);

var StudentPreferredName = profile["PreferredName"];
var StudentPreferredNamecontrol =  NWF$('#' + StudentPreferredNameCalculated);
StudentPreferredNamecontrol.val(StudentPreferredName);

});

});

Reply
prashanth_hamse
Nintex Newbie

Re: Trouble with Nintex Form external data column

Jump to solution

I am still battling how to connect external data column (drop down list) with read only list. it shows blank in drop down.

Please share me

0 Kudos
Reply
anna_beck
Nintex Newbie

Re: Trouble with Nintex Form external data column

Jump to solution

I think, this might help you:  

0 Kudos
Reply