All built with the spreadsheet way of working that you’re familiar with. ![]() This example, and the preceding ones, give you an idea of the workflow capability you can build into your apps with Squirrel and Ninox. You can even add a new lead into the system which will write back to the underlying data in the Ninox database. You can edit details in the edit section, and watch the charts and tables update as you go. If you want to progress a customer from a lead to an opportunity, just hit the Progress button. If you click on a customer, you see all their details. And you can search for individual customers. You can choose to look at data by lead, opportunity, customer, and churned. You’re now looking at a single-page CRM example that is fully interactive. Not only will this update the data in the Squirrel table, but it also writes back to Ninox keeping everything updated. 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. You can set up your Squirrel project to search orders for an individual customer, e.g. This example gives you the ability to both search and update data in the Ninox database. So, you have the ability to both navigate your data and make fixes along the way.Įxample 3: New Tool Customer Order Gift Marker Business App The update affects the chart and tables in Squirrel, but it also updates the invoice details in Ninox. Not only can you see orders grouped by product, but you can go deeper and click on a particular product for individual invoice details.Ĭlicking on a particular invoice in the table allows the user to update order quantities. The user can select different customers from the dropdown to change which summary is displayed. Then, by using basic spreadsheet functions, the data is grouped by product and filtered by customer. The raw data is loaded into the Squirrel spreadsheet from the Ninox database. The Ninox data for this app stores values for customer s, product, quantity, and price for each order. See How to save scenarios with Ninox and Squirrel365. It’s also possible for users to save particular combinations of inputs as scenarios, which they can return to later. When comments are added to Squirrel, they get saved back to Ninox, allowing them to be seen by other dashboard users. Learn more about connections in our Knowledgebase article Ninox connections. In addition, a Ninox Write Connection lets users add comments to the dashboards. ![]() Ninox Read Connections were then used to dynamically load data into the spreadsheet from the Ninox database. This dashboard was built by adding a few components (charts, tables…) to the Squirrel canvas, and binding them to the Squirrel spreadsheet. The examples below show some of the possibilities when you underpin the power of Squirrel with a Ninox cloud database. For a general overview of how Squirrel works, check out our Infection Rate Calculator example in How to make a calculator app with Squirrel365. With Squirrel, you can build apps in minutes or hours rather than days or weeks using nothing but your spreadsheet skills. What can you build with Squirrel and Ninox?
0 Comments
Leave a Reply. |