Forum Discussion

PushpakumarGna1's avatar
PushpakumarGna1
Qrew Assistant Captain
6 years ago

How to disable the total field in the summary report

Hi Everyone,

Can some one please help me to disable the total column that comes as default in the summary report.

Though i Checked the two "hide" total boxes in the summary report page. I still see the totals to the right for the columns i have.

Please help. Thanks in advance

------------------------------
Pushpakumar Gnanadurai
------------------------------
  • I use script to hide those on summary reports



    //hide 3rd column on report
    $("#tableid td:nth-child(3)").hide();
    ā€‹
    //hide bottom row
    $(".totals").hide();
    #tableid - HTML table id, usually VR_dbid_reportid
    td:nth-child(3) - should be the last column number



    ------------------------------
    Everett Patterson
    ------------------------------
    • PushpakumarGna1's avatar
      PushpakumarGna1
      Qrew Assistant Captain
      Hi Everett,

      Could you please kindly let me know the procedure to use the above script. 

      Can you please give step by step information. 

      Thanks a lot in advance.


      ------------------------------
      Pushpakumar Gnanadurai
      ------------------------------
    • DonLarson's avatar
      DonLarson
      Qrew Elite
      Everett,

      I am curious how you deployed the script.  Is this IOL?  Some other technique?

      ------------------------------
      Don Larson
      Paasporter
      Westlake OH
      ------------------------------
      • AustinK's avatar
        AustinK
        Qrew Commander
        There should be multiple ways to do it. IOL is nice because it works for pretty much everyone and they don't need to install anything or even know it is happening. You could also do it via something like TamperMonkey, I have some personal scripts that run on certain pages that make QuickBase a better user experience for me or add additional functionality.
  • The bottom totals can be disabled but not the right hand side totals.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------
    • SteveHanson's avatar
      SteveHanson
      Qrew Trainee
      I have a report with several columns of numeric data and I think it's great that it automatically adds them up for the total row; however, one of the columns is for percentages and rather than have that added up for each row, I would like that column's total to be an average or just not there. It reads funny to have some things over 100% because that would be impossible for what we are calculating.

      ------------------------------
      Steve Hanson
      ------------------------------
  • Hi Pushpakumar,

    Mark is correct that the right hand side totals don't have a way to be disabled like the overall totals do. If being able to do this would be helpful for your use of summary tables and reporting I would suggest submitting that as feedback to our User Voice. User Voice is a tool our product development team uses to track user interest in new features and enhancements to existing features. The Quick Base User voice can most easily be accessed from the My Apps page in Quick Base by clicking on the orange Feedback tab that appears on the right of the page or at http://quickbase.uservoice.com by signing in with your Quick Base credentials. If you do put this request in I definitely recommend linking back to it here so that other community members with the same need can add their vote.

    I'll also throw out our standard warning that when using methods like IOL and script to change things in Quick Base those methods aren't supported by us and as such they can break or cause unintended changes when we do updates to the product. So any use of IOL and other methods are at your own discretion and behavior is subject to change.

    ------------------------------
    Evan Martinez
    Community Marketing Manager
    Quick Base
    ------------------------------
    • PushpakumarGna1's avatar
      PushpakumarGna1
      Qrew Assistant Captain
      Hi Evan,

      Thanks a lot for the suggestion. I tried logging in  http://quickbase.uservoice.com but unfortunately cant do. There is something worng with SAML authentication.

      can you please post this on my behalf?

      Thanks
      Pushpakumar 


      ------------------------------
      Pushpakumar Gnanadurai
      ------------------------------