Skip to main content


Showing posts from November, 2017

How to create reusable invitation for local government meeting

Local governments of all sizes play an important role in every country’s life. They act as a man-in-the-middle between national government and citizens, bringing government power closer to citizens. While doing so, local governments also need to follow rules about what data to store and publish. Wherever some data occur, there is almost always a space for improvement in efficiency and today we will show you how to use Lumeer’s Smart document view to easily create an invitation for local government meeting that will prevent data copying and duplication, thus saving members’ time spent on administration. However, Smart document concept is very general and so can be useful for a wide variety of tasks from many fields.

Let’s start with creating a collection named Meetings, as we want to store data about meetings there. In Lumeer, collection is a set of records with the same structure - similar as file or table.

After clicking on collection icon, we see it as a table and we add all columns…

How to make sure that every candidate is contacted on time

When we post a wonderful job offer, chances are that there will be many candidates applying – with the perfect one amongst them, we just don’t know who it is. Of course we want to contact him, but with so many candidates, an accidental error could happen and we wouldn‘t send everyone an invitation to interview. Lumeer will help us to add two more layers of protection against such an error.

Firstly, in table view, we want to highlight candidates that applied in, let’s say, last three days. This is done by adding a formatting rule on column with date of application. It says that when the date is older than three days, then the cell is coloured red and it’s easier to spot that row. Also, there are other column settings: constraints, which determine type and format of data in the columns, and notifications, which we’ll explore later in the article.

The resulting table looks like following:

Secondly, we also want to get a notification which reminds us about applications that are more than two …

How to view salaries summary in pivot table

Although we’ve already seen how to apply aggregate functions (e.g. sum, average) on all salaries in a post about creating an overview of job postings, now we’re going to dig into even more details by using Lumeer’s pivot table view.

You may already be familiar with pivot table from Excel or other tools. The main feature which makes it different from classical table is that it’s not collection of records (rows). Instead, it summarizes information from that classical table and does it by calculating values of aggregation functions in every cell. Probably the best way to understand the idea of pivot table is to see an example, and we’ll show you one in a moment.

We start with a table showing job postings and hiring manager linked to them (we have already learned how to create such a table). Let’s switch the view from table to pivot table.

A window with pivot table settings shows up. Lumeer automatically adjust those settings for you based on available information - the first table (Posting…

How to show candidates on a map

We have already showed how to display data in calendar, but what if besides time dimension, our data also have space dimension? Working with addresses can be pretty tough because they have a complex structure (most often street and its number, town and ZIP code), but can be written in many different formats. However, if we want addresses to be easily searchable and maintainable, our system has to know meaning of each part of address string. We can start typing addresses into the table and Lumeer will give us suggestions from which we will choose. This saves us time because we don’t have to type so much, but there’s one more benefit: as Lumeer gave us the suggestion, he knows exactly the semantics of whole address string and can tell which part is street, town etc. which will be useful for visualization on a map.

With address column in the table, we can easily display its rows on the map by switching the perspective:

Now we see the candidates displayed on a map. By clicking on their icon,…