I have something I’m having trouble wrapping my head around and thought someone might be able to help. I am trying to keep a “Master List” with the following key items:
- People Name + People Demographics
All of the devices are “owned” by the organization, and may be moved amongst people (e.g. if they leave the organization, one gets broken, etc.). There’s USUALLY a 1:1 model (i.e. one person gets one device for their time at the organization), but there are “loaner” devices I need to keep track of assignments too (e.g. new person needs device on day 1). I’m trying to figure out how to “parse” the data in order to be able to “pair” a device with a person and have everything change quickly. I know coda can probably do this better than a spreadsheet, but I can’t figure out how to organize it upfront.
Right now I’m just doing REALLY long rows with the following key details (and just showing different views of the master table):
- Person Name
- Person Demographics (id#, site location, etc.)
- Device ID
- Device name, description, details, etc.
I’d really like to be able to “pair” device ID/details with person name/demographics, and allow for easy change in case a device needs to change hands.
Does that make sense?
Thanks in advance!!!