Forum Discussion

AmandeepDhillon's avatar
AmandeepDhillon
Qrew Member
4 years ago

Sort of using Vlookup in QuickBase- setting up a field to look through multiple records and then match and assign

Hello I have 20k records with about 124 fields in table -1. One of the field is City (Text field). Now i have another table-2 where i have added all 150 Cities assigned to us and each City has un...
Relationships
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
No Problem.
 
Change the Key field of the cities table to be the City Name field.
Make a relationship between 20K Details and City based on a new formula field in details called [City mirror] with a formula of

[City]

Then look up the Region .

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • AmandeepDhillon's avatar
    AmandeepDhillon
    Qrew Member
    4 years ago
    Thank you Mark, it worked perfect.

    ------------------------------
    Amandeep Dhillon
    ------------------------------