CIC Solutions Forums
Certified Independent Consultant Solutions Forums for
LexisNexis® Practice Management Products
Time Matters - PCLaw - Billing Matters - Browser Edition - HotDocs

Scripts

rated by 0 users
This post has 2 Replies | 2 Followers

Top 100 Contributor
Posts 38
Joseph Nierenberg Posted: Fri, Mar 30 2012 10:16 AM

Is it correct that scripts cannot be run from within Time Matters (ver. 10), but must be run on the SQL server through the Management Studio or some similar application?

(I'm trying to develop, as part of a disaster plan, the easiest practical way for someone to obtain up-to-the-minute listings of matters, client contacts, and upcoming events. If someone has an idea on this, I'd appreciate hearing it.)

Joseph Nierenberg
Nierenberg Employment Law, PLLC
Consulting – Litigation – Training
Minneapolis, Minnesota
www.nierenberg.com

Top 25 Contributor
Posts 196
.CIC
TM CIC

I usually build Excel Applications with User form input screens for filtering for this type of thing.

It's user friendly way of reporting and gathering your data from the TM database with all the tools of Excel, minus the confusion of SQL management studio.

Michael W. Gaines Jr.
Gaines Database Consulting
Time Matters CIC
Florence, SC 29501
(843) 615-8084
mgaines@gainesconsulting.com
http://www.gainesconsulting.com

Proud Southeastern Affiliate of Eastern Legal Systems, LLC
http://www.easternlegalsystems.com

Top 25 Contributor
Posts 196
.CIC
TM CIC

This is one of my blog postings back in February regarding this very topic.  http://easternlegalsystems.com/blog/2012/02/data-reporting-calculations-oh-my/

I'm working on part two to this paticular topic as we speak.  It will be a simple video tutorial on creating a saved query in excel of active cases/matters.  It would certainly help you to some degree in accomplishing what you're looking for but not entirely due to the complication of querying events and other supporting record types that the video doesn't cover.  It also will not cover building filter forms as that is a more advanced programming task.  However, the video blog should give you an idea of how you could accomplish your goal and get you started.

Michael W. Gaines Jr.
Gaines Database Consulting
Time Matters CIC
Florence, SC 29501
(843) 615-8084
mgaines@gainesconsulting.com
http://www.gainesconsulting.com

Proud Southeastern Affiliate of Eastern Legal Systems, LLC
http://www.easternlegalsystems.com

Page 1 of 1 (3 items) | RSS