Discussions

 View Only
  • 1.  How to add two fields and put the sum in one of the fields

    Posted 11-10-2022 11:16

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


  • 2.  RE: How to add two fields and put the sum in one of the fields

    Posted 11-10-2022 11:17
    Edit: I tried using 2 fields

    ------------------------------
    Hunny Vinod Kumar
    ------------------------------



  • 3.  RE: How to add two fields and put the sum in one of the fields

    Posted 11-10-2022 11:19
    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
    ------------------------------