Skip to main content
Nintex Community Menu Bar

SQL Request - Display message when no result

  • April 15, 2020
  • 4 replies
  • 19 views

Forum|alt.badge.img+4

Nintex Newbie..

I am populating fields on a Responsive Form based on a tag the user enters with SQL Request. I want to display a message to the user when No Results are returned for the SQL Request. I cannot seem to determine how to do this. 

 

4 replies

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • April 15, 2020
Hi,

I havent tested this but is is possible to use the "Use custom "Please select" text " in the appearance section of the control settings to acheive what you want. You could add an expression in there to say if its Null to use your custom text.

Forum|alt.badge.img+4
  • Author
  • Rookie
  • April 20, 2020
No, I don't have that option on the SQL Request.

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • April 21, 2020

Do you not see this?

7470iD82F5F6E63856268.png


Forum|alt.badge.img+4
  • Author
  • Rookie
  • April 21, 2020
No, probably because I am using Display Format as "Text" not a dropdown.