Forum Discussion

Re: Using QB for CPQ app?

Well let me weigh in with a random opinion. I have been working with Quickbase first as a kind of power user when I was a manager and then after we sold our family business as a developer, in all since 2002. so 20+ years.  I have worked with I imagine more than 100 clients and countless apps. And all I can say is when you get into the intricacies of building an app with crazy business rules, there's always a way to do it with QuickBase one way or the other.  

The famous Quickbase sales engineer Kirk Trachy, now retired had a great expression. "If you can say it, we can do it."   And what he meant by that is if you can clearly enunciate in words, the business rule or the formula or the restriction that you are trying to implement then we can do it. The challenge often becomes being crystal clear about what the requirement is.   

We have so many tools now at our disposal compared to the early days. Pipelines, formula queries, URL Formula buttons and regular old relationships.

So for example if I was to guess what you meant about your original question, if we are building an order and it has Child Line items the order can easily detect through very conventional summary fields whether or not there are any child items in category windows.  That would allow us to control whether or not we will let you add another child item as tinting.  Simply be a form rule which blocks the safe and put up a message to the user. "Cannnot I add tinting because no windows yet".    

 



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

3 Replies

  • ChayceDuncan's avatar
    ChayceDuncan
    Qrew Captain

    I would echo some of Marks comments and add that of any time it would probably be now with the capabilities of both pipelines and formula queries. In my opinion if you start off with a well defined catalog / template where your rules are in place via relationships of what items are 'suggested' or required to go with what, when it comes time to apply that to an actual quote, you can leverage a lot of these tools to (1) use summaries/formula queries against the template to determine if you've got everything you need or (2) leverage those same things to just create/fill in the gaps for the end user. 

    My suggestion would be to figure out how you would build the configuration template the rules that will apply in each type of circumstance and then engineer that in a way that when you actually apply it to a quote then it should easily fall into place. The legwork would be getting all of those configuration pieces ready to go. 



    ------------------------------
    Chayce Duncan
    ------------------------------
    • DavidJung's avatar
      DavidJung
      Qrew Assistant Captain

      Chayce--

      OOOH, Formula queries. API calls from within QB! Haven't used them, but that seems to be the answer I needed about how to do this. I was thinking I would need a stand-alone page to do API calls and rely on their results. If I can do it natively from within QB, that opens up this project. Thank you!

      AND I can get ChatGPT to write queries for me. I've already had success with that with an external app. Awesome.

      ------------------------------
      David Jung
      ------------------------------

  • DavidJung's avatar
    DavidJung
    Qrew Assistant Captain

    Mark--

    Thanks for your reply. I've had a QB account almost as long as you. As we went from tables to apps, the database has certainly grown with our needs. I think I could make QB stand up on its ear, if I wanted. Many times I've felt cautious making it do things, then come back and just go ahead and go all in where it just feels extremely contrived, yet powerful. And here I am questioning if I should go the next level. I need to bring in engineering and IT and have them learn how to do things, and these tricks (like summary fields) as regular functions. 

    Funny you should mention that Kirk quote, that now applies to ChatGPT. And if I were to build a coded front end to do the configuring, I would do just that with ChatGPT. 

    As I reply, I'm thinking maybe I just need to do a test app, focus on the daughter-table and sister-item relationships to see if I can manage them to meet our needs. I've never really generated daughter items dynamically, maybe that is something that will help learn the answer.



    ------------------------------
    David Jung
    ------------------------------