Forum Discussion

AustinK's avatar
AustinK
Qrew Commander
5 years ago

Re: Documentation on using JavaScript in quickbase

It isn't very intuitive on their site but keep in mind that you can select the code you want to see on there. You have to do it for every single thing you view but you can see a code example in JavaScript or even JavaScript ES6. It can be tough to smash many code examples together from this website but it may help give a starting point if you did not notice this before.

3 Replies

Sort By
  • Winss's avatar
    Winss
    Qrew Trainee
    5 years ago
    This is something I'm very much interested in. I have seen some examples and it seems using programming language like Python is only for querying the database. Is there any way by which I can deploy my python code in QuickBase (may be in code pages/formula fields) and use its result in another dedicated field.
    If so, please guide.

    ------------------------------
    Aswin Babu
    ------------------------------
    • AngelRodriguez's avatar
      AngelRodriguez
      Qrew Assistant Captain
      5 years ago
      Can you use automations, webhooks or even formulas to do that? It seems like you can use some of QuickBase's native features to do this. If you're using a result from one field into another, you still have to query the database in order to grab that data and present it in another field. Can you give more detail into what you're actually trying to accomplish? Perhaps a more concrete example.

      ------------------------------
      AR
      ------------------------------
      • Winss's avatar
        Winss
        Qrew Trainee
        5 years ago
        Currently, I want to create a cumulative sum field based on a field in the table. Please check the example below. 
        Movie name Collections Actor Name Cumulative sum
        One Night    10   Williams    10
        At the call center    25   Williams    35
        Kumbalangi    20   Jason    20
        Roja    30   Williams    65
        Chichore    15   Jason    35
        Here the cumulative sum is based on the field name - "Actors name". Based on the field - "actors name" the value in collections are added cumulatively. I hope you understood the example.
        I can easily do this through python. But I'm confused about how to do this in QuickBase through python.

        ------------------------------
        Aswin Babu
        ------------------------------