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"
I had use the same logic but its not setting the values in the list lookup even after triggering the change on textbox control i.e. hidden textbox in form can you please guide