Forum Discussion

Winss's avatar
Winss
Qrew Trainee
5 years ago

Documentation on using JavaScript in quickbase

Where is the documentation on using javascript in QuickBase? I was searching in google for javascript in QuickBase documentation but I couldn't find any. Please give me the link to the documentation. ...
APIs and custom code
Winss's avatar
Winss
Qrew Trainee
5 years ago
In RESTful API documentation page its mostly about writing query, but i need javascript mainly to bring more programmatic ability to some auto-generated fields in records. In many Q&A I have seen experts giving answers by using js. If there is a doc I can  program myself, but there seems no docs. related with this.

------------------------------
Aswin Babu
------------------------------
AustinK's avatar
AustinK
Qrew Commander
5 years ago
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.

  • 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
        ------------------------------