Skip to main content
Nintex Community Menu Bar

How to set value to a SQL request contorl

  • November 29, 2016
  • 7 replies
  • 28 views

Forum|alt.badge.img+10

Hi All,

Is it possible to set value (default value ) to SQL Request Control?

Thanks

Sojan

7 replies

Forum|alt.badge.img+3
  • April 18, 2017

I am also looking for a solution to this same problem.  I can get the value with

alert(NWF$('#' + javaPlayerName).val())

I cant set the value or get the value for the second item in the list/drop down

alert(NWF$('#' + javaPlayerName).val(2))


Forum|alt.badge.img+10
  • Author
  • April 18, 2017

What is the version of your form


Forum|alt.badge.img+3
  • April 18, 2017

I am using version nintex forms 2013 version 2.9.0.0


Forum|alt.badge.img+10
  • Author
  • April 18, 2017

Try this code

var yourControl = NWF$("#"+ jvarCtl);
var value = yourControl.find("option[title='" + CtlValue + "']").attr("value");
yourControl.val(value);
yourControl.parent().find("input").val(value);
NWF.FormFiller.Functions.ProcessOnChange(yourControl);


Forum|alt.badge.img+3
  • April 18, 2017

what is CtlValue ?


Forum|alt.badge.img+10
  • Author
  • April 18, 2017

The value you want set


Forum|alt.badge.img

Did the solution suggested work for you to set default value to SQL Request control on Nintex Form?