In this version, we’ve introduced a new Queries module. Using this module, you can create your own database queries without any coding whatsoever. All you need to do is to select the application or data map you want to work with, pick the columns from that data table, and select the conditions from a dropdown menu. That’s it! You can then assign a query to a named range to use it in calculations. Please note that this feature is currently only available in Server and Private cloud licenses.
To access this menu, select it under the Names section either on the Designer interface, or from the dial menu on the right.
Now, you can build applications that can check any saved records, use data from other applications, and even data you’ve imported. Below is a scheduling application that shows available time slots for a given date.
The application shows all available times from 8AM to 5PM. A user has requested a meeting for 3PM on 5/22/2019, and saved a request in the database. When another user selects that same date, the 3PM option will be omitted from the radio button selection.
This was created with a very simple query that checks the column “Booking Hour” in the database and returns the results to be used in the workbook calculations.
In addition to other various bug fixes and performance improvements, we also added support for visualization animations in Designer applications. We hope that you’ll like these new features as much as we do. For a full list of changes, fixes, and new features, please see our user guide.
You can sign up for a 14-day free account and transform your Excel models into web applications in no time.