TeamDesk Blog

Calculating Job Duration

We’ve got a challenging request from Jane McCarty of webappsatwork to calculate job duration in TeamDesk. In the application we created we had to comply with the rules of competition; now we’ve decided to share the results with all of our users and created a simplified version of this app for our application library.

The task is defined as follows: defining the start and the end of working hours and knowing the weekends and the holidays - calculate job duration between specified start and end dates and times.

More on Customization

Here is a brief demo of how to customize a predesigned application step-by-step and completely tailor it to any business on the example of invoicing application.

We'll be glad if it facilitates your day-to-day work.

Jump start has never been easier

More and more business people come to conclusion that for a qualitative leap forward they need to shift from old fashioned way of data handling in Excel to advanced web based application use. But in the vast majority of cases beginners are stuck with the complicated structures, how to begin, etc and all that just throws them away.

To make the shifting process painless and absolutely simple the jump start with TeamDesk is free of any constraints now.

We take an Excel file and based on its data create a customizable application for free so the customer can make sure that its exactly what he needs and that it provides all expected benefits. Giving a hand at this stage we permit the user to check in practice how up and running application changes the very approach of working with the data.

You can check it out here: http://www.convertexceltoapp.com

Once you try it, you will never want to come back to previous methods of information processing.

As you keep on using a web-based application it becomes quite clear that it’s an unexpendable tool of business development.

Replace Spreadsheet

Searching for ways to make starting working with TeamDesk more simple, and looking for the best manner to do that to make everything clear from the first sight, we've decided to give an illustrative example of the most frequent and basic operation: data transfer from Excel into TeamDesk. To eliminate any confusing moments we’ve made a short spot of "How to Start" without a hitch.

More detailed info on how to start the workflow optimization and why it is worth doing that see at Replace-Spreadsheet.com

We hope it will give a hand as expected!

Impatiently waiting for feedback and any comments!

Area Code to Time Zone mapping

Our US customers, especially the ones using Leads management or Calls tracking applications, kept asking us about adding a functionality that automatically fills in the time zone according to the area code for the US phone numbers as it would save them a great deal of time by instantly displaying timezones next to the phone numbers.

We created a sample Area Code to TimeZone mapping application to demonstrate this functionality. Please explore the application and review a Setup mode.
The application is based on two tables joined via many-to-many relationship.
"Phones" table contains sample phone number list along with the State/Time Zone offset extracted from the "Mappings" table.
Area code is intelligently extracted from the US phone number regardless of the format.
"Mappings" table contains mapping between the US phone number area code and the timezone.
Now you may add area code to time zone mapping functionality to your existing applications or hire us to do it for you.

How to Calculate Running Balance

Given lines with amount (positive for income, negative for expenses) in a table called Money, you want to calculate running balance. What should you do?

First you have to define order for lines. Standard Date Create column TeamDesk generates for every table can suit your needs - old lines will appear on top, recent on bottom. If you plan to reorder the lines, you may need to create another, editable Timestamp column, let's call it Date.

Next, let's create many-to-many relation from Money table to self, and specify "Date Created < Date Created" match condition (or Date < Date, if you decided for custom timestamp). For any given record this relation will create the list of preceding records. Calculating a total on the amount column will result to opening balance. Adding the total (via formula column) will result to closing balance.

Simple, is not it?

Running Balance application from Application Library does one step beyond separating operation from amount and calculating income and expenses. Feel free to explore.

Default Value for a Column

You have a table with the data, and want to extend it with new column? No problem. But what if you want to initialize existing records to some value? Default Value property will not work in this case. Obviously new records will receive default value, but not old ones. Is there something you can do?

Using Formula Columns for Data Altering

After initial data upload has been completed, sometimes you need to convert it into another format or represent it in some other form. TeamDesk allows you to perform such modifications on the fly.

Using Advantages of TeamDesk Import

To save your time and facilitate your effort on data processing, TeamDesk is enhanced with the import/export features. Pretty standard solution for an application of this type, one may say. Yet, TeamDesk uses these features to solve a variety of tasks and helps to lighten your work appreciably.

How to make money with TeamDesk?

We are receiving numerous requests about the availability of an affiliate/partner program for TeamDesk. Let's try to summarize our vision on how we could work together today:

• You may provide setup consulting services to your TeamDesk customers and partners (we charge $200 per hour , so you may easily compete with us).

• You may try to develop your very own application(s) template and sell it via TeamDesk Application Library using "contact author" option. You may offer your setup consulting services to your application customers at your rate.

• You or your company may develop the application(s) in dbFLEX, promote and sell it to the customers at your price. dbFLEX shares the core platform with TeamDesk and provides re-branding capabilities (changing logos, copyright strings, support and billing links etc). Each partner will have own third-level domain in a form of subdomain.dbflex.net. You'll provide first level support to your customers. We'll provide second level support to your developers and charge you a low platform usage fee.