Rearrange Columns and Modify Width To rearrange your fields (columns) you can simply click and hold to move one column in front of another. In addition, you can adjust the width by clicking the divider between fields (columns) and dragging to the left or right. You can also auto-size by double clicking said divider.
The first column in a View will be the Record ID – the clickable, visual identifier of the data. This is equal to a field or a combination of other fields. As it may display redundant information, it is possible to shrink this column to only display a small clickable icon by shrinking the width of this column.
Modify Column HeightTrackVia rows, which display individual records, will automatically and dynamically expand based on the height of the data to a height of up to 20 lines. Additionally, Editing a View and navigating to the Format Tab will provide options to set a custom Height for the rows of Records.
Field Options To open the options for a given field, hover your cursor over the field and click the gear icon indicated in the image below.
The options available include:
Hide Column - Do not show column in view
Dock Column - Column will always be visible on the left, even as your scroll to the right (if all of your columns do not fit on the page)
Sort - Choose to sort your records based on this column. You can further designate what sorts take precedence.
If you choose to sort a Name field 1st and a date field 2nd, your records will order by Name field, and when there are multiple records with the same name, it will order those by date.
One of the most useful features of the grid view is the ability to edit records without actually opening them. This can save a tremendous amount of time when you are making changes to many records.
Clicking into a field will highlight the field in blue. If there is a value in the field, you will be presented with an “X” to delete its contents. If you simply wish to make a change to the value, start typing or place the cursor where you wish to insert data.
Note: Limited roles will only be able to edit the fields they have been given permission to edit on the form assigned to that view.
After you have made the necessary changes, you will have four options:
1. Pressing Enter - This will save the new value and place the editing focus on the field directly below it.
2. Pressing Tab - This will save the new value and place the editing focus on the field directly to the right of it.
3. Clicking into another field - This will save the value and place the editing focus on the field you clicked into
4. Clicking anywhere else on the page - This will save the value
Each change made in the grid view is automatically saved. Once the changes are submitted, an on screen notification will alert you that the record was saved and display a summary of the change. The summary also allows you to click undo if there is an error.
Admin level users also have the ability to export grid views to a Microsoft Excel (.xlsx) file. This may be accomplished from the App Overview by clicking on the Export link next to the view.
Note: You currently cannot export chart and summary views. If you are looking for this functionality, post the details of what you would like (or vote for it) in our Ideas Forum.
Additionally, you may export directly from each view by clicking into the Menu, then select Export View.
When in a view, there is a link titled Filter that allows you to quickly filter the data down to what you would like to see:
This is a great alternative to searching the entire table. Quick Filters allow you to further refine a collection of records in a specific view. Whether you need to make a quick list of open projects, or filter an existing report by an Account Rep, quick filters make this an easy process. They are available to all TrackVia plans and all user types. Learn more about how to use quick filters by clicking here.
You can share valuable information with people outside of your organization directly from any view. From the view Menu, select Share View. The next screen will allow you to specify email recipients, a custom subject, and add a custom message for the recipient.
When accessing a View, there are three horizontal lines that serve as the Menu for the View. Clicking on this will display additional features for a View. The menu will show all available options for the specific view you are accessing.
Lanes - If your view contains a Drop down field, you will have the option to enable the Lanes feature.
Map of Created Records - If your view has the Location at Creation field, then you will see Maps as menu option.
Blog Articles and Tips & Tricks
TrackVia Grid View: Time for Some Updates
TrackVia: Views and Filters
TrackVia: Working With Views and Filters
TrackVia Express: How to Create Summary Reports
TrackVia: How to Use Reports