Forum Discussion

HunnyVinod_Kuma's avatar
HunnyVinod_Kuma
Qrew Member
3 years ago

How to add two fields and put the sum in one of the fields

Hi,
I have one field and I want to do the cumulative sum in that field. For example suppose I have one field T1  and user has entered value 10 initially so that field should show value 10. Next time when user enter another value let say 20, then it should show sum of current value in T1 field (10) plus the latest value(20) which is 30. Is there any way to achieve this?

I tried using three fields 
1st T1 which get the actual value
2nd T2 which will store the previous value of T1 and if first time user is entering the value in T1 then T2 should show the value of T1 next time when user enter the value in T1 then it should show sum of T2 value + new T1 value and put that value in T1.

Please help if it is feasible to do in quickbase



------------------------------
Hunny Vinod Kumar
------------------------------
  • HunnyVinod_Kuma's avatar
    HunnyVinod_Kuma
    Qrew Member
    3 years ago
    Edit: I tried using 2 fields

    ------------------------------
    Hunny Vinod Kumar
    ------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    It's really not a good way to build an app because there will be no audit trail. I sugest making a child table for these entries and then using a summary field on the relationship to sum the entries back up to the Parent Record.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------