Skip to main content
Nintex Community Menu Bar

Need to filter a look list control based amount

  • June 21, 2016
  • 3 replies
  • 13 views

Forum|alt.badge.img+10

Hi,

I need to filter a lookup list control based on the amount entered by the user, I need all the items from the list where Amount < the amount entered by the user.

Or is it possible to use JQuery to fill the loopup list

Any help?

Thanks

Sojan

3 replies

Forum|alt.badge.img+1

hi

in control setting-list lookup window is a section named filtering

change "Filter available selections" to "by a control's value"

in "Where field" type the column which you want to set filter on it

in "Filtered by control" select the control which user enters the amount

it's all done to fine!


Forum|alt.badge.img+10
  • Author
  • June 21, 2016

Hi Fateme, how do I put the filter {FieldName} < {txtAmount}


Forum|alt.badge.img+1

oh, you're right! Unfortunately filtering just return equals value and I dont know how solve your problem!

i share your question in my coworkers group, maybe they can help us