Can i eliminate duplicate items which have the same (Title & Created-by) from the list view Count

Question

I am working on a custom list inside our SharePoint on-premises 2013. i created the custom list to store the users who access a discussion board items, by following this approach:-

1- Inside the discussion board's flat.aspx page, i entered the following javascript which will add a new item inside the cusotm list, by passing the item title as follow:-

2- then i am interested in knowing the number of users who accessed a specific discussion board item. so inside my list view i chose to do the follow 2 settings:-

• group the item by title
• show the count

As follow:-

3- so my list view will show the item title + the number of users who accessed the item, as follow:-

but the only issue i am facing with the above appraoch, is that when the same user access the same discussion board item, 2 items will be added inside the custom list, and the 2 items will have the same title & created by.

but i want the counter which is shown beside the title inside my list view, to NOT count any duplicate items. where duplicates in my case, is any item inside the cusotm list which have the same Created-by & title. so is this something i can achieve ?

Answer 1

Instead of creating an item every time, add a field to count the number of times a given user has visited it. Then each time they visit it, increment that counter by 1.

Essentially, when the flat.aspx opens, perform a query to see if the current user has already visited it (store their unique id or something in the record itself), and if so update the count. If not, create a new record with count = 1.