Column Settings

These options depend on the type of column and therefore are not always available. For example, very few options apply to automatic columns.

To modify column options, click on the 3 dots in the column’s header, then "Settings" in the menu.

On the screen above, you also have access to options to modify the behavior of the columns. For example, you can make data entry mandatory in a column, specify a default value, hide a column or make it read only, require user to enter a different value for each row or add constraints on numerical values (e.g. minimum and maximum value, number of digits displayed after the decimal point).

Options that apply to (nearly) all Column Types

Subtitle

You can describe your columns to make your tables more readable and easier to understand for your users.

The subtitle allows you to add additional information to the column. It’s displayed permanently below the title (here: "PDF or DOCX"):

Mandatory Columns

This is probably the most commonly used setting. When this option is activated, the cell has to be filled or the row will not be saved. The user will have visual guidance to understand that this column has to be filled in order to validate the row.

You can make a column mandatory from the menu column, without leaving the table page.
No data is saved in a row if unless all mandatory columns are filled.

Unique Value

If this option is activated, two rows can not have the same value in that column.

Default Value

When creating a new row, or resetting a cell value, the Default Value is entered automatically. The user can then override or delete it.

Column Types

The Column Settings page also lets you specify the type of information you expect in each column. Choose text, date, numbers, comments, formulas... to guide and restrict data entry at the same time. Click here to learn more about our data types.

Column Permissions

On top of RowShare advanced row-based permissions system, you can set rights on columns. If you don't, by default, row permissions apply to determine if a given user can see and/or write a row.

You can set a column as hidden or read-only:

  • Column is hidden for contributors: The column is hidden for all users of the table except the table owner(s). When this option is activated a specific icon will appear next to the column name as shown below.
  • Column is read-only for contributors: The column can be modified only by table owner(s). Other will see that column as read-only. When this option is activated a Lock icon will appear next to the column name.
You can't define column permissions per user or per group. Column permissions differentiate two kinds of users:
- table owners (and subscription admins)
- all other users

Options that apply only to specific Columns

Lists of Options

Lists are the columns that offer the most options:

  • Define the list of authorized values
  • Specify a color for certain values to make your tables more visual
  • Allow multiple selections: allow cells to contain more than one selected value (like the Description column in the example above).
  • Compact Cells: By removing the margins in the cells, you can create narrower columns to fit as much as possible on the screen (like the Status column in the example above).
Changing the Allowed Values does not change the values already entered in the table.
Lists linked to another list can not be colored.

Number Columns

The various columns containing numbers provide a set of options to guide user input, limit accepted values or specify how the numbers are displayed. Here are the available options:

  • Minimum value
  • Maximum value
  • Show the thousands separator
  • Number of decimals

These options are not available for other column types.


How did we do?


Powered by HelpDocs (opens in a new tab)