How to us UI Builder to confirm if a user is already registered as a user?

UI Builder
1

Hi,
Please advise on how to confirm if a ‘email’ has alreday been registered.

2

Hi @Paul_HIllen,

could you please provide me with more info on what do you want to do?

3

Hi Stanislaw,
Users with an ‘admin’ role within a business can ‘invite’ new users to join the team. The new user is sent an email with a unique code which on registering assigns specific user roles.
However, sometimes an existing user maybe sent a new ‘invite’ if their role within the business has changed. In this instance I want to direct them to short ‘sign-in’ flow rather than ‘new-registration’.

4

You can run a count query to the Users table with the following where-clause:
email = 'existing@email.com'

and if the result will be not 0, then such a user already exists.
Is this works for you?

5

Thanks, I was looking at the “user API’ / 'Find user by” block and couldn’t understand how it was used, but your soloution works.
All the best.

6

Hi Stanislaw,
I’m having problems creating a count query with UI Blocks.
could you expand on the blocks required please?

7

Hi Paul,

Please create a new topic for new questions. This will help both us to stay on topic and others find relevant answers and solutions.

Regards,
Mark