Anyone else maintain a discovery receipt log alongside the case file index? I reconcile ours every Friday at 4:00 p.m. against the docket and evidence chain forms and run an 8:15 a.m. Monday tickler for statutory time limits to keep files audit‑ready. I’m looking for a clean template or lightweight tool; general info only — case‑specific decisions stay with the attorney.
I’ve had good results with a SharePoint list + Power Automate: a simple “Discovery Log” list (Received, Source, Bates/ID, Chain link, Deadline) and a flow that emails a Monday 8:15 digest and flags anything due within 7 days — a built‑in “tickler” that pings me before the coffee does. If you’re not on 365, Airtable’s free base with a deadline view is a lightweight alternative, but confirm your firm’s security policy. Are you on Office 365 or Google Workspace?
Quick tip: two‑tab Excel/Sheets — Log and Deadlines — with WORKDAY(+holiday list) to auto‑calc due dates and a Monday filter view; keeps the wheels from wobbling. Use validation for “Received/Source/Bates/Chain URL” and a “Reviewed” checkbox so closed items don’t ping; case‑specific timeframes stay with the attorney. @fred_kline58’s flow idea pairs well, but if you want lightweight I can share the sheet — want the template?
I switched to a simple Google Form that feeds the log, and it cut our Friday reconcile time in half; each entry takes about 30 seconds and the Sheet auto‑stamps date, validates fields, and an Apps Script sends the 8:15 Monday tickler (see Simple Triggers | Apps Script | Google for Developers). The only caveat is access — lock it down and keep entries general; we leave any case‑specific calls to the attorney. Want the form+sheet template?
I use one SmartPhrase in Epic to triage the 8 a.m. phone rush while checking in: I say, ‘I’ll place you in the 9:30–10:00 callback window so I can finish check-ins; if this turns urgent, call 911 or ask for our triage nurse,’ then drop.AMCALL to route the message to our pool and add a callback task so I can keep prepping charts. If you’re solo, slide the window to 10:00 and pin In Basket to show only Today + Unread so it doesn’t steal focus.