2. Features

Per table (in Edit mode)

• Change number of rows/columns per table (even within multi-value instances). Optionally restrict that to users with the permission ‘Rebuild tablefied’ (see field settings below).
• Rows can be rearranged with drag and drop.
• Upload a CSV file to be converted into a table on the fly. The used separator can be defined at …/admin/config/content/tablefield.
• Copy paste tables e.g. from Excel.
• Add a table caption.
• Easily remove tables from a multi-value field with the button. Just install and enable https://www.drupal.org/project/multiple_fields_remove_button.

Per field (field settings)

For nodes field settings for some of the below options can be found through ‘manage fields’ at …/admin/structure/types. For others entities see above.

• Restrict rebuilding to users with the permission “rebuild tablefield”
• Lock table header so default values cannot be changed.
• Table cell processing (radios)
  • Plain text
  • Filtered text (user selects input format)

Per display mode (display settings)

For nodes display settings for the below options can be found through ‘manage display’ at …/admin/structure/types. For others entities see above under ‘GET STARTED’. Display options can be set per view mode e.g. ‘Default’ or ‘Teaser’.

The options of all of the below settings are ‘Yes’/‘No’ (checkbox) unless stated otherwise.

Tabular view

• Sticky header
• Hide table header
• Hide empty columns ignoring column header
• Trim empty trailing rows
• Trim empty trailing columns
• Hide empty rows
• Hide empty columns
• Show link to export table data as CSV depending on permission

Raw data (JSON)

This format is intended to provide table data as a service. For example when using a View that outputs JSON the field configuration includes ‘Formatter’. When choosing ‘Raw data (JSON)’ it shows the below options.

• Use first row/column values as array keys (if not empty). (select)
  • No
  • Header only
  • Both first row and first column (two headers)
• Vertical header (first column instead of first row)
• Table data only (no caption)

Using this format for a display mode for a node content type will display the JSON in pretty print. More logical is to use the regular ‘Tabular view’ for the node display and use the ‘Raw dat (JSON)’ display only in a View. That would expose the date of published tables on a site automatically as a service.