Case Management Sheet

Track client cases from intake to closure, with caseworker assignments, next actions, documents and a dated log of every contact.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Log Sheets

Tables

Cases, Case Notes

Fields

26

Views

grid, kanban, calendar, form, dashboard

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Cases

18 fields · 5 sample rows

  • Caseload (Grid)
  • Pipeline (Kanban)
  • Next actions (Calendar)
  • Intake form (Form)
  • Overview (Dashboard)
CaseTextCase IDAutonumberClientTextClient PhonePhoneClient EmailEmailCase TypeSingle selectPrioritySingle selectCaseworkerSingle selectStatusSingle selectOpenedDateNext ActionTextNext Action DateDateClosedDateDays OpenFormulaCase NotesLink to another tableContacts LoggedCountLast ContactRollupDocumentsAttachment
Eviction notice supportCS-0001Lakshmi Devi+91 98400 12312HousingUrgentRekha PillaiActive7 Nov 2026Attend tenancy hearing21 Nov 202612Reviewed eviction notice, Called landlord213 Nov 2026
Unpaid wages claimCS-0002Ramesh Yadav+91 99000 45645EmploymentHighJoseph MathewWaiting on client20 Oct 2026Collect salary slips24 Nov 202630Requested salary slips111 Nov 2026
School enrolment for siblingsCS-0003Grace Thomas[email protected]Child welfareNormalAmy CollinsIntake17 Nov 2026Home visit23 Nov 202620
Visa renewal paperworkCS-0004Ahmed Karim+44 7700 900456ImmigrationHighAmy CollinsActive5 Oct 2026Submit form at consulate28 Nov 202645Consulate appointment booked115 Nov 2026
Disability pension applicationCS-0005Mohan LalHealthNormalRekha PillaiClosed21 Aug 20269 Nov 202680Pension approved19 Nov 2026
Field details
Case · Text
Case ID · Autonumber
Client · Text
Client Phone · Phone
Client Email · Email
Case Type · Single select
Housing, Legal aid, Child welfare, Employment, Health, Immigration
Priority · Single select
Urgent, High, Normal
Caseworker · Single select
Rekha Pillai, Joseph Mathew, Amy Collins
Status · Single select
Intake, Active, Waiting on client, On hold, Closed
Opened · Date
Next Action · Text
Next Action Date · Date
Closed · Date
Days Open · Formula
IF({Opened}, DATETIME_DIFF(IF({Closed}, {Closed}, TODAY()), {Opened}, 'days'), BLANK())
Case Notes · Link to another table
Links to Case Notes
Contacts Logged · Count
Last Contact · Rollup
latest of Date via Case Notes
Documents · Attachment

Form view “Case intake” asks for: Case, Client, Client Phone, Client Email, Case Type, Priority, Caseworker, Opened, Documents.

Case Notes

8 fields · 5 sample rows

  • Notes (Grid)
  • Calendar (Calendar)
  • Add a note (Form)
SummaryTextCaseLink to another tableDateDateContact TypeSingle selectDurationDurationLogged BySingle selectDetailsLong textFollow-up NeededCheckbox
Reviewed eviction noticeEviction notice support7 Nov 2026In person1:00Rekha PillaiYes
Called landlordEviction notice support13 Nov 2026Phone0:20Rekha Pillai
Requested salary slipsUnpaid wages claim11 Nov 2026Phone0:15Joseph MathewYes
Consulate appointment bookedVisa renewal paperwork15 Nov 2026EmailAmy Collins
Pension approvedDisability pension application9 Nov 2026Phone0:10Rekha Pillai
Field details
Summary · Text
Case · Link to another table
Links to Cases
Date · Date
Contact Type · Single select
Phone, In person, Email, Home visit, Court / hearing
Duration · Duration
Logged By · Single select
Rekha Pillai, Joseph Mathew, Amy Collins
Details · Long text
Follow-up Needed · Checkbox

Form view “Add a case note” asks for: Summary, Case, Date, Contact Type, Duration, Logged By, Details, Follow-up Needed.

Case Management Sheet: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates