Forum Discussion

JamesCarr's avatar
JamesCarr
Qrew Trainee
2 years ago

Can Code Pages Reference Table Values?

I am exploring Code Pages, doing some general learning about them and what you can do with them.  I am wondering if Code Pages can display a value(s) from a specific table in the app based on a query formula or some kind of lookup value.  Can this be done?  If so, how?  



------------------------------
James Carr
------------------------------
    • JamesCarr's avatar
      JamesCarr
      Qrew Trainee

      Thank you. I will check it out and reply back accordingly.



      ------------------------------
      James Carr
      ------------------------------
    • JamesCarr's avatar
      JamesCarr
      Qrew Trainee

      Jim,

      Might you be familiar with this app? This is a lot to take in and I don't fully understand what I am looking at. I have looked at a few buttons to get details but I don't see where another table within the app is being referenced to pull a value from.



      ------------------------------
      James Carr
      ------------------------------
      • JimHarrison's avatar
        JimHarrison
        Qrew Champion

        Hi James,

        Code pages are not low code pages. 

        It helps to have a good knowledge of HTML, JavaScript, Quickbase in general and Quickbase API/formulas before going straight to writing code pages.

        If you're hoping for little personal investment, I'd recommend finding a consultant who will walk you through how it functions or just do it for you.

        From my perspective, everything is there and the examples are quite simple and clear. The Code page App takes time to learn. If you can become familiar with how it functions and the principals involved then anything is possible with Code pages.

        Good luck,



        ------------------------------
        Jim Harrison
        transparency = knowledge + understanding : The Scrum Dudes
        ------------------------------
    • JamesCarr's avatar
      JamesCarr
      Qrew Trainee

      Thank you, Neil. I saw those links before. They didn't lead directly to my answer. I am still going to take time going through the example app Jim shared, and I found something else in the QuickBase Exchange to possibly look at.



      ------------------------------
      James Carr
      ------------------------------
  • TimD's avatar
    TimD
    Qrew Trainee

    i'm pretty sure you can. If you have it on your table via lookup or query formula, you can put that as a variable (in a formula url field) that will go into the url that the code page will pick up.

    you can see it in action on this page

    https://resources.quickbase.com/db/bq8meiyhh?a=dr&key=22



    ------------------------------
    Tim D
    ------------------------------
    • JamesCarr's avatar
      JamesCarr
      Qrew Trainee

      Thanks, Tim. Jim shared a link to that app already. Clearly, it's not something that's straight forward without having more coding knowledge so, I will spend time doing some more learning about HTML and Javascript. This app will be a good reference point, hopefully, as I learn more. 



      ------------------------------
      James Carr
      ------------------------------
  • I wanted to follow up and say that I have the foundation for what I am looking for. Jim and Neil, the links you gave were excellent resources but, being a novice to HTML and JavaScript, I still had to go to Google and YouTube for a little more. Tim, your answer was more like what I was looking for, except I see that you don't have to just pass an URL to the code page. You can pass other values as well.  I came up with a simple block of html to suit my needs, while I expand my knowledge for more capabilities. 

    For anyone looking for an answer to this same question, I recommend searching for how to pass parameters with html or with javascript, as well as how to use parameters passed to your page (no need to specify quickbase code page in your search).  Google and YouTube were my friends for this. Then I referenced the links Jim and Neil posted to see if I could follow the code I saw as I learned what parts I needed for my own purposes. The examples on that resources quickbase app had more code than necessary for the type of solutions I needed.

    Thank you, again, gentlemen. I appreciate your answers.



    ------------------------------
    James Carr
    ------------------------------
    • JimHarrison's avatar
      JimHarrison
      Qrew Champion

      We done James!



      ------------------------------
      Jim Harrison
      transparency = knowledge + understanding : The Scrum Dudes
      ------------------------------