This is probably simple but can’t figure it out. I want to make a dropdown from a list without already used values, the first list is the base list and the second is the result of a search which has already used values from the first. I thought filter would be right but it doesn’t seem to filter lists with lists. Example, list 1 is all elements, list 2 is used, result is what I want to display. this will be a unique list for every user so needs to have different filtering each time. Thanks!
so if I understand correctly your result is list 1- (list 1 intersect with list 2) ?
So you want to calculate this for every user if they press a button and save it to their list of things?
A tiny bit different. I don’t see the value of the list1:intersect list2 function as that would just be the same as list2.
Using the example lists I have here. Say kids in a school have to create one (and only one) report for each subject in list 1 - list 1 is the master list that all students must complete. When they create a report the subject is recorded in list 2 (student unique). The “result” list are all the incomplete reports unique to that student. The students can complete the reports in any order. I want the result list to appear as a dropdown.
Basically what I want to do is something like this “List1:minus list2” as my dropdown choice source (if :minus could be used for lists).
Have you tried an Advanced filter? If I’ve understood you correctly, you should be able to do something like List 1 > filtered > Advanced: List 2 doesn’t contain This Subject, similar to:
Doesn’t this only return Yes or No? @paul.dalpozzo wants a list returned.
So if you have a data type of Student that has a field of List of Subjects Completed then your result would be Do Search for Subject filtered Subject isn’t in Current Student’s List of Subject’s Completed?