I have a database for keeping scheduled events. User creates an event and can assign people to the event by creating a registration doc. On the registrationdoc is a drop down list of people, I would like to only show the available people (people not scheduled to an event on the given date). I think I need to use 2 list and strip out the duplicate people in the list.
list1 := “a”:“b”:“c”:“d”:“e”;
list2 := “a”:“b”:“c”;
listDiff := @Trim(@Replace(list1; list2; “”));
In my list1 I have an @dbcolumn that returns all the available people. Where I get lost is how to create the list2? I need all the people that are registered for a given date. On the registrationdoc I have a field StartDate, I need to filter a view based on the StartDate. Any help is greatly appreciated.
I would think you need to have a view that you can use to get a list of people who have already registered and then use a @DbLookup (rather than @DbColumn). You lookup key might depend on such things as Event ID or Date or some combination of those (or even some other data such as location, etc.)
Cesar,Thank you so much. I was having a total Notes brain fade! Your suggestion worked. I have a List1 and List2; List1 is a total return of a view (@dbcolumn(,view1) and List2 is a return passing in a key (@dblookup(,view2;StartDate;2). I then perform the @Trim(@Replace(List1; List2; “”)) to get my good list. Thanks again.