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
------------------------------
Original Message:
Sent: 03-12-2021 09:39
From: Angel R
Subject: Documentation on using JavaScript in quickbase
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
Original Message:
Sent: 03-12-2021 03:19
From: Aswin Babu
Subject: Documentation on using JavaScript in quickbase
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
Original Message:
Sent: 03-10-2021 10:13
From: Austin K
Subject: 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.
Original Message:
Sent: 03-10-2021 04:54
From: Aswin Babu
Subject: Documentation on using JavaScript in quickbase
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
Original Message:
Sent: 03-09-2021 09:52
From: Angel R
Subject: Documentation on using JavaScript in quickbase
You would more than likely refer to the Code Pages documentation and the RESTful API documentation, too. The RESTful API documentation is nice because it demonstrates how to use jQuery and the Fetch API with code pages. Other than that, I'm not sure where else you'd find other JavaScript documentation for QuickBase unless you search around a bit on the community forums. I'm sure other users have some input on this as well.
------------------------------
AR
Original Message:
Sent: 03-09-2021 09:24
From: Aswin Babu
Subject: 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.
------------------------------
Aswin Babu
------------------------------