Getting started

The Installation document on the Docs page describes the installation process from scratch. It would basically mean copying the templates and assigning the sharing rights by yourself.


If you declare during the registration process that you want MeDigital to provide you with the preinstalled templates, we are happy to do it. In following examples and screenshots we are using User John. Obviously your name and chosen data will appear instead of it.


Register on the Login page and check the install request.

Next day or so you will receive three emails about obtaining the ownership of files like this one

Those three files will appear in your Google drive list. You can rename them as you wish.

Installation spreadsheets

Open the Main file and look at all sheets

Timeline sheet contains the example data (cats and dogs)

You can do the editing directly on the Timeline sheet; however with more rich text it is recommended to push the Copy button. The Edit sheet will open with the transposed contents of the current line in the Timeline sheet.

Edit sheet enables you more comfortable editing. By pushing button Paste the changed contents will be copied back to the relevant line of the Timeline sheet.

Note: if you are not comfortable with editing Google sheets you can buy the Libreoffice Add-On.

Config sheet contains preconfigured parameters for running the timeline function.

The Timeline key will be replaced by the key that you filled-in during the registration.
Targets are full URL’s of the Spreadsheets Flippity and Nightlab.

Setting access rights

Push the button Run Visualisation. At the first run you will be asked to allow the function Timeline further processing.

click on Continue

click on Go to Timeline (unsafe) and don’t worry (see the Note about privacy below)

click Allow

First Run

Push the button Run Visualisation again and wait until OK message appears in the Result field.

Gannt sheet: check the result by switching manually to the Gannt sheet. You should see a simple Gannt graph. Pushing the button Description will show the contents of the Description field including active html links.

Go back to the Config sheet, change the Gannt parameter to Flippity and push Run Visualisation again.


Visualisation Flippity

Click on Visualisation and the new window with Flippity website should appear

Play with the these buttons

Visualisation Knightlab

Change Flippity to Knightlab and push Run Visualisation again. You should see the first slide of the Knightlab visualisation. Move to other slides by using arrows or clicking on the time blocks below.

From now on you can edit the data and run various visualisations as you wish just by editing the Timeline sheet and changing parameters in the Config sheet.

Further sheets and parameters

Lists sheet contains possible values validated on the Config sheet. You can add/change categories and colors.

Demo sheet could serve as the inspiration, you can also copy data to the timeline sheet to make experiments.

Further Config Parameters

Parameter Categories

The cloud function generates visualisations only for records that equal the chosen Category from the Category list.

ALL ignores categories and generates all records.
You can use also ALL as the category in the Timeline sheet. In this case the particular record will be generated regardless of the chosen Category.

Parameter Template serves for regenerating the target sheets with a template. Pick YES in case of data errors and run the Visualisation. One record containing template data should show up.

Change again template to NO and the Visualisation should work now.

Parameter Encrypt encrypts the Headline and Description texts. It can be useful if you don’t want temporarily to let anybody check the real contents.

Note about Privacy

The Main (source) file is owned by you and the Medigital Cloud function should have the Editor rights. Cloud function only reads the data from Timeline and Config sheet and generates data in the Gannt sheet.

The Cloud function should have Edit rights for Flippity and Knightlab spreadsheets as it generates appropriate data for visualisation engines. The links to these spreadsheets are published so whoever knows the links can see the data. This can’t be avoided; however you can temporarily replace the contents by using options Template or Encryption.