So I’m building a base that, among other things, records contractor time. Our data is imported regularly as a CSV and each record corresponds to an accomplished task. Each task-record has the contractor’s name as a string, as well as the start and end times of that task.
I was hoping to be able to keep track of my contractors in a separate table where we will also record each contractor’s hourly rate. I know I can use a lookup to access the hourly rate from the linked record - but is there a way to setup the base to automatically recognized the imported contractor name-string and then link it to the corresponding contractor?