October 2018

Share it 🚀

Process automation: Integration of TimeTonic with Zapier and more than 1,000 applications!

TimeTonic is now available by invitation in Zapier.

This means that you can create automation rules to interface TimeTonic with over 1,000 applications.

It's pretty amazing what we can do.

For example you can send an email with an attachment to a recipient list when a status is changed in TimeTonic.

Here is the link to add TimeTonic to your zapier account: http://bit.ly/TTC-Zapier

The available trigger events ("triggers") are:

  • New line in a table
  • New line in a view

The available 'actions' are:

  • Create a new record (new line)
  • Update an existing record (line)

More info in the online help here

Automation of calculations with Excel

It is now possible to use an Excel file to automate calculations in TimeTonic. Calculations will be performed each time a value is changed in the TimeTonic table automated with Excel.

Calculation of premium, price, yield, margin, this option opens up an almost infinite horizon of calculations and automation of your processes.

The principle is very simple. You can define TimeTonic fields as input values and TimeTonic fields whose value will be the result of a calculation in your Excel file .

To do this first add your Excel file via the'Automation with Excel' option in the context menu of the table.
Then you have to configure the fields (columns) to link to the Excel file and indicate which fields will be input values (in) or output values (out).

In the TimeTonic parameters of an input field, modify the'Synchronization code' option by entering the location of the cell in your Excel file that will be replaced by the content found in TimeTonic, using the syntax in_File1_B2 to point to cell B2 of the Sheet1 sheet in your file.

In the same way, in the TimeTonic parameters of your field that should contain the result of an Excel calculation, in the'Synchronization code' option, type the location of the cell in your Excel file containing the result that will replace the content in TimeTonic, using the syntax out_File2_C33 to point to cell C33 of the Sheet2 sheet in your Excel file.

(Replace of course Sheet1 and Sheet2 by the exact names of your sheets in your Excel file and B2 and C33 by the exact coordinates of the cells containing the input and output value of your calculations).

A more complete description will be available soon!

But then again...

  • The choice of views to be applied for the display/selection of related table items is now visible only to administrators and is specific to each view. It is now possible to choose which view to apply to a contact for example from the company view and to choose a different view to apply to a contact from the project view.
  • New design for buttons to add related table elements in form view
  • A bit technical: improvement of the filtered views of links to another table in form mode: column sortings and restrictions are still applied, but no more filters (as this could hide linked elements)
  • New notebook template for Room Reservation Management
  • TheURL of each record view is now visible in the browser, which allows to open it directly, for example by sharing the url in an email
  • New field:'Conditional selection (list from another table)' allowing to create a different selection according to the result of a selection from another field.
  • New option: mandatory field
  • Tag mode for links in form view
  • Color for the tags (the color is specified by adding a field of type 'Color selection')
  • New option in the 'Share Form' views to get a web URL with a blank form. When a person completes the form, a new row will be created in your TimeTonic table with the content of the filled fields.
  • Mirror views now available on Android
  • New API key in your profile, especially for integration with Zapier
  • Editing single values of elements in a related table in form view
  • Server load monitoring to improve TimeTonic's performance and response time
  • is among' and'is not among' filter option for related table fields
  • New filter - in the last 5 and 15 minutes, ideal for example to track the latest changes
  • Improvement of the external form
  • New option'URL to be notified for changes' allows you to call your own calculation or action program every time a change is made in TimeTonic. Ideal for automating your processes or interfacing with external applications.