Creating Web Mail Platform | AppForms Template

Overview

Template by Syamily K S | December 15, 2015

Webmail are web-based email accounts. These are usually free email accounts that are operated from a website. Webmail allows the users to access their emails as long as they have access to an Internet connection and a web browser. The purpose of this document is to be a reference for any person wishing to implement the Webmail Template using the ClaySys AppForms or any person interested in how to configure the AppForms to create a Webmail Template. Here is an image what the Webmail template dashboard we are going to be designing looks like.

Prerequisite(s)

SharePoint 2010

AddNew

Address Book

Send Button

SaveAsDraft

Compose Mail

Data Structure

SharePoint lists consist of rows and columns that store data in a similar fashion to a traditional relational database management system such as SQL Server. However, a benefit of lists is that SharePoint includes Web Parts that provide simple methods for managing the data. If the data was stored in a database, it would require custom user interface components to access it and manipulate it. Also, specialized skills are required to design, implement, and maintain a custom database. Another advantage of using lists is that custom workflow and event handlers can easily be registered to them. By default the following columns are available in sharepoint list, ID, Title, Modified, Created, Modified By, Created By, Attachments. Apart from these default list columns , user can add more columns depending on the requirement.

SharePoint List
List Name	Column Name	Data Type
WebMailBox It contains the list of mails and mail details like From Address , To Address ,Date etc.	ToAddress	Single line of text
	Subject	Single line of text
	Body	Multiple line of text
	MailStatus	Single line of text
	FromAddress	Single line of text
	Date	Date and Time

SharePoint List
WebMailAddressBook It contains the list of contact Email address and their Uploaded photo.	MailID	Single line of text
FileUploadName	Single line of text

SharePoint List

List Name

Column Name

Data Type

WebMailAddressBook

It contains the list of contact Email address and their Uploaded photo.

MailID

Single line of text

FileUploadName

Single line of text

Design And Configuration

Inbox : Allows you to view the received mails in inbox.
Send Items : Allows you to view the mails you have sent.
Drafts : Allows you to view the mails you have saved as draft.
Compose Mail : Allows you to write a mail. On clicking the Compose mail icon we can compose a mail.
Address Book : On clicking ‘AddressBook’ button, popup will appear in which you can select the recipient address and click ‘OK’ button.The selected recipient address will be added to the ‘To’ address textbox in the compose mail screen.
AddNew : On clicking ‘AddNew’ button, popup will appear in which you can Add a new mail ID to your AddressBook.

List Of Forms Used
Name	Functionality
frmAddNewAddresses Form Design Rule Design	This form is to add new mail ID to the Address book
Address Rule Design	This form is the pop up shown when we click on the Address button in webmail dashboard
MailView Rule Design	This form is designed to show each mail details using label controls
frmMails Rule Design	This form contains a search which shows all the mail items as a list
Compose Mail Rule Design	The screen where a user can write a mail
WebMail Dashboard Form Design Rule Design	The Dashboard displays the details
WebMail MainForm Form Design	The form is used to create a WebMail template

frmAddNewAddresses

frmAddNewAddresses Form Design

Create DataSource

Here are the steps for configuring External DataSource referring to the form ‘frmAddNewAddresses’. Click on ‘DataSources’ and then click on ‘Create DataSource’ as shown in the image.

DataSource Selection

Enter the name for the DataSource, select the ‘DataSource Type’ and click ‘OK’ button as shown in the image.

List Selection

Select the List from the available lists and click ‘Next’ button.

DataSource Command

Select the command as ‘Insert’ or ‘select’ as your requirement and click ‘Add’ button.

Mapping Values

Enter the Command Title and enter the mapping values as shown in the image and click ‘OK’ button.

Finish Button

Click ‘Finish’ button . Thus, a new external data source has been created.

frmAddNewAddresses Rule Design

Rule Name : OnSubmitBtn | Trigger(s) : btnSubmit

Submit Button

Rule for Executing the “Insert” command. And if you want to maintain the fileUpload name you can store it in the hidden control “hdnFupName”.

Rule Name : On_ExecuteComplete | Trigger(s) : Execute Complete

Execute Complete

Only after the successful insertion of mail ID in the list, message box is to be shown and Popup window is to be closed.

Address

Address Rule Design

Rule Name : OnFormLoad | Trigger(s) : FormLoad

FormLoad Rule

FillDataSync(srcAddressBook) is the rule to fill the search control named srcAddressBook.

Rule Name : On_OkBtn | Trigger(s) : btnOK

Ok Button Rule

RunRule(On_srcSddressBook) and value is returned to hidden control “hdnMailTo”. The function to trim “,” at the end of “hdnMailTo” is written. Then value of “hdnMailTo” is passed to the hidden control “hdnMailTo” in the “WebmailDashboard” form. And this popup is closed.

Rule Name : On_CancelBtn | Trigger(s) : btnCancel

Cancel Button Rule

On clicking Cancel button the tab is closed.

Rule Name : On_srcSddressBook | Trigger(s) : RunRule

Loop is written to get the MailID from each row of the search to hidden control “hdnMailTo”. The total row count of the search is initially stored into the variable “VRowCount”. This rule is called from the rule ”On_OkBtn”.

Search Address Book

MailView

MailView Rule Design

Rule Name : Select | Trigger(s) : hdnID

Select Rule

Execute the “Select” command from list and shows the details of a mail.

Rule Name : Send | Trigger(s) : btnSendMail

Send Rule

Functionality for sending mail.

Rule Name : SaveAsDraft | Trigger(s) : btnSave

SaveAsDraft Rule

Functionality for saving mail as draft.

Rule Name : On_hdnStatus | Trigger(s) : hdnStatus

HiddenStatus Rule

Checks whether the mail is a draft. If it is only then the subform containing the send button etc. should be visible.

frmMails

frmMails Rule Design

Rule Name : On_Formload | Trigger(s) : FormLoad

FormLoad Rule

The value of hidden control “hdnStatus” is set to “Recieved”.

Rule Name : FillSearch | Trigger(s) : hdnStatus

FillSearch Rule

On getting value in the “hdnStatus”, the search is to be filled based to the value in the “hdnStatus”.

Rule Name : ValueSet | Trigger(s) : hdnMailID

Value Set Rule

The value in the “hdnMailID” is passed to “hdnMailViewID” in the form “WebmailDashboard”.

Compose Mail

Compose Mail Rule Design

Rule Name : setMailTo | Trigger(s) : hdnCmpMailTo

SetMailTo Rule

Setting the value of hidden control “hdnCmpMailTo” to the textbox “txtTo”. This include the mail ID that we have selected from the Address book.

Rule Name : SendMail | Trigger(s) : btnSendMail

SendMail Rule

Functionality for sending mail.

Rule Name : SaveAsDrafts | Trigger(s) : btnSave

SaveAsDraft

Functionality for saving mail as draft.

WebMail Dashboard

WebMail Dashboard Form Design

External Form Control TreeView Combo Box Image Buttons.

From the ‘Toolbox’ at right side of the window, drag and drop the search control, which comes under the ‘Data’. Enter the name for Search control.

Search DataSource

On clicking the search control, a popup appears click on ‘DataSources’.

New DataSource Configuration

Click on ‘New DataSource Configuration’.

Selecting List

Select the List from the available lists and click ‘Next’ button as shown in the image.

Columns

Select the Result Columns which you want to show in the search and click ‘Next’ button.

Condition

Give the condition for the selection of values in the search as shown in the image and click ‘Next’ button.

Column Header

Here you can specify the column header, width of each column, the order in which each column should appear in search and other similar settings of columns and click ‘Finish’ button.

WebMail Dashboard Rule Design

Rule Name : Trigger(s)

New Rule

Rules in each form are being explained below. Initially to create a rule you need to click on ‘Create Rule’ and enter a name for the new rule.

Rule Name : Trigger(s)

Trigger

Also you can add trigger to the rule by selecting the triggers as shown in the image below.

Rule Name : ComboMail | Trigger(s) : imgbtnWebMail

ComboMail Rule

The visibility of combobox is set to true and “[Select]” is removed from the combobox.

Rule Name : Visiblility | Trigger(s) : cmbWebMail

Visibility Rule

After Selecting a value in the combobox, it should not be seen. So on cmbWebMail trigger, the visibility of combobox is set to false.

Rule Name : On_TreeView | Trigger(s) : hdnSelectedItem

Treeview Rule

On clicking each items on the TreeView, corresponding mails should be loaded in the External form. The external form used is “extMail”. While clicking on the TreeView, the hidden control “hdnSelectedItem” will get the selected item of the tree and using ‘setform’ rule, this value is passed to the hidden control “hdnStatus” in the form “frmMails” in the external form.

Rule Name : On_ComposeBtn | Trigger(s) : imgbtnComposeMail

Compose Mail Rule

On clicking the image button for compose mail, the form “ComposeMail” is loaded in the external form.

Rule Name : ViewMail | Trigger(s) : hdnMailViewID

ViewMail rule

On getting values in the hidden control “hdnMailViewID”, we use the rule to load the form “MailView” in the external form and pass the value of hidden control “hdnID” to the hidden control “hdnMailViewID” in the form “MailView”.

Rule Name : On_Formload | Trigger(s) : FormLoad

FormLoad Rule

On FormLoad, external form is loaded with the form “frmMails” and temporary variable ‘vTemp’ is set to zero.

Rule Name : SelectedItem_Value | Trigger(s) : tvWebMail

SelectedItem Value Rule

On clicking TreeView control, its selected item value is passed to the hidden control “hdnSelectedItem”.

Rule Name : Print | Trigger(s) : imgbtnPrint

Print Rule

To print the page on clicking the image button of print.

Rule Name : SetMailToValue | Trigger(s) : hdnMailTo

SetMailValue Rule

Rule to pass the value from the current form control “hdnMailTo” to the control “txtTo” in “MailView” which is loaded in the external form.

WebMail MainForm

WebMail MainForm Form Design

Creating Folder

On clicking the New Folder option, it will create a new folder and the name will be in the edit mode. You can type in the new name for the folder.

Save Form

Then click on the ‘New Form’ link on the toolbar. Give an appropriate name for the form. Click ‘Save Form’ to save the form.

Check-In Form

You can drag and drop controls, format the styles easily. ‘Check-In Form’ to save the changes and publish to get the completed form for the end user to use. A form must be checked-out to make modifications while all aspects of the form can be examined while checked-in.

Template Summary

This Template allows the users to access their emails as long as they have access to an Internet connection and a web browser. Webmail are web-based email accounts. These are usually free email accounts that are operated from a website.

WEBMAIL