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