Discussions

Expand all | Collapse all

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

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

    Posted 21 days ago
    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 unique Region Code (BC1A, BC 2A sort of).
    I want to recreate that same Region field in Table 1 with all the records.
    I have tried creating a formula-text field and apply the if-else as well as case condition but it returns error that City field needs text value which confuses me further as its already a text field.
    is there a way to automate this filed.

    Thanks for your help.

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


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

    Posted 21 days 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
    ------------------------------



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

    Posted 21 days ago
    Thank you Mark, it worked perfect.

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