Date-Time and Error Functions now available for use within Expressions

Your favorite online database app builder tool over Google App Engine - iFreeTools Creator, now supports date-time functions within formula field expressions and in validation expressions.

The new date-time functions made available are listed below :


now
Usage : now ()
Description : Returns a datetime object having the current time.

date
Usage : date(year, month, day)
Description : Returns a date object for the given year, month and day values.

datetime
Usage : datetime (year, month, day, hours=0, minutes=0, seconds=0)
Description : Returns a datetime object for the given parameters. If hours, minutes and seconds are not provided, they will be taken to be 0 (zero).

timedelta
Usage : timedelta (days=0, seconds=0, microseconds=0)
Description : Returns a timedelta object representing a difference in time, for the given days, seconds and microseconds. Can be used to add or subtract date/datetime values.
Example: now() + timedelta(1) will give tomorrow's date and time.


We have also added support for raising error messages when validating values using expressions. Apart from detailing on how to enter the value for the field in the description, this function will enable you to specify the reason for the validation failing.


error
Usage : error(error_msg)
Description : Raises an error with the given error_msg. This will be shown in the form for the corresponding attribute which failed the validation expression.


We have also rolled in a new home page for iFreeTools Creator, now highlighting the important features available in the platform.



Keep sending in your valuable suggestions on how you think we can make iFreeTools better for you.

Support for Time Zone, Customizable Home Page and List View Settings, Printable Reports and more..

At iFreeTools, we prioritize our features by listening to our users. Over the past couple of weeks, we have been adding the following features to iFreeTools, based on suggestions from our users..

• Support for Time Zones
• Customizable Home Page
• Support for viewing additional attributes from referenced parent records, in child record's list views.
• Customizable View Settings (Columns to View, Page Size, etc.,)
• Printable Reports (List & Chart Views)
• Pop-up selection for reference values.
• Option to hide Created On, Updated On and Notes in custom Entities.

Details of the new features are given below :

Support for Time Zones

Until now, we had been displaying date-time values in UTC. Now, users can choose to display the date-time values in their time-zone. Just select the required time-zone value in Admin > App Settings and have it reflected in all views.

Customizable Home Page

You can now configure the home page contents (apart from just the About page, until now), from Admin > App Settings. This will be used as the content of your home page when accessing from your domain.

Within the home page contents, you may use BBCode for safe-rendering of HTML content. The supported BBCode tags you may use are : b, i, u, s, link, img, list with *, size, color and center.

Such a sample content provided in the App Settings is shown below.


The resulting page when accessed via the configured domain is shown below.

Live link of that sample home page : http://acme.sahasvat.com

Support for viewing additional attributes from referenced parent records, in child record's list views

It is typical requirement to view a parent record's attributes along with the child record's attributes in list views - for example, attributes from Account records (parent) shown along with Contact records (child).

Earlier we only had a link to the Account record details; but now, you can view values from the Account record right in the list of Contact records.

When creating or editing Custom Views, you can select the attributes you want to be displayed and it will get shown in the client.

[Screen-shot of this feature, shown along with next feature]

Customizable View Settings (Columns to View, Page Size, etc.,)

Apart from including the parent attributes in the list views of client (previous item), you can also specify the columns you want to make visible from the client's attributes. Other attributes will still be loaded in the client, but will not be visible. They can be toggled for visibility from Instant Details, as was possible earlier.

You can also specify the page-size and optionally disable the Instant Details and search-while-typing features. This can be configured at a Custom View level or at the app level from Admin > App Settings.

The following image shows the new features of selecting additional attributes from referenced parent records and customizable view settings..

Printable Reports (List & Chart Views)

Now all list views and chart views have an option to have a printable view. This view will be without the header, side-bars, footers and advertisements.

This feature is accessible from under Options in the list views and as a top-level button in chart views.

Pop-up selection for reference values.

Until now the reference value selection was possible only from select boxes. While this is fine if the number of values is less, this can be difficult to use in case there are more options from which to choose from.

From now on, if the options are more than 20, iFreeTools will automatically provide a pop-up option to choose the reference value. This option will enable selection from a list view, where you can sort and search the records and then select the required record instance for reference.

Option to hide Created On, Updated On and Notes in custom Entities.

This feature is applicable for iFreeTools Creator - which allows creating custom entities. You may now opt to *hide* the default attributes added to an custom entity, which are date-time stamps for Created On and Updated On and the text attribute Notes.

This only hides the attributes and can be re-enabled back again at any time.

--

By choosing to use our products, you show your commitment to us. Our way of thanking you for this, is to listen to your feedback and acting on it, so as to help you use our tools better.

Keep sending in your suggestions.