Lookup Based on Text Multiple Choice Selection
Hello, I'm looking to solve a problem I am having.
In my "Inventory" table, I have a list of properties and each has a selected house plan which is obtained via relationship with the House Plans table. I also have a multiple choice field for Interior Level and Exterior Level, each with options "Level 1" through "Level 4"
For each House Plan in the House Plans Table, there are 4 different fields for Interior Levels and 4 different fields for Exterior Levels. Each "Level" field is a Numeric Formula field that calculates the cost to upgrade a home plan to that level. (See attachment...it will probably be more clear.)
Back in the the Inventory table, I'm trying to calculate the approximate cost to build a specific property. To do this, I need to pull the Base Price of the House Plan via relationship (which I have already done) and add the *Selected* Interior Level and Exterior Level to the Base Price to arrive at a Total Price.
That is where I am running into a problem.
Is there a way that I can use a multiple choice text field with options "Level 1," "Level 2," "Level 3," etc in the Inventory Table to select the Interior Level and Exterior Level, then have Quick Base lookup the corresponding field in the House Plans table and pull in the cost?
It seems that the problem is that I don't know how to tell Quick Base that "Level 1" in the multiple choice field should lookup "Level 1" in the House Plans field. I'm guessing I need a separate formula text field that basically says something like: If Inventory Field [Interior Level] = "Level 1", then lookup House Plan Field [Level 1.]
If this is unclear, I'm happy to try to give more clarity. But any help or direction you could provide would be awesome.
Thanks!
Josh
------------------------------
Josh Collins
------------------------------
In my "Inventory" table, I have a list of properties and each has a selected house plan which is obtained via relationship with the House Plans table. I also have a multiple choice field for Interior Level and Exterior Level, each with options "Level 1" through "Level 4"
For each House Plan in the House Plans Table, there are 4 different fields for Interior Levels and 4 different fields for Exterior Levels. Each "Level" field is a Numeric Formula field that calculates the cost to upgrade a home plan to that level. (See attachment...it will probably be more clear.)
Back in the the Inventory table, I'm trying to calculate the approximate cost to build a specific property. To do this, I need to pull the Base Price of the House Plan via relationship (which I have already done) and add the *Selected* Interior Level and Exterior Level to the Base Price to arrive at a Total Price.
That is where I am running into a problem.
Is there a way that I can use a multiple choice text field with options "Level 1," "Level 2," "Level 3," etc in the Inventory Table to select the Interior Level and Exterior Level, then have Quick Base lookup the corresponding field in the House Plans table and pull in the cost?
It seems that the problem is that I don't know how to tell Quick Base that "Level 1" in the multiple choice field should lookup "Level 1" in the House Plans field. I'm guessing I need a separate formula text field that basically says something like: If Inventory Field [Interior Level] = "Level 1", then lookup House Plan Field [Level 1.]
If this is unclear, I'm happy to try to give more clarity. But any help or direction you could provide would be awesome.
Thanks!
Josh
------------------------------
Josh Collins
------------------------------
