InfoPath Form Slow To Load

InfoPath Form Slow To Load

Last week, one of our clients reported that a InfoPath form they are developing is really slow to load. It takes about two minutes to load and then everything works fine. The form and logic were developed by one of their team members (does not want to pay consultant :)).

There were only 1100 items in the data source. They already exhausted XML and SQL data source options with same data set. So, it is now obvious that the issue lies somewhere within the form. But they could not figure it out, hence it came on our plate.

Looks like our friend Google has lot to say regarding this issue and suggested many solutions. Unfortunately, none worked for me. So, I decided to take the time to examine each control and logic one by one (It was a big form). Sure enough, culprit was identified.

What Happened?

One of the page views,

  • Had a repeating table with 3 columns
  • First column contains a drop-down list
  • 2nd and 3rd columns have text box controls
  • Developer assigned default values to 2nd and 3rd column controls. Default values were an defined as InfoPath functions those were dependent on the drop down selection of the first column and that was the issue.
  • Removed default values, published and the form loaded up within second


Explain More

Basically, every time the form was loading, it was trying to set default values for 2nd and 3rd column controls. But as there was no selection in the drop-down, it kept trying to get a value until it timed out.

InfoPath form slow to load can happen for many reasons. Above is just one of those that we experienced. Hope somebody will find this information helpful, some day.


How To Integrate Google Map in Nintex Form

Following steps will guide you to integrate Google map in Nintex form. Google map will be displayed using bootstrap modal dialog with dynamic data.

So, what do we need to make it work?

Make a wild guess!! Yes, you are right. You will need address information, obviously. In my case, I am using Latitude and Longitude data, kept into two different columns in SharePoint List. But you can have both data in a single column seprated by comma. We will use these columns as connected fields later.

List Columns:

  • Latitude
  • Longitude

Note: We will use these column(s) as connected fields later in Nintex form.

Now actual work:

Setup your Nintex form (Flexi Task or regular Nintex form) to work with Google Map. I am integrating Google map in Flexi task Form.

  • Add google map API Link in Flexi task form
    1. Open Flexi Task form and Click on Settings from ribboNintex flexi task form ribbon. Form settings control. Nintex google integration. using bootstrap in nintex
    2. Copy following Google Map JS API link;

     3. Paste this link in Settings > Advanced > Custom JavaScript Includes

How to enable custom javascript in Nintex. using google map in bootstrap modal in Nintex

4. Click OK on the Settings Modal dialog window. You will be back to “Assign Flexi Task” Page


  • Add Latitude and Longitude columns on the form
    1. Find, drag and drop Latitude on the form. You can put it anywhere you want.

how to add SharePoint control in Nintex form?

2. Open Latitude control setting and change settings as show in the screenshot below:

How to make a Nintex control JQuery enabled?    3. Click ‘Save’

4. Repeat step a to c for Longitude list column as well.

  • Now in the Flexi task form:
    1. Drop a ‘Rich Text Control’ on your Flexi Task Form, open control settings and follow the screenshotHow to add custom HTML and JavaScript in Nintex form
    2. Now you should see ‘HTML Editor’ dialog window
    3. In the HTML editor window, paste below code:

<input id=”btnShow” type=”button” value=”Show Maps”/>
<input class=”ImageLinkFormat” type=”button” value=”View Map” />
<div id=”dialog” style=”display: none;”>
<div id=”dvMap” style=”width: 580px; height: 380px;”>   </div>
<script type=”text/javascript”>
/* view map code*/
NWF$(“#btnShow”).click(function ()
var lat = NWF$(‘#’ + Latitude).val();
var long = NWF$(‘#’ + Longitude).val();
modal: true,
title: “Google Map”,
width: 600,
height: 450,
Close: function ()
open: function ()
var mapOptions =
center: new google.maps.LatLng(lat, long),
zoom: 18,
mapTypeId: google.maps.MapTypeId.ROADMAP
var map = new google.maps.Map(NWF$(“#dvMap”)[0], mapOptions);

/* view map code ends*/


NOTE: By default, Nintex forms are JQuery enabled. One catch is you must use NWF$ instead of $.
4. Save and publish Nintex form or workflow.

That’s all. Make sure that you have proper Latitude and Longitude information in SharePoint list columns.

Please feel free to share, like or follow us in social networks.






I have been working with Nintex form and workflow for last one year. Prior to that I have worked with Microsoft InfoPath a lot. Nintex is a great tool. I love the graphical workflow designer. The workflow export and import feature is fabulous. The action items are easily configurable. Workflow action can be copied & pasted (one at a time) within the same workflow.

But, it would be nice to have Cut & Paste functionalities for workflow actions. Imagine you have to move quite a few actions from very bottom to top or vice versa.Currently, you can copy an individual action, paste it to desired position, then go back and delete action from old position.

If copy & paste works, should not cut & paste work?

SQL ‘Data Source Type’ missing from Data configuration Wizard

SQL ‘Data Source Type’ missing from Data configuration Wizard

Today, I sat for coding after a long time. I have started a SharePoint 2013 visual web part project which will perform CRUD operation using Telerik radgrid UI Control. One of the process is to create a data source for the grid using grid control’s smart tag.

Basically, smart tag opens up visual studio’s data configuration wizard and gives you step by step instructions to create data source. But for me, data source type was missing in “Data Source Type” window. I could not find any other way to add SQL data source in this window.

Then I thought to use ‘Data Source’ control from ASP.NET toolbox. I remember using that control in earlier version of VS. But it is missing from toolbox panel as well. Then I decided to manually create it.

Here are the steps:
1) Add or modify your connection string in web.config file as follows:

    <add name=”TestConnectionString” connectionString=”Data Source=SharePoinDev1; Initial Catalog=YourDatabaseName;User ID=sqllogin;Password=loginpassword”

      providerName=”System.Data.SqlClient” />


NOTE: You cannot use windows authentication if you are using the connection string with Telerik grid. You will receive following runtime error:

“This control does not allow connection strings with the following keywords: ‘Integrated Security’, ‘Trusted_Connection’.“

2) In your ASCX page. Paste the following code snippet probably at the bottom:

<asp:SqlDataSource ID=”SqlDataSource1″ ConnectionString=”<%$ ConnectionStrings:TestConnectionString %>” SelectCommand=”SELECT * FROM yourTable” runat=”server”></asp:SqlDataSource>

3) Now sync your design view with code by clicking the yellow notification.




4) Once synced, you should see SQLDataSource control in your design pane




5) Now in code page, reference newly created SQLDataSource id in grid control:

<telerik:RadGrid ID=”RadGrid1″ runat=”server” GroupPanelPosition=”Top” DataSourceID=”SqlDataSource1” AllowFilteringByColumn=”True” AllowPaging=”True” AllowSorting=”True” AutoGenerateDeleteColumn=”True” AutoGenerateEditColumn=”True” Skin=”MetroTouch”>

<GroupingSettings CollapseAllTooltip=”Collapse all groups”></GroupingSettings>

    <MasterTableView DataSourceID=”SqlDataSource1” AllowAutomaticDeletes=”True” AllowAutomaticInserts=”True” AllowAutomaticUpdates=”True”>


6) Sync design and code page (step 3)
7) Now, in design pane, if you select grid smart tag, you should see SQLDataSource1 and you can add or modify SQL data connections using wizard.

Even though, I wrote these steps using SharePoint 2013 visual web part and Visual Studio 2013, this should be valid for any ASP.NET data binding projects in any version of visual studio. Also, for other missing data source type.

Property management – Hassle, but does not have to be!

Property management – Hassle, but does not have to be!

property management software imageResidential property is basically housing establishments either a house or an apartment that people either lease or rent for a specific period of time for purposes of accommodation and/or occupation by a family or a single individual for non-business purposes. Meanwhile the management of such property entails the operation, control and oversight of such establishments. Residential property management is something that home owners who want to lease or rent their houses should really consider. This is to ensure that they reap the maximum returns from their establishments.

Residential property management services are offered by Residential property management Companies. A Residential Management Company performs duties on behalf of the property owner and provides services to the tenants and the property. A home owner or investor employs a property management firm to maintain their real estate so that they do not need to attend to the tenant and property issues and can instead focus on new properties or simply go about their daily life. Such companies are tasked to find suitable candidates for occupancy, check who qualifies best and select the deserving tenant.
They also manage relations with the tenants on issues such as handling contract agreements with the tenants, maintaining accounting records and overseeing legal tasks. They also collect the house rent from the tenant on behalf of the home owner. This saves the home owner the hustle of trying to contact the tenant for rent. That is not all. Being a management company, what they do is to manage the house and/ or apartment on behalf of the home owner.

They act as a point of contact for any issues. This means that whenever the tenants have any maintenance issue, they are the people that will deal with it. Electric faults, sewerage and plumping issues, leaky roofs and water shortages are all issues handled by such management companies. They will also manage the property turn over in between tenants. This ensure that the cash flow to a landlord is in constant supply because when the current tenant puts a notice to vacate, the management company will immediately start looking another tenant to move in.

Proper management of your property ensures that the establishment last long and ensures continued income generation. The process of selecting and qualifying tenants ensures that the occupants of your house and of good character and are of the ability to pay rent on time. This is important so as to ensure that the tenants do not engage in illegal activities in your establishment. An online application like (MiPP) is a great tool that can smooth-en overall property management.

Nintex – Lauching mobile app from hyper-link in external email

Nintex – Lauching mobile app from hyper-link in external email

Yesterday, I was working on to launch Nintex mobile app using hyper-link in an email. I was able to do that by following excellent article by Vahid Taslimi.
Part of the requirement for this project is that users will receive task notification on their personal(non-corporate) email address and should be able to launch the app by clicking link in the task notification.

But, here is the issue I encounter on a Windows Phone:
Receive task notification in a Hotmail email address and able to launch Nintex mobile app on the phone. But as soon as I try to type in password, it started to give
“An error has occurred. Click OK to report this error to Nintex Support”. The annoying part is that the error keeps coming back after clicking OK unless you kill the application.

Further testing:
1) This issue does not appear if user is already signed in the app.
2) Issue only appears when app is launch through link and password field is focused.

Apparently, the issue does not exist for iOS devices. Please share you thoughts if you have experience similar issue.

Nintex – Flexi task branch recreation issue

Nintex – Flexi task branch recreation issue

Issue: Deleted branch from Nintex “Assign Flexi Task” control by following below steps:
– Advanced Options > check “Do not create branches”
– Deleted branch that I do not need.
This caused the control to have no branch and which is expected.

Now, i am trying to add branch by reversing above steps. I am able to add branches in the configuration window but branches do not appear in visual representation.

Save time and cost with Office 365

Save time and cost with Office 365

Make business easier with Aphelion Inc. and Office 365


With the need for greater mobility, agility and better data management increasingly driving the dynamic workplace, SMBs today are learning to appreciate the benefits cloud computing can bring to their businesses.  Yet, some SMBs still struggle to understand exactly what cloud computing can do for them.  Enter Microsoft Office 365, an all-inclusive productivity solution that delivers familiar Office applications coupled with powerful enterprise class communications and collaboration capabilities in a cloud-based subscription service you can easily use.


Give your business a productivity boost with the new Office


Today, you can acquire Office 365 Small Business Premium or Midsize Business through Aphelion Inc., as a standalone solution or bundled with our Online Request Tracker (ORT) cloud application, and no matter which you choose, you’ll still receive the same support and service you’ve come to expect from Aphelion Inc.


Office 365 for SMBs is a completely modernized platform designed to meet your constantly changing business needs. It delivers rich features and cloud service innovation that SMBs are adopting at an accelerated rate.


Benefits include:


  • Letting you take your personal office experience with you – across tablet, PC or phone – wherever you are and whenever you need to get work done.
  • Saving documents to the cloud by default. When you sign into Office 365, you get roaming settings and quick access to your documents in SkyDrive, SkyDrive Pro and SharePoint online.
  • Scheduling a meeting, sending an email, starting an IM, as well as initiating voice and video calls right from your contact list.
  • Easily hosting more effective online meetings, with multiparty HD video conferencing, document sharing and real-time note taking with OneNote.
  • Connecting Lync and Skype services, so you can connect with millions of Skype users right inside of Office 365.
  • An enterprise-grade cloud solution with robust security, guaranteed reliability and compliant with world’s industry standards, including ISO-27001, EU Model clauses, HIPAA and FISMA.


Most importantly, with Microsoft Office 365 you get an always available secure and reliable cloud service from a trusted partner. We manage the billing and support for your subscription service so you have a one stop shop for all your support needs.


For more details on Office 365, check out or email us at



Subscribe To Our Newsletter

Subscribe To Our Newsletter

Join our mailing list to receive the latest news, promotions and updates from Aphelion team.

You have Successfully Subscribed!