An update for system administrators today – calculations now automatically update throughout the system whenever a field, view or table name is changed.

Before this, if a field name was changed in a table, calculations on that field would still show the old name. They’d need manually updating the next time each calculation was edited.

Now, you don’t have to worry about any of that when changing names.

Due to this, cloning views will work first time more regularly – previously any out of date calculations would have to be updated beforehand.

9659165098_cea5b9b59b_k

100x58_1When you’ve been developing one piece of software for a number of years there are inevitably one or two decisions you make early on that with hindsight you’d make differently. However, there’s one major decision that we at agileBase get happier with every day: choosing PostgreSQL as our data store.

As a customer, you may not know the details of which database is used to store your data, or the technicalities of what a database is exactly, but it’s worth highlighting a few points that have a direct impact on your business with us. The database forms such a large part of our offering – it’s what keeps your data safe and means however many users you add, the system remains lightning fast. Our own ‘fast, friendly and flexible’ agileBase platform built on top of the database takes advantage of that.

Besides robustness and performance, there are a few other business benefits:

Open source

The database is open source – one could talk for a long time about what that means, but for you and I there are three main benefits

  1. It’s free. There are no license fees for customers to pay. That way we can remain extremely good value.
  2. There’s a large body of active developers improving it all the time. That often manifests itself in security and performance improvements that bring great benefits to all customers without us lifting a finger. For example, recently parallel processing has been added that will let us speed up many parts of the system massively.
  3. There’s a great community of users and developers. When our programmers want to find out the best way to do something, there’s loads of help out there.

Some stats

  • 67 people form the current team of developers, including 5 from the core team and 39 major contributors
  • 1.5 million lines of code form the database, from a starting point of just 100,000 in 1996
    pg
  • There are approx. 6,000 mailing list (support, developer and community) messages per month

While agileBase is at the moment a relatively small startup, it’s nice to know that some larger outfits such as Instagram, Sony, the Met Office and many large enterprise, financial and government/defence organisations also see the benefits. As Amazon say,

PostgreSQL has become the preferred open source relational database for many enterprise developers and start-ups, powering leading geospatial and mobile applications

 

 

Lots of people have been UX (user experience) testing agileBase recently and given us lots of valuable ideas. Despite quite a few staff holidays recently, we’ve managed to incorporate a lot of their suggestions into the product and can release them to everyone today! 28 improvements have been made since last month’s release. Many are ‘behind the scenes’ but here are some of the visible highlights.

Notification ‘badges’

Comments and notifications are one of the most heavily used features of the platform. If you mention a particular person in a comment, that person gets a ‘direct message’ that appears at the top of their homepage – they can then easily reply to it if they want to.

With this release, not only will the message appear on the homepage, but if the user isn’t on the homepage at the time, a ‘notification badge’ with a count of messages will appear at the top right of the screen, allowing quick access to direct messages. This helps in the case where the user may not visit the homepage very often, but remains in one tile or app for long periods of time.

direct comment

Thanks to Lewis Pies for suggesting that improvement.

New & improved user interface controls

Date picker

date picker

Modern browsers include their own date pickers, so we now take advantage of that to provide a better experience. Google Chrome’s version is pictured. Dates are quicker to enter, either with the keyboard or mouse and the layout’s more compact.

Older browsers such as Internet Explorer will retain the old-style picker.

Adding items to drop-downs

Similarly, the old method of adding a new item to a dropdown list confused some testers – this UI has been improved, using a popup prompt.

Less ‘jumping’

When navigating between different parts of the screen, the system now smoothly scrolls, so the user always knows where they are.

Easier to see chaser emails

As you may know our ‘chaser’ facility can be set up to automatically email customers or suppliers when their input is needed e.g. if they need to supply a document to you. The visualisation of these messages is now easier to look at, for example repetitions of the same message are reduced.

Administrator features

On the admin side, cloning views is now a lot more reliable, working with particularly complex views as well as basic ones.

Some people had an issue using the facility to download a spreadsheet of all recent changes. That’s now fixed and should work for everyone.

 

 

We have new charts – histograms, bubbles, ranges – you name it, a veritable smorgasboard of charting functionality has arrived!

This is one of the largest feature upgrades that we’ve released in the past few years. We’re not American, and not usually given to hyperbole, but this beta* release is awesome!

*Since this is such a major feature boost, we’re releasing it in beta form, that means although it’s been internally tested, there are almost certainly bugs, so please bear that in mind, try it out as much as you can and report any issues or general requests to us.

Firstly, the chart builder now gives you a lot more control, in an intuitive fashion. A three step process lets you choose data to chart, set various options if necessary and select a chart type – showing a visual representation of what your data looks like for each type.

chart selection

There are more than a handful of features and categories of chart that just weren’t possible to make previously. Here’s a quick roundup, focussing purely on what’s new.

New charts

Note: a lot of these screenshots are from the www.highcharts.com demos but you can test out the features in your own systems to see similar results. Highcharts is the excellent library we use to create our charts.

Stacked percentages

For area, column and bar charts, you can now display data as stacked percentages, letting you see how values relate to each other relatively.

stacked percentage area

Breakdowns with multiple series

The ability to break a bar chart or area chart down is great, but previously worked with only one series. Now you can add multiple series, or calculations, and break each down.

multiple stacks

Multiple series from a breakdown

As you may know, you can add multiple series (lines, sets of bars etc.) to a chart by adding different calculations, if you want to see different things on the same chart, like say total net worth and annual turnover.

However, now you can also create multiple lines from just one calculation – simply choose a breakdown field and a ‘line’ or similar chart type. Here’s a chart where the calculation is total number of employees and the breakdown is sector.

breakdown lines

Bubble charts

Show more information than a plain scatter graph by specifying the size of each point. To create this, add one calculation for the placement of the bubble on the y-axis, then a second to be used as the relative size of the bubble.

bubble

Histograms

Many’s the time I’ve wanted to look at the distribution of data and had to export to a spreadsheet, then look up help on the web and fiddle around with data analysis options.

Now, you can simply enter a ‘histogram bin width’ under the second ‘options’ step of the chart creation wizard. For example, if you’re looking at past sales and want to see how many of each you have in value ranges of £1000 (0 – 999, 1000 – 1999 etc.), just

  • set the chart grouping to ‘value’
  • add a count calculation
  • set the ‘histogram bin width’ to 1000

and if you like, choose a suitable-looking chart type like ‘packed columns’. Here’s a histogram with a bin width of 10:

histogram

Note: this is one area you may notice needs a little work if you try it out in agileBase – the placement of the numbers on the x-axis can be slightly confusing still, but we’re working on it.

Ranges

Useful for showing max. and min. values on the same chart. Like bubble charts above, add two calculations to the chart – one for the min and a second for the max.

area range

Adding multiple filters

Perhaps saving the best until last, this feature applies to all chart types and is probably one of the additions that will make the most difference to everyday workflows.

Previously, you could add simple date filters on charts, to limit the data shown to say the last month or year.

Now, you can add filters on any fields to a chart permanently. That makes charting much more useful in general, as you can add multiple charts to the same view with different filters. Say you were looking at a view of all customer support requests, open and closed. You could add one chart summarising the closed tickets by category and a different one showing the open ones i.e. the current workload.

You can even use all the ‘special’ filter commands as per filtering a view, i.e. a question mark means blank values, a colon means ‘starts with’ etc.

Under ‘advanced options’ (step 2), enter your filters in the format fieldname=value,fieldname2=value2,…

What’s next?

Well, no doubt we’ll be fixing any bugs that come up in beta testing, helpfully reported by you! Further development will also be guided by customers, so let us know what you’d like to see. Here are some initial questions open to anyone, answers on a postcard please.

  1. Would you use trend lines? They’d be relatively easy to add to the system but how many people have a use for them?
  2. One of the more advanced chart types we’d like to get working is box plots but we need some concrete examples of how they might be used, so if one of those plots would be useful to you, please do drop us a line and let us know the details.
  3. Would you like to be able to add different series types on the same chart (e.g. bar and line)? What for?

We hope you’ll agree this all adds up to a massive jump in capabilities. We still don’t pretend to be a full ‘Business Intelligence’ solution though, for users with particularly advanced analytics needs we recommend integrating with a third party product such as Microsoft’s Power BI, Tableau or Amazon QuickSight.

 

 

 

I don’t know if this is a functionality that AB already has, […] something that showed you the recent documentation/pages you’d visit – just a few, so that if you needed to tab out on a phone call etc. you could easily return to what you were doing. It’s a common feature I think used for membership orgs as we’re often in the middle of something when people call and want x, y or z doing.

So said a customer using agileBase recently, the CIPA.

At the time, we didn’t have that facility, but we’ve now added it, so thanks to their request, everyone can take advantage of it.

To see the recent items you’ve looked at or edited, simply click the pulldown arrow at the top of the screen – you’ll see a list of them appear, looking something like this:

recently viewed

New items will appear on the left and you can scroll right to see older items.

Please check it out and let us know what you think. All further improvement ideas welcome!

What’s up next?

We like to keep things snappy so there are various speed and performance improvements that have been released recently, or are about to take effect, but apart from that behind-the-scenes work, one major area we’re also working on is charting.

The release of the Highcharts Editor has encouraged us to use their facility and/or take inspiration from it to beef up our existing charting functions. So you’ll see enhanced chart editing coming soon, watch this space.

If you’re an agileBase administrator, you’ve probably used the ‘unique’ field option to ensure that, for example, no one enters two products with the same code, or to make sure invoice numbers can never be repeated, or to enforce the uniqueness of customer account codes (a few uses amongst many).

That takes care of the situation where one field needs to have unique values, but there are other cases where a combination of field values should be unique.

What does that mean? Well, take some other examples:

Say for example you’re managing lists of attendees for events, booking them on and cancelling if necessary. You might like to ensure that no person appears more than once as an attendee at a single event. To do that, you could add a ‘unique constraint’ covering the combination of event ID and person ID.

Another case would be if you operate a ‘multi-tenanted’ system where lots of different companies in your group can log in to the same system but with their data separated. In that case, you might not be able to set a Product Code to be unique as different companies may want to use the same code. However, you could make the combination of Company ID and Product Code unique.

In short, the more you can do to ensure your data doesn’t get in a pickle, the better.

The good news is that with a new feature released today, you can add those more advanced constraints.

In a table’s ‘manage’ tab, click the ‘unique’ icon. Select a set of fields you wish to be unique in combination by ticking them and press ‘add constraint’. You can add as many constraints as you like, covering different combinations of fields.

uniques

agileBase keeps a record of every single change made to any data in the system, for a period of one year, along with the time of the change and who made it.

Data edits can be seen by clicking ‘history’ at the bottom of any editing screen.

history

Some customers now have up to 6 million history records in the past 12 months, containing both user changes and automated changes caused by workflows, i.e. where a record is created, updated or deleted automatically based on rules.

You may want to extend the audit trail to multiple years worth of data. This is now possible, for a simple, small charge of £15 per month for each year of audit trail data you wish to keep.

Furthermore, customers who choose this upgrade will also benefit from a much increased ability to analyse the data. Normally, the only ways of seeing the history are to view it for one particular record, as above, or download the most recent 200,000 changes to spreadsheet. However, with the upgrade, data will be available to be viewed in the same way as user data, i.e. in tables from which you can create views, add calculations, charts etc.

So for example, you could analyse how many changes were made per month by each user, count the volume of logins from various locations or see what the most common fields are to search on. All data’s available to query, whether that be data changes, logins, view queries, even administration functions like adding new fields/tables/views or changing user privileges.

If you’re interested in setting that up, please do get in touch.