In this article:
From the Project area, click on a Grid to open it.
Navigation
Use the header to quickly navigate between Grids and Versions. The header displays the current Project > current Database > current Grid > current Version.
Click on the Gridly logo, or the Project name to return to the Project area.
Click on the Grid name to open another Grid (you can open Grids in the same Database from the header).
Click Master to view or open another version of the current Grid (refer to Version control).
Toolbar
- Views - select a saved view, or save the current view (columns hidden/unhidden, filters applied, data sorted, path tags) by clicking Access View.
-
Columns - use Find a column to quickly search for a column, select and deselect columns to View/Hide Data, and Edit/Read Only Data. If a column is set to View Data, but not Edit Data, a lock (Read only) sign is displayed in the header
-
Filter - filter columns by the values contained (e.g. words, numbers, selections or boolean), or columns with dependencies where text needs to be retranslated (refer to Dependencies).
-
Sort - Sort by column data, from A to Z or from Z to A.
-
Path Tag - add, create, group tag by, set colour, delete (Path Tag pane opens on the left hand side).
-
Create column - create a new column on the far right of the Grid. Click and drag the column to re-position.
Note: by default, a new row is formatted as Multiple lines, refer to Data types to select the correct format.
-
Create record (row) - create a new record at the bottom of the Grid.
-
Dependency - refer to Dependencies.
-
Fill color - choose a fill color for a cell, record (row) or column.
-
Text wrapping - click to wrap selected text (increases row height).
-
Add comment - add a comment against the selected cell. An orange indicator will show on any cells with unresolved comments.
Click on the cell to view comments, reply or mark Resolved (similar functionality to Google Docs files).
-
Export - export the Grid. Refer to Export.
-
Import - import to the Grid. Refer to Import.
-
Localization import/export - import or export localization data from/for translators (select target language(s)).
Import a Grid
To import data to the grid (add records to the bottom of existing grid, update existing records and skip new, or update existing records and add new):
- Click the Import icon.
-
The Import Data box will appear.
-
Select an import option from the drop-down menu.
-
If the first row of the imported file contains data (not a header), toggle the First row of imported file is headers option.
-
Map each of the imported columns by clicking What is this column?, and select the applicable column from the drop-down menu (these are the existing columns in the grid).
-
For a simplified view, select the list view icon on the right hand side.
-
Once all the columns you want to import have been mapped, click Import.
Edit a Record
Double click on a cell, hit Enter, or just start writing to edit it.
Right click on a cell to view the cell menu.
-
Add comment - click to add a comment against this cell. An orange indicator will show on any cells with unresolved comments.
Click on the cell to view comments, reply or mark Resolved (similar functionality to Google Docs files).
- Text wrapping - click to wrap text (increases row height).
- Record history - click to view record history (opens in a separate pane at the bottom of the screen).
- Approve automatically populated text - this option will be available if you have used the Localization wizard to import a grid, and Gridly has automatically populated text using Translation Memory. Click to approve the translation.
Reorder columns
To reorder columns, select a column (click on the left border of the column) or multiple columns (hold the shift key and click on multiple columns), drag records and drop them at the desired location.
Read next: Version control and branching