Skip to main content

How do I create and customise grid views?

Create custom grid views to organise your cap table, equity plans, and stakeholder data with filters, grouping, and column configuration.

Frances Agoncillo avatar
Written by Frances Agoncillo
Updated this week

Introduction

Grid views in Ledgy let you organise and display data in a way that suits your workflow. You can customise the columns shown, group data by specific fields, apply filters, and sort entries — then save these configurations as custom views for quick access. This article explains how to create, manage, and delete custom grid views.

Accessing grid views

Grid views are available across several areas of Ledgy where data is displayed in a table format, such as the Cap table, Transactions, Stakeholders, and Plans pages.
At the top of any grid, you'll see a view selector that lets you switch between the default (preset) view and any custom views you've previously saved.


Customising the grid

Before saving a custom view, you can adjust the grid layout to display exactly the data you need.

Adding and removing columns

  1. Click the Columns button in the grid toolbar on the right

  2. A panel will appear listing all available columns.

  3. Tick the checkbox next to a column name to add it to the grid, or untick it to remove it.

  4. You can also drag columns in the grid header to reorder them.


Grouping data

To group data on the grid, you first need to ensure the property you want to group by is enabled as a visible column. Once the column is visible in the grid, you can group the data by dragging and dropping the column header to the grouping area at the top of the grid.

  1. Make sure the property you want to group by is added as a column in the grid (see Adding and removing columns above).

  2. Drag the column header and drop it into the grouping area at the top of the grid.

  3. The grid will reorganise into collapsible groups based on the values in that column.

  4. You can expand or collapse each group to show or hide the data within it.

  5. To add multiple groupings, drag additional column headers into the grouping area. The data will be grouped hierarchically — first by the first column, then by the second, and so on.

  6. To remove a grouping, drag the column header back out of the grouping area or click the remove icon next to the grouped column name.


Sorting data

  1. Click on a column header to sort the grid by that column.

  2. Click again to toggle between ascending and descending order.

  3. A sort indicator will appear on the column header showing the current sort direction.


Filtering data

  1. Click the Filter button in the grid toolbar.

  2. Select the field you'd like to filter by.

  3. Choose a condition (e.g., equals, contains, does not contain, greater than) and enter the value.

  4. You can add multiple filters to narrow down results further.

  5. To remove a filter, click the X next to the filter tag, or clear all filters at once.

Filtering by date columns

Date column filters offer a Filter type dropdown with three options:

  • Range — filter by a specific date range (this is the default). Select a start date, end date, or both to show records within that period.

  • Is empty — shows only records where the date field is blank. This is useful for identifying incomplete data, such as grants without a signing date.

  • Is not empty — shows only records where the date field has a value filled in.

This works on all date columns across every grid view in the app. For example, you could filter a grants table to show only grants with no signing date, making it easy to follow up with the relevant stakeholders without needing to export data.


Filter conditions

The available filter conditions depend on the column type. Common conditions include:

  • Contains — shows records where the field includes the specified text.

  • Does not contain — shows records where the field does not include the specified text. This is useful for excluding specific entries, such as filtering out grants with a particular plan name or stakeholders from a specific group.

  • Equals / Does not equal — matches (or excludes) exact values.

  • Greater than / Less than — for numeric and date columns.

  • Is empty / Is not empty — for identifying records with missing or filled values (see Filtering by date columns above for date-specific usage).


Saving a custom view

Once you've customised the grid to your liking, you can save it as a custom view for quick access later.

From a default (preset) view

When you make changes to a default view — such as adding columns, applying filters, or grouping data — two buttons will appear in the toolbar:

  • Save as new view — saves your current configuration as a new custom view.

  • Revert — discards all changes and returns the grid to the default view layout.

To save:

  1. Make your desired changes to the grid (columns, filters, grouping, sorting).

  2. Click Save as new view.

  3. Enter a name for your view in the dialog that appears.

  4. Click Create to save.

From an existing custom view

When you're viewing a custom view you created and make changes to it, three buttons will appear in the toolbar:

  • Save as new view — saves the changes as a separate new view.

  • Update view — overwrites the current custom view with your changes.

  • Revert — discards all changes and returns to the last saved state of the custom view.

To update the existing view:

  1. Make your desired changes to the grid.

  2. Click Update view to overwrite the current custom view with the new configuration.

To save as a different view:

  1. Make your desired changes to the grid.

  2. Click Save as new view to create a separate custom view instead.

Note: The Update view button is only available if you are the creator of the view or have an owner role.


Deleting a custom view

You can delete any custom view that you have created or, if you have an owner role, any custom view in the company.

  1. Select the custom view you'd like to delete from the view selector.

  2. Click the Delete view button that appears in the toolbar.

  3. A confirmation dialog will appear — click Delete view to confirm.

The view will be permanently removed and the grid will revert to the default view.

Note: Default (preset) views cannot be deleted. The Delete view button only appears when viewing a saved custom view.


Switch between views

Switching between custom views is easy when you have built multiple views for several use cases and different stakeholders. Click the drop-down button and navigate between the pre-created or custom views.


Exporting custom views

You can download and share your customs views/reports with others by clicking on the "Export" button.

You can export your cap table (Ownership > Cap Table) as an Excel or PDF file. See full guide on exporting here.

Tips

  • Custom views are a great way to set up frequently used layouts — for example, a filtered view showing only active grants, or a grouped view organised by stakeholder type.

  • Use the Is empty date filter to quickly identify records with missing dates — such as grants without a signing date — so you can follow up without needing to export data.

  • Company views are shared with all collaborators, so any changes you save will be visible to your team.

  • If you want to experiment with a layout without affecting a saved view, make your changes and simply click Revert to go back.


If you have any questions or specific requirements, please email [email protected].

Did this answer your question?