You can also watch our on-demand webinar Building no-code apps with Ninox and Squirrel365 for an easy-to-follow demonstration by Donald MacCormick — CSO, Squirrel365.
Ninox and Squirrel — a match made in heaven
The Ninox cloud database and Squirrel365’s spreadsheet-driven web-app creation capabilities, provide a powerful no-code combination. Non-technical users can access information and processes, and create remarkable web-based apps to streamline business workflows.
Squirrel lets you create web apps that read data from Ninox. You can present information to end-users and allow them to take actions to:
- write updated or newly created data to Ninox.
- trigger some other workflow process.
What can you build with Squirrel and Ninox?
With Squirrel, you can build apps in minutes or hours rather than days or weeks using nothing but your spreadsheet skills. For a general overview of how Squirrel works, check out our Infection Rate Calculator example in How to make a calculator app with Squirrel365.
The examples below show some of the possibilities when you underpin the power of Squirrel with a Ninox cloud database.
Example 1: Financial Summary Dashboard
This dashboard was built by adding a few components (charts, tables…) to the Squirrel canvas, and binding them to the Squirrel spreadsheet. Ninox Read Connections were then used to dynamically load data into the spreadsheet from the Ninox database. In addition, a Ninox Write Connection lets users add comments to the dashboards. Learn more about connections in our Knowledgebase article Ninox connections.
When comments are added to Squirrel, they get saved back to Ninox, allowing them to be seen by other dashboard users.
It’s also possible for users to save particular combinations of inputs as scenarios, which they can return to later. See How to save scenarios with Ninox and Squirrel365.
Example 2: Toys of Our Childhood App
The Ninox data for this app stores values for customers, product, quantity, and price for each order.
The raw data is loaded into the Squirrel spreadsheet from the Ninox database. Then, by using basic spreadsheet functions, the data is grouped by product and filtered by customer. The user can select different customers from the dropdown to change which summary is displayed. Not only can you see orders grouped by product, but you can go deeper and click on a particular product for individual invoice details.
Clicking on a particular invoice in the table allows the user to update order quantities. The update affects the chart and tables in Squirrel, but it also updates the invoice details in Ninox. So, you have the ability to both navigate your data and make fixes along the way.
Example 3: New Tool Customer Order Gift Marker Business App
This example gives you the ability to both search and update data in the Ninox database.
You can set up your Squirrel project to search orders for an individual customer, e.g. “Bob”. And with another Ninox connection, Ninox Update, you can then update items to be marked as gifts by clicking on the Mark as Gift button.
Not only will this update the data in the Squirrel table, but it also writes back to Ninox keeping everything updated.
Example 4: Squirrel365 CRM
You’re now looking at a single-page CRM example that is fully interactive. You can choose to look at data by lead, opportunity, customer, and churned. And you can search for individual customers.
If you click on a customer, you see all their details. If you want to progress a customer from a lead to an opportunity, just hit the Progress button.
You can edit details in the edit section, and watch the charts and tables update as you go. You can even add a new lead into the system which will write back to the underlying data in the Ninox database.
This example, and the preceding ones, give you an idea of the workflow capability you can build into your apps with Squirrel and Ninox. All built with the spreadsheet way of working that you’re familiar with.
How to build with Ninox in Squirrel
Learn how to build a version of Example 3, the New Tool Customer Order Gift Marker, from Squirrel’s CSO Donald MacCormick in Building no-code apps with Ninox and Squirrel365. If you want to skip straight to Donald’s helpful how-to section, you’ll find it at 19:24 minutes in.
Donald shows you how to:
- select your Ninox connector
- bring in your data
- add components to the canvas
- set up filters from a worksheet that is specifically loaded with spreadsheet logic.
You’ll learn how to set up a Squirrel project so that when a user enters a value in the Text Input box, the table in the app will bring back data from Ninox for that value, e.g. orders for people named Bob.
The power of Squirrel and Ninox
Squirrel365 lets you take a spreadsheet, create an app, publish it, and make it available to the world, all within a matter of minutes.
The logic of the spreadsheet gives you huge flexibility over what you can build. And it’s just a case of using filters and triggers to interact with the Ninox data.
With Squirrel and Ninox you can:
- read data from Ninox databases dynamically into the Squirrel spreadsheet.
- map the data in the spreadsheet to user interface components.
- use control components in the interface to push data back into Ninox such as the ‘Add new lead’ button in the CRM example.
You can do all of this with clicks, not code. Using just your spreadsheet knowledge is the easiest way to make an app.
Visit our Showcase to see and interact with some of the examples above. You can download them and even put them into PowerPoint.
You can also try out the power of Squirrel and Ninox for yourself with our 30-day free trial.