I have a series of tasks that all members of a team have to complete individually.
That series of tasks is stored in DataSource1 and presented to the team in Gallery 1. All users have to complete all tasks in the gallery.
Right now the Items in Gallery1 are just listed as
Items=SortByColumns(cbks_JourneyMapRequirementsList,"ID",Ascending)
Each user selects tasks from Gallery 1, which calls a form that allows the user submit a record of completion to DataSource 2
In DataSource 2 a record gets created with the User Name, Task completed and a TaskCompleted ID that matches the corresponding ID in DataSource 1
Users will complete tasks ar their own pace.
I would like to set up gallery 1 in such a manner that Users only see tasks in it that they still need to complete.
I presume this is a filter [or two] but I am stuck in how to write it
