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 columns to be checkboxes or text. This saves the step of opening the table and editing the column types individually.

Shortcodes set an entire column when placed in that column's header cell.

Available shortcodes

{chk}    to set a column as checkboxes.

{txt}    to set a 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.