Build applications
App Creation Basics
In this course, you’ll learn app creation basics by preparing your Excel spreadsheet, and building a simple web application using the Designer interface.
Start course- Lessons
- 9
- Level
- Beginner
- Format
- Self-paced
In this course, you’ll learn how to to prepare your Excel spreadsheet, and build a simple web application using the SpreadsheetWEB Designer interface. Designer applications feature a responsive design with database and user management support. This means that a Designer application can be accessed from any device with a web browser, can capture data, and integrate a workflow in the application structure. All you need is named ranges for every input and output cell or range so that you can connect them to their web interface counterparts in Designer.
Requirements
- A SpreadsheetWeb Control Panel account. You can signup for a trial account here.
- Your spreadsheet containing named ranges for all inputs and outputs you would like to use in the web interface of your application.
Course curriculum
What you’ll learn
- 01Prepare Your Excel FileIn this tutorial, you will learn how to structure your workbook for web use, and the importance of named ranges in SpreadsheetWEB applications. The workbook…
- 02Upload Your Excel FileIn this tutorial, we’re going to show you how to upload your file into SpreadsheetWEB. Before uploading your workbook, make sure that your spreadsheet…
- 03User InterfaceThis tutorial demonstrates how to create a web user interface (UI) for your web application after uploading your workbook. The user interface creation…
- 04Navigation and PagesThis tutorial will show you how to create a web application with multiple pages, and add page navigation to let your users transition between available…
- 05DatabaseIn this tutorial, you will learn how to create database tables in SpreadsheetWEB applications to capture user information. You can capture the inputs and…
- 06PrintThis video will show you how to create Print processes for Word or PDF export in SpreadsheetWEB applications. You can create a template to be used in a…
- 07EmailThis video will show you how to create automated Email notifications in SpreadsheetWEB applications. Email processes can be assigned to Action Buttons to…
- 08Publishing Your Application and TransactionsIn this tutorial, you will learn how to publish your web application, and manage transactions. The design process is actively occurring on the web server as…
- 09Updating the WorkbookUpdate a published SpreadsheetWeb application by downloading its Excel model, uploading the revised workbook, and publishing a new transaction.