Forum Discussion

StevenPearson's avatar
StevenPearson
Qrew Assistant Captain
6 years ago

Look up field won't populate

I have 2 tables, Trucks and Truck Mileage. Truck Mileage has a field called auditor that I want to pull in to the trucks via a lookup. Using related truck as reference and truck mileage: auditor as the value field. The problem is I get nothing in the look up field. Why would this be happening? Truck mileage is updated through Google drive.
Tables and fields
  • ChayceDuncan2's avatar
    ChayceDuncan2
    Qrew Cadet
    6 years ago
    If your mileage is being brought in from Drive - are you sure that it is being properly associated with 'Related Truck'? Sounds like they might not be related correctly right now. Another avenue to check is to make sure the field types are the same. Is auditor a user field at the parent level and then also a lookup-user in mileage?

    Chayce Duncan | Technical Lead
    (720) 739-1406 | chayceduncan@quandarycg.com
    Quandary Knowledge Base
  • StevenPearson's avatar
    StevenPearson
    Qrew Assistant Captain
    6 years ago
    The parent table is Truck Mileage, populated by Google drive, key field is asset number. Child table is Trucks, reference field is related truck, they are both text fields.
  • ChayceDuncan2's avatar
    ChayceDuncan2
    Qrew Cadet
    6 years ago
    Can you elaborate more on why it's set up that way? I would imagine your architecture being the opposite -  where Trucks would have many mileage records. Mileage doesn't seem like a natural parent record to a Truck. Is the data in google drive a recurring entry on a trucks mileage? What specifically is being entered in Drive? 

    Chayce Duncan | Technical Lead
    (720) 739-1406 | chayceduncan@quandarycg.com
    Quandary Knowledge Base
  • StevenPearson's avatar
    StevenPearson
    Qrew Assistant Captain
    6 years ago
    You're absolutely right about the relationship. Trucks "should" be the parent table. But when that is the case, I have no option to choose a look up field in the mileage table when setting up the parameters for the field. The only option for a look up field are those where the look up field is part of the child table in the relationship. The information in the mileage table includes asset/truck number, auditor, mileage, and others and is updated via Google drive every day.
  • ChayceDuncan2's avatar
    ChayceDuncan2
    Qrew Cadet
    6 years ago
    So is the question then how do you get a field like 'Auditor' to be in Trucks? The answer to that then is a different path.

    If you have mileage being entered every day you don't have a single auditor - you have potentially many different options to choose from. So you have to do something like find the 'most recent' auditor, or unique list of auditors using summary fields. If you make Trucks table unique by their Asset Number - you can summary data from the most recent mileage entry to then display it in Trucks. 

    Chayce Duncan | Technical Lead
    (720) 739-1406 | chayceduncan@quandarycg.com
    Quandary Knowledge Base