Importing values into Checkboxes fields
GravityImport can fill a Checkboxes field from your file in two ways: a column for each choice, or one column for the whole field.
A column for each choice #
On the Map Fields step, map each column to one of the field’s choices. A cell checks that choice when it holds the choice’s label (or its value, if the field has Show Values turned on) or one of these words: 1, true, or yes. Upper or lower case doesn’t matter.
Any other content leaves the choice unchecked, including 0, false, null, no, and an empty cell. A file exported from the Numbers app for Mac and iOS, which writes its checkbox cells as TRUE or FALSE, imports without changes.
Developers can change which values leave a choice unchecked with the gravityview/import/column/checkbox/unchecked filter.
One column for the whole field #
With GravityImport 2.12.3 or newer, one column can fill the whole field. On the Map Fields step, map the column to (Any Choice) under the field’s name. Each cell can then list several choices separated by commas, such as friday, saturday, and each one that matches a choice is checked.
To separate the choices with another character, such as a pipe, developers can change the separator with the gk/gravityimport/column/checkbox/delimiter filter.
