How to create a dashboard with Timetonic and Google Sheets?
You have lots of data in Timetonic and you’d like to visualize them in the form of a graph. Today, we’re showing you a simple and reachable approach by using Google Sheets as your dashboard engine, automatically fueled by your Timetonic data. Before we start, let's clarify that this approach is ideal for non-sensitive operational data. If you are working with personal, medical, legal, or regulated data, stick to a solution from the secure infrastructure of Timetonic. For this tutorial, you'll find in the video description, the Google Sheet and the script shown in this video as resources. Let's get down to it! The principle is simple, each time an intervention is created or modified in Timetonic, an automation sends these data to a Google Sheet via a webhook. A webhook is just a web link that triggers a remote action. Then, in Google Sheets, a small script receives the data and writes it in a tab called the raw data. Then, we'll manipulate the data with formulas to calculate statistics in the stats. We will incorporate a pre-built script that will allow us to insert a new line created in Timetonic or a field of the line. And finally, we construct graphs in a third tab, Dashboard, which we can publish and integrate directly into a Smart Page module of the workspace in Timetonic. In your Timetonic workspace, for example, in the table, you have required prerequisite fields that will help us construct our graphs. The "year" and "month" formula fields and the concatenation key formula fields that allow us to retrieve the intervention type and progress status. We're going to create the automation, so go into automation, add a new automation, save the automation. For the trigger, we'll use it when a row has been saved. This trigger captures both the creation of an intervention and its subsequent modifications. It's essential because when an intervention is created, there isn't yet any hours to declare. When the hours come later, via Google Sheet, we'll want to capture updates to have updated stats. For conditions, we empty them. We synchronize everything; don’t worry about duplicates, the script manages with its upsert logic. For the action, we'll use a Webhook call. We'll paste here the URL that will be generated in the Google Sheets script. Provisionally insert random text into the URL field that awaits the webhook URL, which will be generated in the next step, which you will replace when it's available. But you could perfectly set up the generation of the Webhook URL in Google Sheet first and then configure the Webhook call automation action window. Here, for example, I chose to do it this way. we do not use any authentication and we will insert the JSON data structure. This JSON lists all the information we send; the date, the intervention number, the title, the type, the status, the client, the site, and so on. So, I create a property name to this JSON structure list, and I find the corresponding field on the other side. I continue by clicking on the cross to generate a second line. I call the variable, I keep on calling the table variables to finish the gson list. We validate. We...