Creating custom spreadsheets

If one of the many Object spreadsheets provided, does not meet your specific case needs, you can create a custom sub-object spreadsheet. You can create as many custom spreadsheets as you like. Each custom spreadsheet name must be unique and requires both a singular and plural name. Adding a new spreadsheet does not affect any current spreadsheet views or any filter currently applied to a spreadsheet.

New custom spreadsheets contain five default fields: Full Name, Short Name, Role In Case, Key, and # Facts. You can add additional fields to the new spreadsheet as needed.

When a new spreadsheet is added, you can begin using it as you would other spreadsheets. You can send data to it immediately using the Send to CaseMap tool. And you can create a report from the current view to add to an existing ReportBook.

Adding custom spreadsheets is an exclusive process. All other users must be logged out of the case in order to perform this task. Custom spreadsheets can be added to the master case. Users can create a custom spreadsheet in SQL cases.

Custom object spreadsheets can be customized to:

Select CaseMap object template or
Select an existing object spreadsheet

The creation of new custom object spreadsheets from existing object spreadsheets assists with a template creation so that the spreadsheets are generated without the need of adding additional columns to capture the required information.

 

ac_note_icon

You cannot add custom spreadsheets to a replica case.

 

hmtoggle_plus1To create a new custom spreadsheet from the CaseMap Default template
1.On the View ribbon, under Objects, click Customize.
2.In the Customize Object Spreadsheets dialog box, click the Add Spreadsheet button CM_add_spreadsheets_button.

Customize Objects Spreadsheets

3.In the Add Spreadsheet dialog box, type in a singular and plural name for the spreadsheet.

Add Spreadsheet

Once you type in the singular name, CaseMap automatically fills in a suggested plural name for you.

If the new spreadsheet name ends with an "e", you can type an "s" at the end of it to make it plural.

The option to select the CaseMap Default is selected by default.

4.Click OK to continue.

The new spreadsheet now displays at the bottom of the Objects spreadsheet list.

5.Click Close to save your changes.
hmtoggle_plus1To create a new custom object spreadsheet from an existing object spreadsheet
1.On the View ribbon, under Objects, click Customize.
2.In the Customize Object Spreadsheets dialog box, click the Add Spreadsheet button CM_add_spreadsheets_button.

Customize Objects Spreadsheets

3.In the Add Spreadsheet dialog box, type in a singular and plural name for the spreadsheet.

Add Spreadsheet

Once you type in the singular name, CaseMap automatically fills in a suggested plural name for you.

If the new spreadsheet name ends with an "e", you can type an "s" at the end of it to make it plural.

8.Select the Existing Object Spreadsheet option.
9.In the Existing Object Spreadsheet drop-down list, click the spreadsheet you want to use to create the new spreadsheet columns.
4.Click OK to continue.

The new spreadsheet now displays at the bottom of the Objects spreadsheet list.

5.Click Close to save your changes.
related_topics_buttonRelated Topics

 

 

Need additional help? Email the CaseMap Support team at: casemap.support@lexisnexis.com, or contact a support representative at 800.543.6862 (Option 2, then Option 4). The CaseMap Support team is available between the hours of 9:00 a.m. to 7:00 p.m. Eastern Time, Monday - Friday.

Copyright © 2018 LexisNexis. All rights reserved.