Joining lists to a user without duplicating the list on the user

Need help Database
1

If I am adding a list of one data type (tasks) to another data type (User), how can I set it up so that list can’t be added to that user again? I’m enrolling a user in a group of tasks and I don’t want that group of tasks to be able to be added to the user once it’s already been assigned to them. I have two data types-user/tasks. I’m currently doing a workflow that says when this button is clicked “make changes to current page’s user” / “task - set list search for tasks” / “filter so it associates the group of tasks to the button with that group”

This works but it also just continues to add the group to the user. I just want a way to either throw a flag or stop the workflow from happening if the group is already tied to the user.

2

Depending on the specifics of your use case and current setup, consider one of the following:

  • Add a condition to the button, or the workflow event, or the relevant workflow action so that it runs only if the current user’s tasks list doesn’t contain the list of tasks to be added
  • In the search for tasks include a constraint that excludes tasks in the current user’s tasks list

Regardless, keep in mind that when you add a list to an existing list, items shared between the two lists are not duplicated in the updated list.