Welcome to SpreadsheetWEB Blog
Data Import Feature in SpreadsheetWeb Hub
In some cases, you may need to transfer a batch of data to your SpreadsheetWeb Hub applications at once and do not want to waste time by creating individual records. SpreadsheetWeb Hub has a new feature that will meet this need: Data Import. The Data Import feature...
Incorporating Calculations into Zapier
Use case: Basic Tax Calculation using Lookup Tables The tax brackets can be confusing to work with. Different ‘levels’ of your income needs to be multiplied with a different percentage to find the total. When you want to do tax calculations in Zapier, you are limited...
Record Suggestion Feature in SpreadsheetWeb Hub
Some applications require users to submit data and need to update it at a later time. For example, a large registration form may require users to enter data at multiple sitting. Another use case is submitting financial data that may require multiple iterations through...
Say Hello to the World of No-Code!
If you are asking the question “What is No-Code”? You will find the answer in this article. In our daily life, nearly everything is powered by code. We can give some common examples like searching on the internet, posting things on social media, shopping on our...
How to Empower Human Resources Spreadsheets
Spreadsheets have become the go-to solution for Human Resources (HR) departments for managing, sharing, organizing, and analyzing all kinds of information. A lot of HR professionals are still using spreadsheets as their default tool. Excel has proven to be a perfect...
Connect Your Spreadsheet Models to Thousands of Services using Zapier
Zapier is a popular online, no-code automation tool that enables businesses to create workflows by linking applications and services that they are already using together. Companies don’t need to build those complex integrations themselves or hire developers to build...
Converting an Insurance Rating Spreadsheet into a No-Code API
Excel spreadsheets are heavily utilized across the insurance industry due to their capacity for coding complex formulas and business logic through worksheet formulas. One of the main use cases for insurance spreadsheets is to provide calculations for premiums that are...
Building Scored Questionnaires with SpreadsheetWeb Hub
Businesses often use Excel to build questionnaires especially if there are many questions or if they need scoring calculated based on user responses. Excel’s user-friendly interface makes is easy to build such questionnaires. But collecting answers from users and...
A Use Case of Excel's LAMBDA Function in SpreadsheetWeb: Splitting Text by delimiter with LAMBDA Function
SpreadsheetWeb Hub supports Excel's LAMBDA function. The recently released LAMBDA function allows Excel users to build custom, reusable functions without VBA. There are so many use cases of the LAMBDA function. In this article, we will create a LAMBDA Function to...