Skip to main content

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

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!


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


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


Reply