I'm working on an activity tracker, users will select the Team (choice of three; AA, BB, CC) and the Type (choice of two; AdHoc or Regular) and i need to use those two values to filter a lookup list of tasks.
For example, this is the list i am trying to get data from, based on team and type fields the user selects i would like to return the third column.
|BB||Regular||Applicability of New Rules|
|CC||Regular||Scope of Permission|
|CC||Regular||Register Metrics Report|
|BB||AdHoc||Meeting set up|
|BB||AdHoc||Formatting (In word or PPT)|
Any help or advice would be highly appreciated.
Solved! Go to Solution.
I assume your helper column in the list is called HelperColumn.
Set your 2 lookup fields "Team" and "Type" in the form.
Add an hidden field called "HiddenField". (Add on rule to hide it anytime).
Add a lookup control to your "tasks" list and set the "Filtering" section as below :
var teamValue = NWF$("#"+TeamControl).find("option:selected").text();
var typeValue = NWF$("#"+TypeControl).find("option:selected").text();
If it worked as expected, you should have this :
Can this be done without the hidden field. As l would have to create the column "Hidden" also what is the control for the column "Hidden" in the form is it a "choice"