Views and Layouts

Views define what users see when they interact with your NExS app. This guide covers how to configure views, work with multiple views, and control navigation.

What is a View?

A view is a rectangular range of cells from your spreadsheet that users can see and interact with. Think of it as a “window” into your workbook.

This creates a view showing cells A1 through G18 on Sheet1.

Defining Views

Basic View Definition

In your NExS.app worksheet:

Using Named Ranges

You can reference a named range instead of cell coordinates:

Where MyDashboard is a named range in Excel pointing to Sheet1!A1:G18.

Entire Worksheet

To include an entire worksheet as a view, specify just the sheet name:

Default Sheet

If you omit the sheet name, NExS uses the first worksheet:

View Options

Naming Views

Give your view a descriptive name (appears in the view navigation menu):

Background Color

Set a background color for the entire view. This helps eliminate “ghost lines” between cells on some browsers:

You can specify colors as:

• Color names: white, lightgray, navy
• Hex values: #f5f5f5, #336699
• Cell reference: A1 (uses that cell’s background color)

Multiple Views

Create apps with multiple views for complex workflows or different audiences.

Example: Multi-Page Form

Users see a dropdown menu to switch between “Personal Info”, “Vehicle Info”, and “Your Quote”.

Hiding the View Navigation

If you want to control view switching yourself (via buttons or JavaScript), hide the built-in menu:

Public Views

When building Team mode or Access Code apps, you often need some views to be publicly visible while others require authentication. Setting public to true on a view lets anyone see it without logging in, while other views remain protected.

Consider a competition scoring app: judges log in with access codes to enter their scores on a private panel, while spectators watch results update on a public scoreboard—no login required.

Hidden Views

Sometimes you need NExS to process data without displaying it. Hidden views never appear in the UI but remain accessible through the JavaScript API, making them useful for storing configuration values, reading intermediate calculations, or building completely custom interfaces where your own HTML handles display while NExS provides the calculation engine.

With this configuration, the “Settings” view won’t appear in any navigation menu, but your JavaScript can still read from and write to its cells.

Layout Tips

Sizing for Your Audience

Think about where your app will be used. Desktop users benefit from larger views (800×600 pixels or bigger) that take advantage of screen real estate. Mobile users need narrow layouts—keep views under 350 pixels wide so they don’t require horizontal scrolling. For embedded widgets in website sidebars, compact views work best since they share space with other content.

Using Multiple Worksheets

Complex apps benefit from spreading content across multiple Excel worksheets. This keeps each sheet focused and makes your workbook easier to maintain:

Cells outside all views remain hidden—use them for intermediate calculations, lookup tables, or configuration.

Next Steps

• Inputs and Forms — Configure editable cells
• Deployment Modes — Control who can access your views
• UI Components — Add buttons for view navigation