We are doing a raffle at work, and we want to make sure users aren't submitting list items (their name) over and over again to increase their chances of winning the raffle. We'd like to avoid having this be a manual process if at all possible. I tried using this link as it seemed like a really easy solution, but something with the indexing of the calculated value is causing me to get a technical error (I think, because it doesn't throw an error when I don't force a unique value, and when I don't enforce a unique value it doesn't make me index the field) thrown when trying to save the changes to the column.
I'm envisioning setting up a variable in a workflow, and the variable will be a counter of how many list items are submitted by a user. If the variable is greater than one, delete the list item that is being created. Is this possible to do? Am I over thinking it? I'm open for any solution that is simpler than this - just whatever it takes to restrict a user from spamming submissions.