Cumulative field
I am looking on how to create a field that will show the running total of a certain field. I saw this https://haversineconsulting.quickbase.com/db/bnab4bvnx?a=q&qid=1&_ga=2.126707979.728167338.1559232...
Forum Discussion
Here is a link to Dan's Code:
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=614&rl=cgzu
Doing it this way will give the exact result as shown in the URL you posted. Make a Rich Text Formula Field and use this code:
"<img src onerror='window.QBU_Sum = (window.QBU_Sum || 0) + " & [YOUR_CERTAIN_FIELD] & ";this.outerHTML=QBU_Sum'>"
Replace "YOUR_CERTAIN_FIELD" with whatever field you want summed, then in your report, arrange your fields in the same manner as shown in the URL you posted.
Here is a snip of the duplicated result:
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=614&rl=cgzu
Doing it this way will give the exact result as shown in the URL you posted. Make a Rich Text Formula Field and use this code:
"<img src onerror='window.QBU_Sum = (window.QBU_Sum || 0) + " & [YOUR_CERTAIN_FIELD] & ";this.outerHTML=QBU_Sum'>"
Replace "YOUR_CERTAIN_FIELD" with whatever field you want summed, then in your report, arrange your fields in the same manner as shown in the URL you posted.
Here is a snip of the duplicated result:
Correct, it will be dependent on how you sort your report, which is fine if you have your report sorted by record id or date created, otherwise, the solution may be harder to do.
I'll reply back if I figure out a good way to have a cumulative field directly tied to the record itself based on record id.
I'll reply back if I figure out a good way to have a cumulative field directly tied to the record itself based on record id.