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  Parent table with the updating of a record in the child table with a specific type and square footage? I need to automatically bring the selected price in the parent table in to the child table.

------------------------------
George Bramhall
------------------------------
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
        ------------------------------