Forum Discussion

11023's avatar
11023
Qrew Member
2 years ago

Creating projects for builders using a new site address

I am very new to the system. For my company, I am trying to figure out how to add a new project for a builder using the new site address, without having to create multiple customer entries with new addresses.
App builders
Relationships

4 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    2 years ago
    No Problem.  The Address field on the customer record should either not live there at all or if there is one it would just be [Billing Address]. 

    Then you will make a Table called Shipping Address and Make a relationship where

    One Customer has Many Shipping Addresses.

    Then I assume that your app probably has orders in it and the on the order table you select the customer.  Instead of looking up the address from the customer instead you will make a new relationship where one shipping address has many orders. 

    The magic for that is that then you go to the field for related shipping address on the order and edit the field properties and mark that field as Conditional.  

    You are then specify that once the field for related customer is chosen on the order than only offer up shipping locations we are related customer matches that field. The effect of that is once you choose a customer then the drop-down list of shipping address will just be a short list of possible shipping addresses for the customer you already selected.  


    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Qrew #1 Challenger
      2 years ago
      By the way, if you already have a lot of data in your application and the address field is currently living on the customer record you can do a one time copy of the address field components into the table of shipping addresses. If you map the record ID of the customer into the field for related customer then that will get you off to a running start with all of your customer locations initially populated.

      ------------------------------
      Mark Shnier (Your Quickbase Coach)
      mark.shnier@gmail.com
      ------------------------------
      • 11023's avatar
        11023
        Qrew Member
        2 years ago

        Hi,

         

        I am very new at this so I'm trying to break down everything you are saying and implement this however, I am still a little bit lost. Thank you so much for your response.