Hi, I have an app that tracks projects with associated line items. Each project has multiple line items and each line item is associated with a user. Projects and line items are separate tables. I want to send users a notification the first time they are assigned a line item in each project not every time. The users are currently being flooded with emails and would like one line item notification per project. Since the users are associated with the line items and not the project, I can't configure the project notifications to include the users.
I tried creating a new database to list the users to the project but I can't get it to self populate. My next thought is to set up a counter that will track how many line items a users has in a project and send a notification when that equals 1 but I am unsure where to start with this. Does anyone have any advice?