Forum Discussion

MatthewMatthew2's avatar
MatthewMatthew2
Qrew Trainee
13 years ago

Formula to look up a corresponding field from a related table?

I'm a new QuickBase user. This is probably a simple question, but I don't know how to construct a formula to look up a corresponding field from a related table. I have a parent table and a child t...
Account and realm management
Forms
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
I don't really know of the full scope of your app, so you would have to decide, but if there are just a few fields that you need from the VIN table, then the Sync table would allow that to happen without changing "all your other" relationships.  I don't know how many relationships would need to be redone.
  • KellyBianchi's avatar
    KellyBianchi
    Qrew Assistant Captain
    8 years ago
    Well now I'm thinking I may just go back to the record picker. I don't like it, but you can search by partial numbers.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    :)  Full circle.  I had no idea from your original post that the users had to dead correct key a 17 digit number bang on to get a hit.
  • KellyBianchi's avatar
    KellyBianchi
    Qrew Assistant Captain
    8 years ago
    Yes. They could probably make a drinking game out of that! lol
  • DuncanHooper's avatar
    DuncanHooper
    Qrew Trainee
    7 years ago
    I have just discovered that you can create the standard relationship and then edit the related field type from number or text to formula and then set formula to the field where you enter the data manually. Have used it to update records with codes sent through an API to the description