Quick Base Discussions

Expand all | Collapse all

how to get information from the dependent table into general table, similar Excel Vlookup

  • 1.  how to get information from the dependent table into general table, similar Excel Vlookup

    Posted 09-21-2018 16:04
    Hello,

    I have 2 tables in my App, 1st is the general one, which should contain all statuses from the second table.

    In both that tables I have equal ID numbers as a key. 

    How I can connected tables?
     For example, if in table 2 , ID #1 changed its status to completed in the field status, then QB will automatically update status in table 1 with id #1.

    In excel I used Vlookup formula for that...


  • 2.  RE: how to get information from the dependent table into general table, similar Excel Vlookup

    Posted 09-22-2018 01:36
    Instead of changing it by automation, why not change the field in one of the tables to a lookup field to match the status of the other. So at all times the statuses will match? Would this not fix your problem?


  • 3.  RE: how to get information from the dependent table into general table, similar Excel Vlookup

    Posted 09-23-2018 01:38
    Sound good, how I can make such a lookup?


  • 4.  RE: how to get information from the dependent table into general table, similar Excel Vlookup

    Posted 09-29-2018 23:01
    Sorry for late response, when making a field the very last field type should be a lookup field. 

    Careful changing field types because it will delete all stored data connected to the previous field data type. I would recommend creating an entirely new field just for testing, make it a lookup field.

    Another way to do this,

    Table 1: Field 1 = testField   //this is a text field
    Table 2: Field 2 = testField2 //this is the lookup field which is a formula text

    now in the formula text you just put in [testField]

    this will import whatever is in testField and display it in testField2


  • 5.  RE: how to get information from the dependent table into general table, similar Excel Vlookup

    Posted 10-01-2018 12:50
    thank you.