Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Company Call Log

Topic Labels: Base design
162 0
cancel
Showing results for 
Search instead for 
Did you mean: 

I am trying to create a call log for our company, but the issue is that I want to figure out how to display multiple back and forth or escalations relating to one call case without adding many rows.

I think this could be done with linked records. but here is the schema:

Last Name
First Name
ID
Date
Type
Relation
Reason
Description
Phone
Email
Link to Assigned Staff / Assigned Team for follow-up.

Status (for follow-up) with Resolved or Escalated.

I want to demonstrate if it is Escalated that it would move to another person, and allow them to do the next level of response.

Or to have multiple entries documenting communication attempts at various levels before Resolved

Does that make sense? Feels like I need a sophisticated Junction Table

0 Replies 0