Column Settings

Throughout Momentus Enterprise screens, you can:

Show Columns

To show columns:

  1. Right-click on the screen’s column headers.
  2. Select Show Columns. The Column Settings screen opens.
  3. Locate the column(s) to display in the Available section on the left. 
  4. To show one column, click the green plus (+) sign to the left of the column name. To show multiple columns:
    • Use Ctrl+Click or Shift+Click to select the column(s) to show.
    • Click the right arrow button to move the selected column(s) to the Selected section on the right. Click the double right arrow button to move all columns to the Selected section.
  5. Use the arrows to the right of the Selected section to set the order the columns display on the screen.
  6. Click OK.

Hide Columns

To hide a single column: 

  1. Right-click on the column header of the column to hide.
  2. Select Hide Column.

To hide multiple columns:

  1. Right-click on the screen’s column headers.
  2. Select Show Columns. The Column Settings screen opens.
  3. Use Ctrl+Click or Shift+Click to select the columns to hide from the Selected section on the right.
  4. Click the left arrow button to move the columns to the Available section on the left. Click the double left arrow button to move all columns to the Available section.
  5. Click OK.

Change the Column Order and Width

You can change the order of the columns on the screen by clicking on the column header of the column and dragging it to the position you want it to display in. Once the column is in the correct position, a dark line displays indicating that you can drop it in the location. Release the mouse button and the column is placed in the selected position.

You can change the width of a column by clicking on one of the column borders and pulling it to the desired width. This works the same way as Microsoft Excel. 

Sort Information in Columns

To sort a single column, click on the column header of the column to sort. After clicking on the column header, an arrow and number displays to indicate that the column is sorted. A down arrow indicates the column is sorted in descending order and an up arrow indicates the column is sorted in ascending order. The number indicates the order the column is sorted in with 1 being first, 2 being second, etc.

You can also adjust the column sorting by:

  1. Right-click on the column headers.
  2. Select Sort, Group and Total. The Column Settings screen opens with the Sort, Group and Total tab selected.
  3. Select the column to sort in the Sort By drop-down. 
  4. Select the direction for the sorting from the Direction drop-down.
  5. Click the Add button to continue adding columns to sort. You can drag and drop the Sort By groups or use the up and down arrows on the left to change the sort order. Use the red X to remove a column sort.
  6. Click OK when complete. 

Group on Columns

You can group columns to create a better view of the information. 

  1. Right-click on the column headers.
  2. Select Sort, Group and Total. The Column Settings screen opens with the Sort, Group and Total tab selected.
  3. Check the Group on this column check box for the column to group on. 
  4. Select your desired font style and font color for the group header from the Font Style and Font Color drop-downs.
  5. Click OK.

Expand and Collapse Groupings

You can expand a column grouping to show all the records in the group or collapse a column grouping to hide all the records in a group.

To expand all the groups, right-click on the column headers and select Expand All. You can also use the asterisk (*) to the very left of the column headings to quickly expand all groupings. To expand a single group, click the arrow next to the group in the screen.

To collapse all the groups, right-click on the column headers and select Collapse All.  To collapse a single group, right-click on the column headers and select the group to collapse, for example Collapse To City.

Show Row Counts

You can display the total number of records within a grouped column. This is called a Row Count. To configure a grouped column to display a row count:

  1. Right-click on the column headers.
  2. Select Sort, Group and Total. The Column Settings screen opens with the Sort, Group and Total tab selected.
  3. Check the Show group row count check box for the groups that need a count. The row count displays in the same font formatting as the group.
  4. Check the Show grand total row count check box in the Grand Totals section to display a row count for all records in all the groups. The grand total count displays in regular black font.
  5. Click OK.

Show Subtotals and Grand Totals

You can display subtotals and grand totals for numeric columns. You can only subtotal on grouped columns.

  1. Right-click on the column headers.
  2. Select Sort, Group and Total. The Column Settings screen opens with the Sort, Group and Total tab selected.
  3. Select the columns to subtotal from the Display group subtotals for drop-down within each column grouping. You can only select from numeric columns. The subtotal displays in the same font formatting as the group.
  4. Select the columns to grand total from the Display grand totals for drop-down in the Grand Totals section of the screen. The grand total displays in regular black font.
  5. Click OK.

Text Wrapping

You can turn text wrapping on and off for a column. To turn text wrapping on, right-click on the column header and select Toggle Text Wrapping. To turn text wrapping off, click on the same column header and select Toggle Text Wrapping again.

 

Select All Records

You can click on the square to the very left of all the column headers to select all records in a list. This highlights all the displayed records in the list.

mceclip1.png

Related articles

Comments

11 comments

Date Votes
  • Caroline Grzesniak

    Hi there, is it possible to add the same column twice? We are already using the "User Text" column, but would like to add another one of the same?

     

    Thank you.

    0 upvotes

  • Maggie U.

    Hi Caroline,

    Showing the same information twice as a column on a screen isn't possible but depending on where you want to capture and view additional information, it may be possible to create a user defined field.  Check out the Configuring Custom Fields/User Defined Fields (UDFs) article to see if this may work for what you need.

    Thanks,

    Maggie

    0 upvotes

  • Lee Tickett (Tickett Enterprises Limited)

    Caroline, I'm not 100% following what you are trying to achieve, but you can create custom fields (of type formula) which can be used to duplicate other fields.

    0 upvotes

  • Permanently deleted user

    Is it possilbe to lock/freeze columns, as you can do in Excel? We have a wide view in Events, would be a great opportunity. 

    0 upvotes

  • Sam Wilson

    This is not currently possible within Ungerboeck. Consider adding it to the Community as a potential enhancement request.

    Regards,

    Sam

    0 upvotes

  • Don Leddy

    Good day,

    Is it possible to lock a column width?

    1 upvotes

  • Sam Wilson

    Hi Don,

    Locking a column width is not currently supported. 

    Regards,

    Sam

    0 upvotes

  • Nina Dennison

    I want to add a Column that we can add Details without having a pop-out box. Is it possible to add a UDF that allows us to Edit a field of information on the screen instead of it opening another box of information??  Example, I see the "Location" & Description fields have this capability but the "Notes" pops up a separate box for us to add information. This is cumbersome when I have a few short details to add to each line. 

    Thanks

    0 upvotes

  • Mike Johnson

    Nina - Can you provide more detail on your request?  What area of the software are you referring to?  If I'm following you, it sounds like you are wanting to enter a note in the grid on a certain record but I would like to confirm that.

    0 upvotes

  • Nina Dennison

    Hi Mike, The example below, the Description column is Editable, but the other column options are not. I've tried Alternate Description 2 (no column appears) and Details column but it pops open a screen like Notes. We're trying to just write details on the same screen. We need 2 more columns like the Description column to write on for our agenda. 

     

    0 upvotes

  • Sam Wilson

    Hi Nina,

    Functions have a standard field labeled User Text that will allow text entry from the Functions grid. The field can be relabeled according to your preference by modifying the dictionary phrase. However, this is only a single field. 

    The Alternate Description fields weren't designed for this purpose, but you could certainly try them out to see if they meet your needs. It sounds like they may need to be enabled in your database. These are controlled by organization parameter Allow Alternate Desc Usage (AA 010).

    If the combination of User Text and Alternate Description fields doesn't quite meet your needs, please consider submitting an enhancement request.

    Regards,

    Sam

    0 upvotes

Please sign in to leave a comment.