Tutorials

5 Ways to Make your Designer Applications Look More Refined

5 Ways to Make your Designer Applications Look More Refined

Applications created in Excel rarely look good because Excel was actually never intended to be an UI design platform. The real power of Excel is its ability to allow business users to build powerful business applications and tools. In this tutorial, we...

Databases in Designer Applications

Databases in Designer Applications

Saving data is crucial for web applications where you need to capture user information. Subsequently, the way you structure database tables can save you the headache when it’s time to analyze the data collected. In SpreadsheetWEB, designer applications can...

Email Notifications in Designer Applications

Email Notifications in Designer Applications

SpreadsheetWEB allows setting up email triggers in designer applications, which can be very useful in notifying users when certain events occur. Email notifications must be tied to an Action button, and when the button is pressed, the email process will...

Excel Export in Designer Applications

Excel Export in Designer Applications

The ability to generate an export from your application in Excel or Word format is especially useful for enabling your users to get printable reports. An Excel export can be preferable when you want your users to be able to analyze the results. In this...

Custom Notifications in Designer Applications

Custom Notifications in Designer Applications

Custom Notifications feature allows setting up application data queries, which will trigger automated email notifications when the predetermined conditions are met. This feature is especially useful for tracking system entries and notifying users based on...

Tracking your SpreadsheetWeb Applications with Google Analytics

Tracking your SpreadsheetWeb Applications with Google Analytics

It is important to track the usage of your SpreadsheetWeb applications. You can use the built-in Analytics feature in the Control Panel. You can also use Google Analytics which is one of the most popular website tracking and reporting tool in the...

Multi-selection Controls

Multi-selection Controls

There are situations where user would need to make multiple selections from a long list of options in a SpreadsheetWeb application. Let’s take the attached workbook used to calculate a patient’s medical risk based on family and own medical conditions. Note...

Multi-Level Header Support for Designer Applications

This tutorial shows how to create multi-level columns in designer applications, effectively 'categorizing' columns into multiple levels. A typical example is a monthly data table grouped into quarterly sections. We're going to be using a monthly table and...

Print Process in Designer Applications

Print Process in Designer Applications

SpreadsheetWEB designer applications allow using a Microsoft Word (*.DOCX) document to create export documents in PDF or Word formats. This functionality can be tied to an Action button in the application and the print process will be triggered every time...