📁 Reference
Backend
Spreadsheets

Spreadsheets

A spreadsheet refers to a flexible and collaborative database that combines the familiarity of a spreadsheet interface with powerful features of a database, enabling users to organize, manage, and collaborate on data in a visually intuitive manner.

Details

The admin can add a name, label, select filter tags, and description or select searchable/queryable fields in a spreadsheet.

Searchable fields can be searched through search bar in the app.

Queryable fields can be used in reporting.

Partition

The admin can add a partition in a spreadsheet. Partitions are used to group data or make partitions in a spreadsheet.

Imagine you have an order spreadsheet with orders from 2023, and you want to group the orders based on month name. Partition helps us fulfill this requirement.

Layout

Similar to grid layouts, a spreadsheet layout defines a structural arrangement for your spreadsheet. Following are the four types of spreadsheet layouts:

  • Card layout

    Card layout is a way of displaying spreadsheet data as cards as seen in e-commerce platforms.

  • Kanban layout

    A Kanban layout refers to an organizational method where tasks or items are visualized on a board, usually with columns representing different stages of a process.

  • List layout

    List layout is a way of displaying spreadsheet data in a vertical list format, where each item is presented one below the other.

  • Table layout

    A table layout in a spreadsheet involves organizing data into rows and columns, with headers at the top.

Spreadsheet layout is applied to the entire spreadsheet. A grid layout is applied only to a grid inside a form.

Permission

Accessibility

Admins can add insert, update, read, remove or audit trail role based permissions in a spreadsheet.

Duration

Admins can restrict access to specific users, control read-only permissions, or allow users to bypass restrictions in a spreadsheet.

Forward candidates

Admins have the ability to permit the forwarding of a spreadsheet to a specific role or group of individuals.

A form message bubble sent in a group is stored in a spreadsheet as a row with all its information.