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.
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.
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)
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.
Click on Visualisation and the new window with Flippity website should appear
Play with the these buttons
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
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.