I would like to check if a duplicate thing exists and was created by a logged in user as a condition on a workflow.
Right now, the only way I came up with was to search for that thing and have a condition in the search that checks if the creator is in the existing list of users, but it’s too time consuming because it will do a search on the number of things multiplied by the number of users, and in my case that could be in the hundreds of thousands of records.
I tried to check if created by is not empty, but it still returns true even for non logged in users.
The ideal way to do it is to search for things where created by’s email is not empty, but I am not sure how to do that in a cheap (fast) way.
Thanks in advance