Xano - Keyboard Shortcuts

As a no-code platform, Xano empowers you to build and deploy backend services without writing a single line of code. One of Xano's powerful features is the spreadsheet viewer, which allows you to interact with your database tables in a familiar spreadsheet-like interface. To enhance your efficiency while working with the spreadsheet viewer, Xano provides a set of keyboard shortcuts that can streamline your workflow. In this blog post, we'll guide you through these handy shortcuts, making it easier for you to navigate, edit, and manage your data with ease.

Adding Columns and Rows

Let's start with the basics: adding new columns (schemas) and rows (records) to your database table.

Adding a New Column

To add a new column, simply press Ctrl + Enter. This will open a window displaying various field types. Use the up and down arrow keys to navigate through the options, and once you've selected the desired field type, press Enter to proceed. You can then provide the necessary details for your new column. If you change your mind, hit Escape to return to the field type selection.

Adding a New Row

To add a new row (record), press Shift + Enter. This shortcut will instantly create a new row in your database table, allowing you to populate it with data.

Navigating and Editing Cells

Now that you've added columns and rows, it's time to navigate and edit your data efficiently.

Navigating Cells

Use the arrow keys (Up, Down, Left, and Right) to move between cells in the spreadsheet viewer. Alternatively, you can press the Tab key to advance to the next cell sequentially, or Shift + Tab to move backwards.

Editing Cells

To edit the content of a cell, simply navigate to the desired cell and press Enter. This will allow you to modify the cell's value. While editing, press Shift + Enter to insert a new line within the cell's content. Once you've finished editing, press Enter again to save your changes and move to the next cell.

Reverting Changes

If you make a mistake while editing a cell, simply press Escape to revert the cell's content to its original value before you started editing.

Deleting Cell Content

To clear the content of a cell, navigate to the desired cell and press the Delete key.

Selecting and Copying

Working with selections and copying data is a breeze with these shortcuts:

Selecting Rows

To select an entire row, position your cursor within any cell of that row and press the Space bar. Press Space again to deselect the row.

Copying Cell Content

To copy the content of a cell to your clipboard, navigate to the desired cell and press Ctrl + C. You can then paste the copied content wherever you need it.

By mastering these keyboard shortcuts, you'll be able to interact with your database tables more efficiently, saving time and boosting your productivity. Whether you're a no-code enthusiast, citizen developer, traditional developer, or part of a startup or small business, these shortcuts can streamline your workflow and enhance your experience with Xano's spreadsheet viewer.

Give them a try and watch your productivity soar!