With layoff news all over the place, I thought I’d do little analysis on the layoff data. I spent around 30 minutes creating a simple Layoff Tracker Application using Zoho Creator & Zoho Reports. Here is the application I ended up creating. The interesting part is, how this was done. Let me explain on how this was done.
To get started, I created a simple Zoho Creator application pasting the data from TechCrunch Layoff Tracker which took me couple of minutes to place the data into Zoho Creator’s database. To do some analysis, Zoho DB & Reports is the perfect tool. So I decided to connect Zoho Creator & Zoho DB.
Recently, we rolled out the first cut of our integration between Zoho Creator and Zoho DB & Reports. I used this feature to connect both these applications. I created a database in Zoho DB & Reports and linked it to the data form Zoho Creator App and set it up to frequently update itself every hour keeping Zoho Creator as the Master DB.
This way, Zoho Creator’s forms can be used to input the data directly
into the Zoho Creator database which is then synchronized withZoho DB & Reports.
Once I have the database synchronized, I then generated several reports
dragging and dropping columns based on the data in Zoho DB (which is
automatically fetched from Zoho Creator). Here are some of reports.
Layoffs By Date
Layoffs By Month & Location
Layoffs Trend
Using the ‘Publish’ option in Zoho DB and HTML View option in Zoho Creator, I embedded these reports back in Zoho Creator Application in another tab. This is the final app with Reports tab displaying reports from Zoho Reports.
Zoho Creator Application
Public Zoho DB
