Import Field Mapping now available in iFreeTools CRM / Creator

iFreeTools CRM - the free CRM built over Google App Engine, for use with Google Apps - now supports import field mapping.

Now you can map fields from CSV files imported from other sources by providing the field mapping in an easy to use interface, instead of having to manually mapping them in the CSV file. The source can be address book from Outlook or from Google Contacts exported as CSV, or even from your old CRM/database system.

Such field mapping can be saved and reused multiple times.

To enable this mapping, the import process will now contain 2 steps. First one will be similar to the one which we had earlier, where you could provide the CSV file to be imported..


The next step will be to provide the mapping. By default, the app will try to match the fields in the CSV with the property in iFreeTools record. The unmapped fields will be highlighted as shown below..



You may now provide the mapping for all fields which you want to import into iFreeTools. You could even map multiple fields from CSV to a single field in iFreeTools. The multiple values will be joined together and stored in the property.


You can view the reverse mapping to see if you have covered all important mapping.


In CRM, if the records require an "owner" property, it will be set to the user who performs the import operation. You could later use the Bulk Edit feature to reassign owners as required.

You could also provide a name for the import field mapping, so that you could just select it from the selection box the next time you need to import a similar CSV file.

This feature is also available for custom database apps created using iFreeTools Creator.

Feature Preview : Email Templates and Bulk Emails

We are now working on have rolled in a new feature for iFreeTools, which is Email Templates and Bulk Emails.

Email Templates enable you to automate mailing work by allowing you to define templates, which can include fields from the records and then to send out mails with their values replaced (mail-merge).

This new feature will now be supported for records which have an Email attribute.

For iFreeTools CRM, this will include Lead, Contact, Vendor and Case records.

And, for iFreeTools Creator - where one can create their own custom database application online - String attributes can now be marked as email and will automatically get this feature enabled for those Entities.

The following screen-shot image shows Owner's Email ID property, from the sample app used in our walk-through for using iFreeTools Creator, being marked as an Email Property. The transform function is also used to trim the values to remove spaces and convert it to lower-case.

Similarly, we can also mark the Tenant's Email ID property.

Once this is marked, a new action button will become available in the list views. For the CRM app, as mentioned earlier, this has been pre-configured for Leads, Contacts, Vendors and Cases.

In the above view, the option is disabled, because no records have been selected.

Let us select a few records to proceed to check out how this feature would work. Shown below are 3 record selected before triggering Send Email


The default view will be as given below. Since this is a preview release of the feature, the message on the top informs you that Notification Tasks will alone be added in Preview status - which means actual emails will not be sent, for now.

You will have an option to just send an email once or to save the template providing the name, description, type of email and sharing options. Admin users can create templates for themselves or for all users, like it is possible with our Custom Views and Custom Actions.

We will now proceed to create a Welcome Email template, and make it available for all users. One can include fields from the records, which are listed on the left on the content box and can be clicked to be inserted into the contents. You can also use BBCode. The supported BBCode tags are : b, i, u, s (strike), url, quote, img, list with *, size, color, center, code and p.

Fields are supported within mail subject too, as shown in the screen-shot below..


Proceeding to send email, you will see a page as shown below. Notice the message on the top, that the email template has been added. The notification tasks will be added sequentially for each of the record instances.


Let us now check for the results.

Clicking on the Notification Templates, we find the template listed..


Proceeding to the Notification Tasks view, we find 3 records present with status as Preview. Also notice how the values have been replaced with actual values from Owner records.


And, this is one of the Notification Task's details view..


Notice that I had done a mistake in my template code by providing HTML instead of BBCode for the content "Personal Executive" - happens when switching between writing a blog post and the app, taking screen shots :-). Anyway, we can edit the template to correct this, which we will be doing now while explaining another important feature, which is Automatic Dupe Detection for Bulk-Emails.

To explain how Automatic Dupe Detection for Bulk-Emails works, we will again trigger the Send Email from the Owners list view with all the records selected and proceed to the email-template view as given below. Now, select the template from the selection box and click on Modify and Save options next to that box. Edit the content as required and then proceed.


In the subsequent page, we will see the results for the notification tasks being added, as shown below. The engine will detect dupe emails based on the notification identifier, which for now is taken to be the subject of the email. So, notification tasks will be added only for those records which have not already been mailed with the same subject.


This is a preview release of the Email Templates and Bulk Emails feature. When this is fully enabled, the tasks would have triggered emails and end up with status as Executed.

(Update : Bulk emails feature has been fully enabled for all paid, single-tenant deployments.)

For each of the notified users, a record will be added in Notified Users, under Admin. This will be used to enable users to opt-out of notifications, if they prefer to do so - confirming to CAN-SPAM regulations for Promotional emails.

We plan to integrate with SMS gateways too, which will follow the similar flow, except that the Subject will be ignored and the Content will have to be short.

(Update : Bulk SMS from your online database has also been enabled, by integrating iFreeTools with Twilio.)

Play around with our iFreeTools and let us know your feedback on how we can make things better.

Support for Unique Field Constraints in iFreeTools

Though Google App Engine does not yet support modifiable unique fields, we believe that this is an important requirement for many business apps. So, we have added this feature in our framework layer over Google App Engine to enable unique fields in our Free CRM for Google Apps Engine and in our online database app-builder for Google App Engine.

This feature has been turned on for the email-id fields in iFreeTools CRM - for Lead, Vendor, Contact and User records. The value entered for these fields will be trimmed to remove spaces and converted to lower case, before a unique constraint check is performed, when adding or modifying records.

We will see how this feature can be used in a custom application over iFreeTools Creator. Vehicle registration details in one case where unique values are to be stored for each of the vehicle records. You do not want a duplicate entry to be entered inadvertently into your database. So for the this field, we will enable the Unique constraint and also use the transformation functions trim and upper.


Now, we will proceed to add a record with a duplicate value for this unique field. Notice how the value is given in a lower case and with additional spaces prefixed and suffixed..


When trying to save this record, we will be shown the error message as given in the image below. You will also find that the value has been trimmed and turned to upper-case..


The unique constraints are also enforced during bulk import of data from CSV.

Hope you find the feature useful. Feel free to send in your feedback.

Export / Import Data as CSV & Bulk Delete in iFreeTools CRM and Creator

A new upgrade to our Google App Engine powered CRM application and Online Database App-creator, has added support for Exporting and Importing data in CSV format, along with support for bulk-delete.

Exporting and Importing of data as CSV enables you to

• store a backup of your data
  
• import new data in bulk
  
• restore back old-data at a later date, if required, from the back-up
  
• take away your data at any time from our database - No vendor locks.

In this blog post, we will have an overview of this new feature, as used in iFreeTools Creator, the approach will be similar in iFreeTools CRM too.

In the default list views, there will now be an option under More Actions to Export as CSV and Import from CSV as shown below..


First export the data as a CSV file and store it locally. This file acts as a backup of the existing data and can also be used as a template to add new data.

You can use any spreadsheet application which supports editing of CSV files. We will use Google Docs for this feature preview. Use the upload option to upload the CSV file to Google Docs..


The spreadsheet will be loaded and will show the entries as present in the iFreeTools database..


We can now add / modify entries in the spreadsheet. We will add 2 new records - of which 1 record will have values in unicode (Tamil language) and update the existing records by adding some notes. The changes made to the spreadsheet are highlighted in the image below..


Now download the modified file from Google Docs, by choosing from the menu File > Download as > CSV (current sheet). Now you can upload the file to iFreeTools. Choose the Import from CSV option and specify the file downloaded from Google Docs and click on Import..


This will import the data into iFreeTools' database, as shown below..

Notice that 2 new entries have been added, with proper handling for unicode characters and that 3 existing records have been updated with notes. The status message on top also provides the details of the import.

Further changes to the imported data can be performed using the Bulk Edit feature, which was added recently.

This update also includes the Bulk Delete option, available under More Actions.

Hope you like our new features. If you face any issues or have suggestions, feel free to use the feedback form in our application.

Custom Actions now supported in Google App Engine powered iFreeTools CRM and Creator

When we added the Bulk Edit feature recently to our Google App Engine powered CRM and our Online Application Builder for App Engine, we had mentioned that we were to make "Custom Actions" available next.

And with today's upgrade, it is now available.

When performing bulk operations, you will now have an option to provide a name for the bulk-edit operation. For admin users one can additionally specify if the Custom Action needs to be available for all users or just for you. In the sample screen-shot below, we are adding a Rented-out custom action, which sets Vacant property as False (unchecked in form)..

And after this proceed with the bulk-edit operation as usual. This will apply the bulk-edit changes and also create a custom action which will be available under More Actions, as shown below.. In the screen-shot the bulk-action buttons (Bulk Edit and Rented-out) will remain disabled, until one or more rows are selected.

You can get to know more details of the Custom Actions by clicking on Action Details. This will list the details of the accessibility of the Custom Action, along with details on the attributes that get changed by the action and if you have the privileges, an option to delete the action, as shown in the image below..

While one can also provide the same custom action name in the bulk-edit form to update an existing custom action, it is just as easy to just delete the action and add it again.

Hope you like the new feature. Feel free to send in your feedback.

Bulk Edit feature now available in the Free CRM for Google App Engine

Our recent upgrade now enables Bulk-Edit feature in our Google App Engine powered Free CRM and Free Online Database Application Builder apps.

While many could have used such features in other apps, just giving an overview of the feature for those who may be new to the feature.

From the list views, select one or more records and then click on the "Bulk Edit" button.


This will bring up the bulk-edit form. In this all the form input elements will be disabled by default. You may enable the form elements for attributes to be modified by selecting appropriate check-boxes and then proceed to enter the values for those attributes. Once you have updated the required fields with values, click on Save.


This will update the previously selected record instances with new values, changing values for those attributes enabled in the form. Other disabled attributes will remain unchanged. (The modified records, with the changed value for owner, are shown highlighted in the following view..)


Coming up next will be options to create "Custom Actions", using which frequent edit operations can be saved as a Custom Action and invoked with a single click, instead of filling in forms again and again.

Easy Visualization of Data with Auto-Charts in iFreeTools CRM & Creator

Automatic Chart View options are now available for all views -- pre-defined views, as well as Custom Views -- in our free CRM and app-creator for Google App Engine.

iFreeTools will automatically detect attributes which can be used to group data together and enable auto-charting options for those attributes, as shown below..



This feature is added to our core engine layer and hence available to both iFreeTools CRM and iFreeTools Creator applications. The following screen shot shows charting options in the Property Management application, we had built in our walk-through for iFreeTools Creator..



Current aggregation operation used is count - count of records, grouped by another attribute. We will soon be supporting other options like sum, which will be more useful when we introduce currency data-types.

Go ahead and check out our auto-charting feature available in..

• Free CRM for Google App Engine and
• Customizable Application Builder for Google App Engine.

and let us know your feedback.

iFreeTools in The 451 Group's report on SaaS M&A

iFreeTools gets a mention in Sector IQ report titled "Buying in the cloud: Where SaaS players and others may look to make M&A moves for apps", by China Martens, dated 14 Jan 2010.

This report is filed under the sectors..

• Application software / Customer relationship management
  
• Application software / Enterprise resource planning

(click to view larger image)

Glad about being part of that report.

Not sure about the exact context or quote, but I think I can guess - based on the title. (Hint: iFreeTools will not acquire any of those companies, listed along with it.)

Support for Custom Views in iFreeTools

iFreeTools CRM just got an update with the new Custom Views feature.

Note : Ability to create Custom Views has also be enabled in iFreeTools Creator, our online database app builder for Google Apps. If you do not see this option when viewing the records for your custom entity, kindly verify if you have selected the Allow Custom Views option for that entity.

Clicking on the Add Custom View link available under each module of CRM, will bring up a form wherein one can provide the view name, description and the criteria to be used for filtering.

For example, to view all leads who have not been contacted yet, one can create a "Not Contacted" view as shown below..




Once the view is created, it will be listed along with the predefined views in the module..


One can also provide multiple values for the criteria.

For example, to view all Open Leads by specific owners (say, for users "Gold" and "Diamond"), one can create a view as shown below (notice multiple values in OR for Lead Owner and Lead Status)..


The resulting view will use all values in the criteria to provide the results..


Such Custom Views will be available for use by all users within the application instance, while admin users alone can create/modify/delete Custom Views.

Currently properties with choices and reference properties alone can be used in providing the filter criteria. For other filtering one can use the search within the Advanced Views, for now. We will be coming up with more options for filtering at a later upgrade.

Check out the new feature and feel free to send us your feedback.

Related Blog Posts : 

• Custom Views now support Template Criteria for User References and Date/DateTime fields

Instant Search now available in iFreeTools CRM

We told you search was "Coming soon.." when we introduced Advanced Views late last week and now, it has arrived in iFreeTools CRM.

This comes a day after Instant Details and Customizable Columns were added to Advanced Views.

Advanced Views now have a "search as you type" feature, shown in action below..

The search string is matched against values from all the columns in table view. If you want to include a property for the search, just add it as a column of the table and proceed to search.

Advanced Views is Javascript powered and works best in modern browsers like Chrome and Firefox - which we use extensively for our testing. While it does work in IE (it can be a bit slow), we recommend better browsers.

There is also an option to disable "Search while typing", which makes search operations to begin only after clicking on the Search button. This can be useful when using browsers like IE.

Keep sending in your feedback on Google App Engine powered iFreeTools CRM. We listen, and more importantly we act and we deliver - fast.

Instant Details and Customizable Columns now available in Advanced Views

Another upgrade and iFreeTools CRM now has support for Instant Details and Customizable Columns in the Advanced Views. This comes soon after the initial support for Sorting and Faster Paging (Next/Previous), added late last week.

With today's upgrade, Advanced View has been made the default list view. If required, one can always switch back to Simple View and the browser will remember your preference the next time list views are loaded.

Within the Advanced View, one can now view the details of the records instantly by clicking on the row in the table.

When the view loads, you will see something like..


Now click on any row in the table to load the details..


Notice how the visible columns are marked with a star image. You could click on the star (or the property name) to toggle the visibility of the property in the table view.

For example, when you want to remove the Salutation and First Name and instead add Lead Source and Lead Industry, click on the relevant property names in the details view and see the changes getting reflected in the table view..


Once the property becomes a column in the table, it can then be used for sorting. Options to save the view settings either for self or as default settings to all users will be available soon.

The usual details view is still available, where you can also view the lists of related records.

We would be glad to hear from you on what you would like to see in our Google App Engine powered iFreeTools CRM. Check out the features and feel free to send in your feedback.

Sorting and Faster Paging (Next/Previous) with Advanced Views

Not being able to sort the data, was one of the pain points expressed by some of our users. So we got working on a quick feature to support sorting of data in the views, while also enabling faster paging.

These features are now available as "Advanced Views" in the Google App Engine powered iFreeTools CRM.



It is recommended to use Chrome or Firefox (with firebug disabled), to experience this feature.

Currently "Advanced Views" is not the default view, as it is still a work in progress. Other upcoming features in the Advanced Views include selectable columns and search.

So, what is your pain point ? What would you like to see soon in iFreeTools CRM ?

Let us know - you can use the feedback form in the application or send a mail to raj@sahasvat.com. We listen, and more importantly, we act and we deliver.

Sales Opportunities Pipeline (Funnel Chart) is now available in iFreeTools CRM

Sales Opportunities Pipeline (Funnel Chart) which was in the works, is now available as part of iFreeTools CRM.



This comes after our initial support for charts added in the Leads module.

As an additional option, we have also included a horizontal-bar-chart in all chart views.

Apart from the Sales Opportunities Pipeline, two more chart views have also been introduced in the Opportunities module, which are Open Opportunities By Source and Open Opportunities By Owner. These charts show the opportunity amount (or potential) aggregated based on source/owner, displayable in Horizontal/Vertical Bar charts or in Pie charts.

We would love to hear your feedback on the application.

Support for charts was actually taken up earlier than planned, after users got in touch with us requesting for the same. Go ahead and check out the CRM built for Google App Engine / Google Apps and let us know what you would like to see soon in this application. You can use the feedback form in the application or send a mail to raj@sahasvat.com.

CRM for App Engine adds Charts

iFreeTools CRM, the CRM built for Google App Engine (and hence for Google Apps), just had an upgrade which adds support for charts in the hosted CRM application.

This first step towards broader reporting features in iFreeTools CRM, begins with charts added to the Leads Module.

Now, under Open Leads, the following chart views have been added..

• Open Leads
  
  • By Status
    
  • By Source
    
  • By Industry
    
  • By Owner

Each chart view has an option to view the summary in either bar-chart format (loaded by default) or a pie-chart format.



Note : In case you are using Firefox, make sure Firebug is disabled when using these charts as Firebug is known to slow down this charting feature.

Send in your feedback on what charts you would like to have as part of the application and we would add them in subsequent upgrades.

Within this short duration of less than month, iFreeTools CRM (alpha) has attracted a lot of users from across the world. They like the pace at which features are getting added and the personalized support. A few of them have already rebranded and mapped the application to their Google Apps domain.

So, go ahead start using the application and feel free to send in your feedback on what you would like to see soon in iFreeTools CRM.

Related Posts :

What's Cooking : Sales Opportunities Funnel Chart

Sales Opportunities Pipeline (Funnel Chart) is now available in iFreeTools CRM

Task Management module added to iFreeTools CRM

Google App Engine powered iFreeTools has added support for managing Tasks in its hosted CRM service.

Now users can add Tasks and associate them to other CRM records which can be Lead, Account, Contact, Opportunity, Case, Campaign, Vendor and Product.


A set of pre-defined views have also been provided for the Tasks module..

• My Pending Tasks
  
• All Pending Tasks
  
• Past Due
  
• Due Today
  
• Due Tomorrow
  
• Completed

Check out the new module and as always, keep sending in your feedback on the Free CRM for Google Apps.

Add Logo to your Rebranded CRM

As part of rebranding iFreeTools CRM, you may now provide the URL for your logo, to be displayed in the header of the CRM application. The URL can directly point to the logo on your website - example : http://www.mydomain.com/static/images/logo.png . Uploading images to iFreeTools is not supported, for now.

To help your logo blend with the application, you may choose a header out of "default", "cloud" or "full-white", so as to match your logo better. Transparent PNG logos are also supported.

The following samples show the use of a transparent PNG logo, used for rebranding with the 3 different headers..

With "default" Header :


With "cloud" Header :


With "full-white" header :



Also, you may include the rebranding text (organization name, appName1 and appName2) along with smaller logos, as shown below..

Logo with Text :


Check out the features and feel free to send in your feedback on our Free CRM for Google Apps.

Related Post :
iFreeTools CRM on your sub-domain, with rebranding !!