Forum Discussion

GeorgeBramhall2's avatar
GeorgeBramhall2
Qrew Cadet
5 years ago

Automate the selecting of a price from a Parent Price table based on fields in the child table.

I have built a price table that has fields type, square footage and a price in each record. If this price table is a parent to a child table, can I automate the selection of a price record in the  ...
Quickbase Automations
GeorgeBramhall2's avatar
GeorgeBramhall2
Qrew Cadet
5 years ago
Update: The Price Table is not the Parent table. There is no table relationship between the 2 tables.

------------------------------
George Bramhall
------------------------------
GeorgeBramhall2's avatar
GeorgeBramhall2
Qrew Cadet
5 years ago
Actually there is a the table relationship between Price Table and Child table but I am looking to automation the selection of the Related Record ID in the child table based on type and square footage in the child table.

------------------------------
George Bramhall
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    In order to do this you would have to have a formula on the trail table that would calculate to the correct response for which is the parent price record.  If the key field of the prices table is just the Record ID it would have to calculate the correct record ID or else you could change the key of the price table to be something more meaningful than Record ID and you would have to have a formula that would calculate to that value.  

    Example, the key field could be set to text which reflects the size range of the job.  

    0-1000
    1001-2000
    2000+

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------