I have an editable grid (created based on Reza Dorrani's videos) and I need to set up a ranking system. Users enter names into the grid, then rank them. Each rank can only be used once.
I am running into issues with this, because my gallery is filtered so each user only sees their own submissions. I only need to prevent duplicate rankings for the CURRENT session. That is, one supervisor could rank names as 1,2,3 and another supervisor could enter new names and rank then 1,2,3 as well. I am using a SharePoint list as my source, as well as a collection. The collection filters out blanks and items that were not submitted by the current app user.
I have found several solutions on this forum, but they all depend on whether the rank was already used in the SharePoint list. I don't care if the same number is used twice in the Sharepoint list, as long as the same USER doesn't enter it twice for their submissions.

Report
All responses (
Answers (