Check if email already exists

[kerenswan]

I am creating a field for sending news from my page to the user who registers his email in the input field. this entry creates in my database called News. What I wanted to do are 2 steps:

1. send registration confirmation email to new users.
2. show a pop-up if the email is already registered in my News table.
   How can I do this? There is no way to create a new account because it would not be a user record but just an email record.

I tried this way:

[tylerboodman]

I actually just responded to someone else with a similar question:

Help with database condition

Well the fact that a database item is in your database means it already exists… So when they go to enroll their email have the condition on that workflow: Do a search for Application Form with the constraint Email = Input's value then do :count is 0 (meaning it looked for entries with that email and found 0). No need for the doesExist field. You would want some feedback for the user though if an email already is registered, so you just need a 2nd workflow on the same button. Right click → Copy…

Yours sounds like it has an extra step needed for verification. Bubble has the build in confirmation system for Users, but you would need to manually have that logic for your News datatype.