Calculated Columns now available in Data Sync

15 May 2013

We have a great new feature for Data Sync that we just have to tell you about, previously if you wanted to transform some value we had 'Dynamic Columns' where you could write your own .NET C#. Now we have a simplified yet very powerful solution for when you just need something simple or if your not very good with .NET. We've tried to make it similar to other scripting solutions whilst keeping the ability to be really advanced if you need to. For example below is a little snippet that adds 30 days to Today.

Calculated Column

As with everything we do we've made it really easy just hit the (Fx) button on your Data Source to add a new column based on your Function. We've added lots of useful functions so you can virtually do anything you need, plus you can even mix it with the existing Dynamic Columns feature.

Here's a List of Current Functions with more on the way!

AND(params bool[])
BITWISEAND(params int[])
BITWISECOMPLEMENT(params int[])
BITWISEOR(params int[])
BITWISEXOR(params int[])
CHOOSE(int?, params string[])
CHOOSE(int?, params int?[])
CHOOSE(int?, params double?[])
CHOOSE(int?, params object[])
CONCAT(params string[])
CONCATENATE(params string[])
DATALENGTH(byte[])
DATEVALUE(string)
DAY(System.DateTime?)
FALSE()
FROMBASE64(string)
HOUR(System.DateTime?)
IF(bool, object, object)
IF(bool, string, string)
IF(bool, int, int)
INT(object)
ISINT(string)
ISNULL(object)
ISNULLOREMPTY(string)
ISNUMBER(string)
ISO8601DATE(System.DateTime?)
ISO8601DATETIME(System.DateTime?)
JOIN(string, params string[])
LEFT(string, int)
LEN(string)
LENGTH(string)
LOWER(string)
LTRIM(string)
MID(string, int, int)
MILLISECOND(System.DateTime?)
MINUTE(System.DateTime?)
MOD(int?, int)
MONTH(System.DateTime?)
NEWGUID()
NOT(bool)
NOW()
NULL()
NUMBER(object)
OR(params bool[])
PROPER(string)
REPLACE(string, string, string)
RIGHT(string, int)
RND()
RTRIM(string)
SEARCH(string, string)
SEARCH(string, string, int)
SECOND(System.DateTime?)
SPLIT(string, string)
STR(object)
TOBASE64(byte[])
TODAY()
TRIM(string)
TRUE()
UPPER(string)
UTCNOW()
WEEKDAY(System.DateTime?)
WEEKNUM(System.DateTime?)
YEAR(System.DateTime?)

| |