Skip to main content
Nintex Community Menu Bar

SQL Request - Display message when no result

  • April 15, 2020
  • 4 replies
  • 23 views
  • Translate All

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
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.
Translate

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

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23

Do you not see this?

7470iD82F5F6E63856268.png

Translate

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