Hi guys, just need a little help on this one. So i created another datatable for registration emails named “Application Form” - which consists of just 2 data fields: Email and doesExist. Email is obviously for the email input so we can send an email upon registration. The doesExist is a yes/no data type wherein if for example i used email@email.com and decide to use it again, it will be flagged as doesExist = Yes and it will show an error that this email has already been used.
How do i go about adding this Only When condition? Its a little hard as its not Current User data. Do i use “do search for” instead? Thank you in advance!
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/paste the workflow and delete the actions on one of them, then make the condition :count > 0. Meaning it found at least 1 entry with that email already. Then have it show some red text that it’s registered already.
Oh my god thank for that that 2nd workflow! I cant figure out the counter operation for the count is 0. THANK YOU THANK YOU! YOU SAVED ME! I REALLY need to get used to these only when conditions more.
