SQL Request Action - Lookup Error & Workaround

  • 11 October 2016
  • 1 reply
  • 1 view

Badge +7

Hello!

Ok, so I have a Nintex form which uses a Single Line Text box as a parameter to fill a SQL Request lookup.

This works well. You enter the text into the search box, press tab and the dropdown gets populated with your result.

Then, based on the users choice in the dropdown, I had one or more extra SQL Requests going and getting more data relevant to the result. IE for example choosing a user and then going off and getting their office, department, manager etc.

However on doing this I would get the following error on loading the form.

Unable to get property 'toString' of undefined or null reference.



After a fair bit of trial and error, I stumbled upon the following simple workaround.

Rather than using the SQL Dropdown to pass the parameter into the SQL lookup, I created a calculated field looking at the SQL Dropdown field and passed that into the SQL lookup instead. No more error.


1 reply

Userlevel 6
Badge +16

That use to happen me when I refer a variable on some scripting and that variable does no exist

Reply