Loading...
Start a 60 day Free Trial

You are viewing a membermojo help page. Take a tour to see what we do.

Using Tables

Tables are used on several pages to provide a convenient and compact method for viewing and editing many rows of data. Displayed data can be viewed full screen, sorted, filtered, copied, pasted and navigated using the keyboard - much like a spreadsheet.

Hover your mouse over to see column descriptions.

Sorting

Click on the column header to sort first in ascending order, then descending, and again to remove the sort.

Filtering

Type any filter text into the text box just above the column headers. Surround the text with double-quotes for an exact match.

Only rows containing the text will be displayed and the row count updated.

Cancel the filter by clicking .

Editing

Select the cell you wish to edit using the cursor keys or by clicking. To change its value double click, or click , or on a tablet or phone touch the cell and hold. Complete the edit by clicking elsewhere or pressing RETURN or TAB. No changes are made to the database until Save is clicked.

If the changes cannot be saved the rows and cells in error will be highlighted. Use and to review and correct each error, then click Save.

Use and to undo or redo individual changes. To abandon all current changes click Reload.

Some tables allow rows to be added and deleted:

  • Click to add a new row at the bottom of table.
  • Click to remove the currently selected row.

Full screen

Click to maximise the table within the browser window and use to restore.

Copy and Paste

Individual cells can be copied and pasted using your system's normal keyboard shortcuts. Ctrl+C and Ctrl+V on windows, Cmd+C and Cmd+V on a Mac.

To paste the same value to multiple cells in the same column repeat the paste. Each successive paste will move the selection to the row below, then update the cell with the same pasted value. Hold down the paste key to auto-repeat.

To copy all visible rows from the current table click More / Copy Table to Clipboard then Ctrl+C or Cmd+C. Then paste directly into a spreadsheet.

See Importing Members for instructions on copy and pasting multiple member rows from a spreadsheet.

Read only columns

Columns with a grey background are read-only and cannot be changed.

Column selection (member tables only)

Columns and default sort order can be changed on member tables by clicking More / Change View/Columns.

For more on member list views see Member List Views.

Keyboard Shortcuts

To move the current cell selection:

  • Cursor keys - move selection
  • Ctrl+cursor keys - move selection to edge
  • Ctrl+HOME / Ctrl+END - move selection to first/last cell in table
  • PGDN / PGUP - move selection by one page

Editing:

  • F2 / Ctrl+U - edit the selected cell
  • SPACE - toggle selected yes/no
  • DELETE - blank current text cell
  • TAB - complete edit and move selection right
  • ENTER - complete edit and move selection down
  • Ctrl+Z / Cmd+Z - undo
  • Ctrl+Y / Cmd+Y / Shift+Cmd+Z - redo
  • Ctrl+S - save
  • Ctrl+A / Cmd+A - new row

Filter:

  • Shift+Ctrl+F / Shift+Cmd+F - move cursor to the filter text box

Related topics:


membermojo Help