Skip to main content
Question

Table lookup without a user selected proxy

  • June 29, 2017
  • 0 replies
  • 24 views
I have a budget table and a survey table. I want to pull in budget pricing on each category based on a customer name but do not want to have to select a proxy, I want that to be selected for me so the fields will look up the pricing for each field. Is this possible.

      Joey, you will need to better describe your tables and their relationships.  When you say "based on customer name" are you saying that each customer has uniqiue pricing in the budget table?
      • ZintJoseph
      • Author
      • Quickbase Alumni
      • June 29, 2017
      The relationship at this point is One Budgetsto Many Surverys. The budget table is not linked to a Customer table but could be. The surveys are tied to a Company table so the company name is there in the survey. At this point I do not believe we would have different budget pricing per customer but you know if you do not think of it now it will happen. Just thinking ahead!
      So back to your question. Are you saying that there is a table with a small list of Budget prices and you want that whole list of prices to be available to use on a survey record, but obviously in separate fields?
      • ZintJoseph
      • Author
      • Quickbase Alumni
      • June 29, 2017
      Yes. I have the budget table build and populating from a proxy dropdown. The survey header has the company name and the door type is in each survey line item. There would never be a situation of having two different door types so I could look that back up to the survey header and capture a door type so that it and the company name resides in the header where the budget fields reside. Just not sure how to make that proxy a selection based on those two variables.

      Everything works except the proxy selection being automated











      I think I would need to look at the app to sort that out.
      Terms & ConditionsAccessibility statement