Shortcodes for Table Configuration

You can use shortcodes when using a spreadsheet to configure a table, or from within a table when it is 'Open'. 

Shortcodes are optional snippets of text that will automatically set rows and columns to be checkboxes or text. This saves the step of opening the table and editing the row or column types individually.

Shortcodes can be used to set entire columns when placed in a column header cell, or entire rows when placed in the left-most cell of a row. They can also be used to set individual cells when added to text in cells. 

Available shortcodes

{chk}  to set a row or column as checkboxes.

{txt}  to set a row or column as text (text is the default cell type when uploading Excel spreadsheets).

{lock}   to prevent people with the roles Guest and Privileged Guest from editing table cells.

{unlock}  unlocks locked table cells.

{issue}  if the cell is a checkbox, when "checked" a new issue will be automatically created.

{req-OR-xx}  defines cells to be included in a validation rule using an OR operator. xx defines the group of cells for this validation rule. (learn more about validation rules)

{req-AND-xx}  defines cells to be included in a validation rule using an AND operator. xx defines the group of cells for this validation rule. 

Example: All cells in these columns will be set as checkboxes when the spreadsheet is uploaded to a table.

Example: Locking or unlocking a column of table cells.