Table creation by Excel import

It is now possible to create new TimeTonic smart-tables directly by importing your xlsx files.

TimeTonic will automatically create the right table and columns in the right format (text, number, date,...) and import the data from the file.

Rules to follow :

  • the first row must contain the column header
  • the format must be the same for a column, for example a Date column must only contain dates
  • Only the first spreadsheet is imported

Notification message in the change history

It is now possible to enable notification by sending a message in the change history column.

This allows you to receive an email or SMS notification (see options in the book settings) when a value is changed in a column (status change, new file, etc.).

To enable notification, choose one or more columns for which you want to enable message sending each time you make changes.

As for the comments fields, it is possible to select whether this sending should be done for all or only for some people whose ID is present in a column.

To avoid unwanted sending of messages, for example when copying and pasting multiple messages, only the first 5 notifications are sent.

And much more !

  • In beta: external update form.  A new column type to generate a unique URL for each record. Click on this URL to obtain a pre-filled form with all your registration data and to update the data.An incredibly simple way to ensure RGPD compliance, update a directory with a personalised mailing for each correspondent, or set up a customised process for invoice approval, for example.

Please note that additional fees will apply to use this new option.
 

  • Columns in the same group are now always grouped together in form view even if the columns do not follow each other, avoiding aesthetic problems when someone moves a column out of its original group
  • Access to a second table from a restricted mirror view is now possible: all you need to do is create another mirror view in the same notebook for this second table
  • Pivot tables are now available for mirror views. A simple way to create a dedicated notebook for all your statistical analysis without cluttering the original notebooks.
  • New option to display linked table columns as tags
  • The sorting of the elements of a choice list is now done in order of choices and not in alphabetical order
  • Option to include or not a column field of a related table in the form view (yes by default)
  • New, more readable and clearer format for creating new books with more templates in French and English
  • New formulas MIN_NUM_ELEMENTS and MAX_NUM_ELEMENTS, to find the minimum or maximum value of a list of elements
  • New formulas MIN_DATE_ELEMENTS and MAX_DATE_ELEMENTS, to find the most recent or oldest date of an element list, for example, of all the dates of a task series
  • In the API, new getNamedTableValues function to retrieve data with the book code, table name and column code list

  • In Kanban view, a URL field is now clickable

  • In Gantt view: tasks are sorted in alphabetical order

  • In Gantt view, formula fields are now available

  • In Timeline view, new "days of the month" scale

  • The history now contains information related to the deletion of a line

  • Multiple export of word or excel model sheets.

  • When a file is actually a URL pointing to a photo, the photo is displayed rather than the paper clip symbol indicating a link.

  • The Ctrl-V of a URL, for example an image, in a file cell in Table View works. Very useful for example to add the photo of a linkedin profile in your CRM or the link to a google doc document.

Bug fixes

  • Min/max filters are now supported for autonumber fields
  • The exported word file has no extension on Firefox
  • Hiding the color legend bar when the values in the pivot table are numeric   
  • Missing values in the pivot table when there are several values (column linked to a table)
  • Conditional notifications were visible to everyone in the mobile application
  • User names not always visible in column restrictions
  • Searching for elements of a linked table is no longer available if there is a filter linking this field to another field, for example only the contacts of a company
  • iOS: read-only fields disappear for everyone

  • A limited user should not be able to modify hidden columns

  • Export template table: table columns linked to a date field add the time (00:00:00:00) when there is none.

  • Events added via the global calendar are only displayed after a reload

  • Only the first 1000 lines of a table are exported

  • The xlsx export is inactive when accessing a form through the links of another form

  • In Gantt view, the project bar is no longer automatically adjusted when the attached subtasks are modified.

  • Formulas: the formatting of numerical fields is not preserved when changing parameters (currency, number of decimals, thousands separators

  • Formulas: calculation problem on HOUR_DELTA with quarter hours

New layout for creating new books

A new feature that marks a fresh start for TimeTonic !

  • When creating a new book, by clicking on the small "+" button, you can now start with ready-to-use templates: project management, business relations, insurance brokerage, interventions, contacts, receipts/invoices, etc...
Please note that additional fees will apply to use this new option.
 
  • Columns in the same group are now always grouped together in form view even if the columns do not follow each other, avoiding aesthetic problems when someone moves a column out of its original group
  • Access to a second table from a restricted mirror view is now possible: all you need to do is create another mirror view in the same notebook for this second table
  • Pivot tables are now available for mirror views. A simple way to create a dedicated notebook for all your statistical analysis without cluttering the original notebooks.
  • New option to display linked table columns as tags
  • The sorting of the elements of a choice list is now done in order of choices and not in alphabetical order
  • Option to include or not a column field of a related table in the form view (yes by default)
  • New, more readable and clearer format for creating new books with more templates in French and English
  • New formulas MIN_NUM_ELEMENTS and MAX_NUM_ELEMENTS, to find the minimum or maximum value of a list of elements
  • New formulas MIN_DATE_ELEMENTS and MAX_DATE_ELEMENTS, to find the most recent or oldest date of an element list, for example, of all the dates of a task series
  • In the API, new getNamedTableValues function to retrieve data with the book code, table name and column code list

  • In Kanban view, a URL field is now clickable

  • In Gantt view: tasks are sorted in alphabetical order

  • In Gantt view, formula fields are now available

  • In Timeline view, new "days of the month" scale

  • The history now contains information related to the deletion of a line

  • Multiple export of word or excel model sheets.

  • When a file is actually a URL pointing to a photo, the photo is displayed rather than the paper clip symbol indicating a link.

  • The Ctrl-V of a URL, for example an image, in a file cell in Table View works. Very useful for example to add the photo of a linkedin profile in your CRM or the link to a google doc document.

  • New formulas

    New formulas MIN_NUM_ELEMENTS and MAX_NUM_ELEMENTS, to find the minimum or maximum value of a list of elements

    New formulas

    New formulas MIN_DATE_ELEMENTS and MAX_DATE_ELEMENTS, to find the oldest or the most recent date in a list of elements.

    Link on Kanban view

    The Kanban view is evolving: from now on you can click directly on a URL link displayed on a map.

    All Posts
    ×

    Almost done…

    We just sent you an email. Please click the link in the email to confirm your subscription!

    OK