Create a table in LocalFocus

Make your tables and lists searchable to your audience and personalize the information.

Getting started with tables in LocalFocus

Is your question not answered in this manual?

Please contact jelle@localfocus.nl

cover

1 Start a new project

1.1 How do I start a new project?

Go to this page to start a new topic and click on the option 'table'. (If you use LocalFocus Pro, click here). Give your project a title and click 'save'. You can use this dataset with beer breweries in the Netherlands to practice.

1.2 How do I add my data?

Click on the 'Edit the dataset' button. You can add your data to the table in two ways: 'copy and paste' or link via a Google Drive spreadsheet (see next question). Use the copy paste option if you want to work quickly and easily.

These are the steps:

copy-paste table

Do you want to be able to easily adjust the figures after making your data visualization? Even if it has already been published online? Then you can link your data liberalization to a Google Drive spreadsheet. This link allows you to update the data of published widgets without having to re-publish an embed code. This is very useful if you often want to add new numbers or correct a typo.

These are the steps:

drive share button

everyone can read

link drive

result

If you adjust grades in the Google Drive spreadsheet, your graphic will be updated automatically, even if your graphic has already been published. Note: it sometimes takes a few minutes before you see the changes.

2 Shape your table

2.1 How do I choose the right visualization option?

In the table module you can choose two visualization forms: a 'classic' table form or an infocard view. 'Infocards' are blocks with information from each row of the table.

You will find the two options at the top left of your screen:

edit visualization

classic structure

block structure

2.2 How do I adjust the dimensions of the table?

You can adjust the dimensions of the table (in pixels) at the top right of the graphic.

adjust pixels

2.3 How do I (temporarily) hide a column?

Do you want to (temporarily) hide a column in your visualization? Then you don't have to remove it from the dataset. You can just 'uncheck' the column. You do that like this:

hide column

3 Make the table interactive

3.1 How do I make the table searchable?

With large datasets, it is nice if you can search the table for the information that is only relevant to you. Take for example the breweries file. Suppose you are curious about the breweries in your hometown. By means of a search window you can easily find this information in the table. You do this like this:

search by place

The result looks like this:

Search Result

3.2 When do I add a dropdown?

Does your table contain interesting categories? Using a dropdown, you can ensure that you or your audience can select a category that is only relevant to their search for information.

This brewery file includes a column called 'Start year cat', here are several categories with periods in which the brewery was started (1900-1990, 1990-2000, etc).

Suppose a beer enthusiast wants to find a selection of the oldest breweries in his hometown. This can be done quickly with the help of a dropdown and you do this:

Select period

The result, in combination with the search box from question 3.1, looks like this:

Select period

3.3 When do I choose a mandatory search box or dropdown and when not?

Mandatory

Not required

4 Other questions about the table module

4.1 What is the advantage of an infocard display on small screens?

At 'Table options' you can tick the option 'Use infocard display on small screens'. Tables with many columns are often very wide, not exactly ideal for a smartphone!With the infocard view, all information is listed below each other, making it easier to navigate.

Not required

Click here

fill in field

link result