Validating User Email Address

6 minutes to read

If you have an app that allows users to create their own user profiles, you may want to consider adding email validation. When a user submits an email address via a registration Web Form, your app can send an acknowledgement email with a personalized validation hyperlink. The end-user must go to their email account and click on that hyperlink to activate their profile. This way you are certain that you have a valid email address for that user. 

Steps:

  1. Prepare your authentication table and filtered authentication view. 
    1. Create or modify an authentication table and add a new verification field. In this example, this verification field is named Email_Verified. Select Yes/No as the data type. 
    2. To create the hyperlink that will be sent to your end-user’s email account, add another field. This field will hold a GUID or Globally Unique Identifier. This GUID will be automatically generated by the registration Web Form, and will be used by the validation Update Form to locate the end-user’s profile record. Set the data type to Text(255) and mark the field as Unique. 
    3. Save the changes. 
Validate_1.png
 
  1. Base your Web User Authentication on a filtered view of your authentication table.
      1. Navigate to the Views listing and click New View.
      2. Name your view and select your authentication table and move it to the right-hand panel using the arrow button.
      3. In the Fields panel locate and select your Yes/No verification field (In this example, it is Email_Verified). Check Filter data by this field and check the Value checkbox.
      4. Save your view.

    Now, this view will only include records where the email address has been marked as verified. Use this view as your authentication table to implement Web User Authentication.

Validate_2.png
  1. Create an Update Form to find and validate the user’s record. 
    1. Create the Single Record Update Form. 
    2. On the DataPage Data Source screen, select the authentication table as the base table (data source) for this DataPage.
    3. To locate the user’s record, you are going to receive a GUID value from a query string parameter in the URL. Select your GUID field from the Unique ID field dropdown. Change the parameter name to match the fieldname of your GUID field. Be sure to remember this parameter fieldname (GUID) as it will be needed later when you create the hyperlink in the acknowledgment email. 
  1. Configure the Update Form to change the verification field value to “Yes”.
    1. In the Select Fields screen select your verification field (in this example “Email_Verified”) and move it to the right-hand panel using the arrow button.
    2. From the Form element dropdown field, select Hidden.
    3. Make sure the default value checkbox is checked.
    4. This verification field value is automatically set to “Yes”.
      5. Now when your end-user submits the form, their profile will be activated.
  1. Optional: Add an auto-submit JavaScript.
    2. If you would like the validation Update Form to submit itself automatically you can add a line of JavaScript to an HTML block in the DataPage.
    1. Click the Insert button at the lower right-hand corner of the DataPage Elements panel and add HTML Block.
    2. Copy and paste the JavaScript provided at the end of this article into the HTML Block panel.
  1. Redirect the end-user after verification.
    2. On the Destination and Emails screen of the DataPage wizard, choose a destination page. In this example, after the Update Form has been submitted the end-user is directed to a confirmation web page. Save your DataPage.
  1. Deploy the Update Form to a web page and note the URL. It will be used in the next step to create the hyperlink contained in the acknowledgment email.
  1. Create a registration Web Form with an email hyperlink.
    1. Create a Submission Form. 
    2. Select your authentication table as a base table (data source). 
    3. Proceed to the Select Fields screen add the email field and the GUID field to the included fields. 
    4. In the Configure Fields screen, select your email field. 
    5. Select Email from the Form element dropdown field. 
  1. Configure the GUID field to automatically create a GUID value.
    1. Select your GUID field from the DataPage Elements panel. 
    2. Select AutoValue from the Form elements dropdown field. 
    3. From the AutoValue Type dropdown field, select Random Unique ID. 
    4. From the Format dropdown field select For Application Use. This will automatically fill your GUID field with a 128-bit Globally Unique Identifier. 
Validate_5.png
    1. On the Destination and Emails screen of the DataPage wizard, configure your destination page options. In this example we changed the display message to alert the end-user that they will need to check their email to complete their registration. 
  1. On the Destination and Emails screen > Automatic Email Options, click on Acknowledgment email to email address submitted in form, and select your authentication table’s email field from the dropdown field. Configure the acknowledgment email to link to the validation Update Form’s host web page.
    1. Select a valid sender email address from a dropdown list. 
    2. Enter a subject in the subject field to indicate that action is still required from your end-user. 
    3. Select HTML from the Email format dropdown field on the bottom of the screen. 
    4. Write a message in the message panel using HTML. For example: 
      • From: noreply@bayarealandmark.com 
      • Subject: Please activate your profile 
      • Message body: 
    1. Create a hyperlink to the validation Update Form host web page. Write out an HTML hyperlink to the URL of the host the web page. You can copy the HTML hyperlink syntax from the bottom of this article. Be sure to change the URL in the sample to your validation Update Form web page URL. Next, add the user’s GUID to the URL as a query string parameter. 
      • After the URL add a question mark (?). 
      • Type the parameter name of your GUID field followed by an equal sign (GUID=). 
      • Select your GUID field in the Insert fields dropdown field. 
      • Click the Insert button. 
      • Close the quotation marks and the tag. Make sure that the entire URL including the query string is contained in quotation marks. The format of the hyperlink must use the following format:
  1. Deploy and test your application.
    Now you can deploy your registration Web Form to your web page. Test the system by registering. Be sure to check your Junk Mail folder for the acknowledgment email. It is a good idea to suggest your end-users do the same. Click on the hyperlink in the acknowledgment email. Verify the authentication view to be sure your profile has been validated. Now you can be sure that you have a valid email address for each new end-user profile. If you have existing end-user profiles, you may want to mark them as already validated.
code1
<h4 style="text-align:left">
<p>Thank you for registering.</p>
</h4>
<div id="thumbsup" style="text-align:left">
<img src="http://www.bayarealandmark.com/thumbsup.jpg" style="height:131px;width:150px">
</div>
<br>
<br>
<p><a href="http://www.bayarealandmark.com?GUID=[@field:GUID]">Click here</a> to activate your profile.</p></br>
code2
<a href="http:URL?GUID=[@field:GUID]">Some text</a>
Caspio Logo

Caspio is the world’s leading cloud platform for building online database applications without coding. Start a free trial today and experience the power of no-code.

Footer Partners

© 2024 Caspio, Inc. Sunnyvale, California. All rights reserved.