Preventing form from being submitted if user is already claimed

[lily]

Each user of my app can select what is essentially a username. I’ve gone through posts like this one from 2018, and I understand the concept, but I don’t need the live validation or to store duplicates of each username because they’re always converted to all lowercase before being entered in the database.

I’d like to not allow the user to submit the form if their username matches one in the database. What logic do I need to add to the workflow for this to happen?

[mikeloc]

Hi there, @lily… if I understand your post correctly, the solution should essentially be the same as the one in the linked thread. You can put a condition on the workflow for your submit button that enables the user to submit the form only when a count of users with the same username is 0.

Is that what you are trying to do?

Best…
Mike