Blog

Summing Column Data - DataTables API

In an earlier blog post, I gave examples of how the DataTables and Editor APIs can be used to enhance a CloudTable. This blog post takes that further, describing a method to summarize data from the table is the form of summations.

The example below is what we will be building in this article - the block above the table contains a summary of the total salaries for each location. You can also click on each location to filter the table.

New in CloudTables: Record colors

Color association can be a very powerful tool when working with complex data sets, such as those that can be created in CloudTables. For that reason in our latest update for CloudTables we have introduced the ability for each record to be assigned its own color and for that color to then be used in the table both for the host record and when it is linked to from another data set.

Let's look at a little example of colors in CloudTables:

Using the DataTables and Editor API with CloudTables

CloudTables builds upon DataTables and Editor. It also offers much, much more, such as security, history and a full CRUD API, but the foundations come from those two libraries. Because of this, the functionality of both of those libraries are fully available to you. This is discussed in the documentation but this blog post will give examples of what can be achieved with very little code.

In this blog post I will show how to:

• Display a message in a form indicating the number of characters entered, which can be useful for live validation
• Enable inline editing in a table (a feature coming to CloudTables soon!)
• Enable inline creation of new rows.

Read on for more details...

How easy was that?!

In our latest video, I give a fast run through of how easy it is to create a customized editable table and embed it into your own web-pages using CloudTables.

Read on for more details...

CloudTables ❤️ Bootstrap 5 and Bulma

One of the core features of CloudTables is that you can seamlessly embed the generated tables directly into your web-site - to the end user the table will appear as just a regular component of your site, with the same look and feel as other components.

To achieve this, CloudTables supports multiple styling frameworks - for example if you embed your CloudTables into a Bootstrap styled style, we'll automatically adjust the styling of the table and editing forms to make use of Bootstrap.

We already support a number of styling frameworks and with our latest release of CloudTables, we've added support for two more:

• Bootstrap 5 - the latest major iteration of the world's most widely used styling framework.
• Bulma - a relatively new styling framework which is extremely easy to use and very well documented.

Read on for more details...

Full CRUD API

With today's update to CloudTables, we introduce a full Create, Read, Update, and Delete (CRUD) API to compliment the read and editing abilities of CloudTables when embedded into pages. This can be particularly important for monitoring and reporting applications where you want to automate the data creation in CloudTables, but have a clean and easy to use UI to view and understand the data.

Read on for more details...

New in CloudTables: Nested data

We've rolled out the latest release of CloudTables today, and I'm really excited about the latest features:

• Display of nested link data
• Improved Excel import

Data in CloudTables is naturally well structured and hierarchal through its easy to use link ability - i.e. a row in a data set can refer to one or more rows in any other data set (or even itself). Since our day one launch it has been possible to display data from a linked data set in a table. Today we are introducing the ability to display data from a data set that the second data set links to. Indeed, it is not just possible to display data two levels deep now, but up to five links deep.

As an example, consider flight information which displays information from four different tables:

Read on for more details...

New in CloudTables: Bar display and easier nesting of data

With our latest release of CloudTables, we've introduced a number of new features that I would like to introduce to you:

• Bar display of numbers
• Google Sites embed
• Improved linked data visualization

Example of bar display

Read on...

Introducing the CloudTables blog

We are introducing a blog to CloudTables, to be able to communicate updates, new features and also discuss some of the technical details about CloudTables and how we implement various features.

While we've come along with with CloudTables already (recently having introduced self-hosting abilities, multi-tenant and multi-users), CloudTables is still a young product. We are keen for your feedback about the services we provide and to hear how you use them, or plan to use them. Please get in touch if you have any feedback for us.