Hi Everyone, I'm trying to filter a list view control by a calculated value. I found a tutorial (which i have subsequently been unable to find since) which advised that to filter list lookups by calculated values you can run some JS to populate the value to a single line text box and then filter on that control's value. I needed to use a list lookup to select a value, which would then be used to filter a further list lookup which would be used to filter a list view.

So the formula for the first calculated value is

setInitIDHidden(lookup("TblInitiatives","Name",parseLookup(InitiativeName),"_OldID" ))

Based on taking the selected value of the InittiativeName control, parsing it, then using it to lookup the _OldID field in the table. Here is the JS to populate that _OldID value to a single line text box.

function setInitIDHidden(value)

{

NWF$('#'+InitIDHidden).val(value);

NWF$('#'+InitIDHidden).trigger('change');

}

That works fine and it filters the list lookup with no issue. The problem comes when i try to use a similar process to filter a list view control, it sets the form into a recursive loop that stops it from ever loading fully.

Long story short, how can I use a calculated value to filter a list view control?

Thanks

Mish