If you have been following our posts, you probably already know how to a create mobile page or native mobile application using SpreadsheetWEB. Until now, we’ve been focusing on implementing calculators, quoting tools and other generic applications. Let’s take it one step further and create a software for a complete process, using Microsoft Excel and SpreadsheetWEB.
Let us walk you through an application, through which; users will be able to register, book an appointment and see their existing appointments. This is a type of application many small businesses like doctor offices, gyms, hair salons can benefit from. They all need to simplify and automate the process of appointment management. A completely mobile-enabled tool will make things easier for customers, as well as the business owners.
The pages in this application must follow a certain order and menu functionality should allow transitioning between them. Here is a simple demonstration of the flow:
This process requires pulling values from the database. All registered users should be able to see their schedule and the app won’t allow selecting the same period for two users. To do this, we need to establish connection between the server and specific cells.
In this application, we used custom User Interface feature of SpreadsheetWEB to code our interface using HTML, CSS and JavaScript programming. All back-end operations like authentication, database, etc. are handled by SpreadsheetWEB’s API functions.
Even though SpreadsheetWEB has its own user registration system, we built this mechanic within the workbook itself. This way, we are also going to be able to export all user details to one report.
After logging in, we are greeted with the main window. This application also needs to feature other pages and references. Three buttons on this page allow transition between these sheets.
On the “Add Appointment” page; selecting a person and a time frame, then hitting “Save” adds the details of this appointment to the database. If any changes are to be made for an appointment, user returns to this screen.
All appointments of the user are listed here. The timeline cells are populated with the data fed by the API.
Going to the Data tab in the Control Panel, you can access all entries and create reports. This interface, of course, is only for the business owners and internal users. The combined report from all entries include user names, their appointments and the person they are to meet. In the end, we’ve got a versatile mobile application that can register users and manage an appointment schedule.
Being able to create web or mobile pages from any type of Excel document is an amazing thing. In most cases, this saves you an incredible amount of money and time. Why not combine Excel’s sandbox and SpreadsheetWEB’s flexible tools? With limitless possibilities, the result is a stand-alone mobile application that can handle complicated processes. Add a wrapper software, and there’s your first native mobile app.
Repost from Medium
