Help with a problem
Hi all: I am a QB builder of 2 years for a nonprofit involved in addressing homelessness and I have a problem that I need some advice on how to simply solve. I have a table that contains values th...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThe way to do this is to set up a vertical looking table with two fields. The first field will be in the format
Utility-Bedrooms-Structure. So a "compound" Key field, and then rate for that compound Key.
so for example the first row of the table would read
[Utility-Bedrooms-Structure(Key)] [Rate]
Heating Natural Gas-0-Apartment 16
The key to that table of rates would be that compound field. You can upload via Excel but also form manual entry you would have formula to calculate that string, and hen have a form rule to change the Key field to the calculated value whenever they do not match and uncheck that checkbox at the bottom so that it first all the time.
Then on your Client Assistance record where you need to lookup the rate, you will have three drop down fields for the three dimensions and then once again a formula such as
List("-", [Utility], [Bedrooms], [Structure])
That will be use as the reference field in the relationship where 1 Rate has many Client Assistances
Post back if you get stuck anywhere. I don't think it will take too long messing around in excel to coax that Rates data into a vertical format with the Key field so you can upload.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
Utility-Bedrooms-Structure. So a "compound" Key field, and then rate for that compound Key.
so for example the first row of the table would read
[Utility-Bedrooms-Structure(Key)] [Rate]
Heating Natural Gas-0-Apartment 16
The key to that table of rates would be that compound field. You can upload via Excel but also form manual entry you would have formula to calculate that string, and hen have a form rule to change the Key field to the calculated value whenever they do not match and uncheck that checkbox at the bottom so that it first all the time.
Then on your Client Assistance record where you need to lookup the rate, you will have three drop down fields for the three dimensions and then once again a formula such as
List("-", [Utility], [Bedrooms], [Structure])
That will be use as the reference field in the relationship where 1 Rate has many Client Assistances
Post back if you get stuck anywhere. I don't think it will take too long messing around in excel to coax that Rates data into a vertical format with the Key field so you can upload.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------