Quick Base Discussions

Expand all | Collapse all

Is it possible to hide the first column of a QuickBase report (which can show view/edit icons)? I have no view/edit options set up and want to remove the empty column.

  • 1.  Is it possible to hide the first column of a QuickBase report (which can show view/edit icons)? I have no view/edit options set up and want to remove the empty column.

    Posted 07-03-2015 12:48

    Is it possible to hide the first column of a QuickBase report (which can show view/edit icons)? I have no view/edit options set up and want to remove the empty column as it is taking up a reasonable amount of space and forcing data in other columns to wrap.

    Thanks.



  • 2.  RE: Is it possible to hide the first column of a QuickBase report (which can show view/edit icons)? I have no view/edit options set up and want to remove the empty column.

    Top
    Contributor
    Posted 07-05-2015 17:31
    Yes this is possible with script. I added it to my Reframe With Router Demo on the query named "Flank ball tip pork chop swine tail sausage pork loin porchetta pastrami filet mignon alcatra shoulder beef." That's a mouthful!

    Just visit the following page and (1) navigate to the the Clients table, (2) click "REPORTS & CHARTS" and finally (3) click on the query "Flank ball tip pork chop swine tail sausage pork loin porchetta pastrami filet mignon alcatra shoulder beef." aka qid=14:

    Reframe With Router 
    https://haversineconsulting.quickbase.com/db/bj3pggjdg

    For demonstration purposes I fade the first column out over three seconds but it could be immediately hidden using $(...).hide() instead of $(...).fadeOut(3000). Here is the relevant code the parent frame uses to detect when the above query is loaded into the <iframe> so the first column can be removed:

    if (props.dbid == dbidClients && props.a == "q" && props.qid== "14") {
       $("#myIframe").contents().find("#VR_bj3pggjd6_14 thead tr td:first").fadeOut(3000);                         $("#myIframe").contents().find("#VR_bj3pggjd6_14 tbody tr td.icr").fadeOut(3000);
    }

    See attached screenshot after fadeOut completes.

    If you find this answer confusing you might want to read this post first:

    What is the Reframing Technique?
    https://quickbase-community.intuit.com/questions/1184283

    If you are still confused ask a question.


  • 3.  RE: Is it possible to hide the first column of a QuickBase report (which can show view/edit icons)? I have no view/edit options set up and want to remove the empty column.

    Posted 07-06-2015 10:48
    Thanks very much - I read the post explaining the Reframing Technique and I think I understand how it works - very clever!

    I couldn't get the Reframe With Router demo to work, though. I followed the link to https://haversineconsulting.quickbase.com/db/bj3pggjdg, but could only see the 'List All' report for the Clients table. Sorry if I've missed something obvious.

    Thanks.


  • 4.  RE: Is it possible to hide the first column of a QuickBase report (which can show view/edit icons)? I have no view/edit options set up and want to remove the empty column.

    Top
    Contributor
    Posted 07-06-2015 13:57
    It works for me when I log out and use Chrome so I think you are not following the correct navigation. Once the page comes up just follow these three step: (1) navigate to the the Clients table, (2) click "REPORTS & CHARTS" and finally (3) click on the query "Flank ball tip pork chop swine tail sausage pork loin porchetta pastrami filet mignon alcatra shoulder beef." aka qid=14.


  • 5.  RE: Is it possible to hide the first column of a QuickBase report (which can show view/edit icons)? I have no view/edit options set up and want to remove the empty column.

    Posted 07-06-2015 16:00
    Hi,
    Have retried logged in and logged out using Chrome and IE and can now see 2 reports - List All and Filet mignon kielbasa sirloin short ribs ground round tail - but not qid=14. Sorry!


  • 6.  RE: Is it possible to hide the first column of a QuickBase report (which can show view/edit icons)? I have no view/edit options set up and want to remove the empty column.

    Top
    Contributor
    Posted 07-06-2015 16:14
    >Have retried logged in and logged out using Chrome and IE and can now see 2 reports - List All and Filet mignon kielbasa sirloin short ribs ground round tail - but not qid=14. Sorry!
    It is listed under Common with Participant role for Everyone On the Internet.


  • 7.  RE: Is it possible to hide the first column of a QuickBase report (which can show view/edit icons)? I have no view/edit options set up and want to remove the empty column.

    Top
    Contributor
    Posted 07-06-2015 16:31
    Try it again - apparently I had did not allowed access to all the Common reports!


  • 8.  RE: Is it possible to hide the first column of a QuickBase report (which can show view/edit icons)? I have no view/edit options set up and want to remove the empty column.

    Top
    Contributor
    Posted 07-06-2015 16:50
    BTW, I just realized that I can probably get rid of inner.html altogether and set the role home page property directly to outer.html instead of "use default". I will keep tweaking this demo in the coming days and weeks to make it simpler to use including adding a real router / dispatch table optimized for QuickBase URLs. Conceptually you would add a bunch or routes something like this:


    QBRouter.addRoute("db/bj3pggjd6?a=td", handler1);
    QBRouter.addRoute("db/bj3pggjd6?a=q&qid=1", handler2);


    And when the frame URL changes you would call the appropriate handler functions (with the subdomain, dbid and query string passed as an argument) for those URLs that match the Route's pattern:


    QBRouter.dispatch(url);

    This will make is dead simple to create new routes to observe and modify any QuickBase page!


  • 9.  RE: Is it possible to hide the first column of a QuickBase report (which can show view/edit icons)? I have no view/edit options set up and want to remove the empty column.

    Posted 11-05-2015 17:40
    Dan, could I implement this on an exact form that contains a report?


  • 10.  RE: Is it possible to hide the first column of a QuickBase report (which can show view/edit icons)? I have no view/edit options set up and want to remove the empty column.

    Posted 03-29-2018 14:19
    Dan, Could I alter this to exclude any column or two columns?  For example on a summary report I don't want the last two columns to show


  • 11.  RE: Is it possible to hide the first column of a QuickBase report (which can show view/edit icons)? I have no view/edit options set up and want to remove the empty column.

    Top
    Contributor
    Posted 03-29-2018 15:14
    I am sure this can be done with script but the original post is years old so ask a new questions and include (1) the URL of the page (I need to see the action and any parameters in the URL) and (2) a screenshot.