Emily Billing - Is there an example of this somewhere that doesn't rely on another drop down (Non-cascading)?
I want to pull a list of items based on another list based on the user logged in. I want it to display a set of column fields based on the user logged in if the user's name appears in another list.
For example:
User George is on 3 of 8 lines on List A:
Alpha George Larry
Bravo Larry Ben
Charlie Larry George
Delta George Ben
Echo Larry Ben
Foxtrot Ben Larry
Golf Ben Larry
Hotel Larry Ben
What I want it to do is display the items in the dropdown when George is logged in because George's name appears in one or more of the sub columns. The valid entries based on the data above should be the following:
Alpha
Charlie
Delta
Whenever I'm in List B's form I tied the list lookup "Source list" to List A and it will display ALL items with no problem. I select "By a specified value" in the "filter available selections". When I attempt to add the conditional filtering in the "where" field, I only see the columns for List B and not List A. I would expect that the source being from List A that list B wouldn't apply but instead I only see the column names for List B in the insert reference page when I click the "book" icon at the end of the where field. I have "current user" selected for the filtered by value. I figure that's probably the best result of what I want for there, but I basically want the first column info populated when the logged in user appears in either column B or C but I cannot seem to get the column names to populate in this control to select them.
I am not using O365, we are using the trial version of Nintex forms 2013 on sharepoint 2013.
Please advise what I'm doing wrong here. Thanks.
