I’ve been trying to make a working system for this and I have read pretty much every forum post on this topic, but I haven’t found a full solution for this system. Maybe I’m overlooking something, I’m fairly new to bubble.
So I have a field where users can change their username, and I want to make sure:
- Usernames are unique (So if username “John” is taken, no one can take “john” as a username)
- Can only contain letters a-z, numbers 0-9, and underscores (_).
- Usernames are stored case sensitive
I thought I could take usernames from the database and temporarily turn it to uppercase and compare it to the input’s value which is also temporarily turned uppercase. But I can’t seem to do that with the database text. As for limiting characters to only those types, I’m unsure how to go about it.
How do I go about doing this?