I’m building an app to track costs per customer. It tracks hours spent and expenses incurred per customer. Each customer has a Customer Code. My employees often travel to more than one customer site in a single trip. For this reason, I need to be able to track multiple Company Codes per Trip. I have both a Trip Sheet and Accounts Sheet in my Google Sheets file.
Per Trip, I need to be able to capture and display multiple Customer Codes. When a detail view of a trip is opened, I need to be able to display the multiple Customer Codes involved on the Trip. What is the best way to do that?