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.
