Unique usernames - any ideas?

[MM792]

Hi all

Does anyone have any ideas of how to check for a unique username on signup?

I’ve played around and i cant get the options to do what i need to. I have an input field for Username, however when i go to check that this doesnt already exist there doesnt appear to be a sensible option for me to choose

I imagine this should be pretty basic so not sure what i’m missing exactly!

Thanks

[pford]

If you create a signup form from scratch, you can choose what type of signup/login you want the users to use - either username or email. If you select username it will check to make sure that username is not already taken. Is that what you mean?

[MM792]

Hi,

Yes this is what i was after. I currently check against the email being unique, i’ll have a play with what you’ve mentioned above

Thanks!

[MM792]

Hi

I’ve had a think and we need the email to be unique, so the additional check i’m looking for is a manual check of a username entered by someone.

I tried to do this via checking the text input that they enter for their username against the list of existing users but i can’t specifically select the options to;

Check ‘Username text input’ with ‘Existing usernames in the DB’

Thanks

[Victor]

Hi @MM792,

May be this could be useful for you?

Adalo hints: how to prevent from creating duplicate records in the collection (UPDATED with 2nd video)

Sometimes one needs to be sure that the value of the property in collection is unique for each record. As an example - you need to be sure that name of the company / restaurant / event / etc. is unique and record with this name can’t be added for the 2nd time. UPDATE: added a second video how to make a modal window with warnings. Thanks for your comments inspiring that! UPDATE #2: please note, the check is case sensitive; so “UGC ODEON” and “ugc odeon” will be treated as different entries. He…

And this as well:

Help with unique id

can someone show me with a video how to create a random number that is not repeated for the user id?

Best,
Victor

[MM792]

Hi Victor

I’ve taken a look at your youtube video and that’s great. However, the check appears to not work if the upper/lower casing of the letters are different though which is i assume just because of the way in which Adalo compares the strings?

Image 1 - showing a username exactly the same as an existing user - works great

Image 2 - showing a username matching another user but with an uppercase E instead -

[Victor]

Hi @MM792,

Good point, thanks. Seems that the check is case-sensitive. Unfortunately I don’t have any solution at hand…
My question would be - what general problem are you trying to solve? Why emails don’t work (they are checked for uniqueness on Adalo level)?
May be if you could explain a bit, someone from the community can come with a whole another solution

Best,
Victor

[Victor]

Quick update: as an idea - you can set Input field to “lowercase”, this should prevent users from creating usernames with capital letters

[MM792]

Ah yes this is what i was just trying to do but couldn’t find it under ‘Edit Styles’

I spotted that it could be set under ‘Type’ though so i’ll give this a go as this would be fine for us.

Many thanks!

[MM792]

@anon78309838 - do you think this is something which needs changing?

I’m also adding in an option for the user to change their email address but the check of the two examples below says that they’re not the same… seems odd to me personally

seller@adalo.com
Seller@adalo.com

Thanks!

[anon78309838]

It is case sensitive as with most programming this is usually the case (no pun intended).

We have the option to switch between case sensitive and case-insensitive on our backlog but I cannot give you any timeframe when that would be implemented.