Quick Base Discussions

Expand all | Collapse all

Freezing the first column function or formula?

  • 1.  Freezing the first column function or formula?

     
    Posted 04-03-2014 13:49

    I have search through the community for answers, and most answers say that the first column is supposed to freeze on it's own, but even that is dependent on the browser used.

    I can use either Firefox 24.4 or IE11 and while the header row will freeze and stay visible, the first column does not whichever I use. I would like to be able to see at least the first column as I scroll to the right, but it does not stay visible.

    How do I set this up to freeze the first column to stay visible as I scroll?

    Thanks.



  • 2.  RE: Freezing the first column function or formula?

    Top
    Contributor
    Posted 04-10-2014 15:37
    Thanks for being part of the QuickBase Community! My name is Tom, from QuickBase Customer Care.


    After doing some testing I was able to determine that this functionality appears to be entirely browser driven and is not an intended functionality of QuickBase. While this behavior does work favorably in some scenarios, it is unfortunately not something you can directly control through QuickBase.

    Additionally, this functionality won't work on home pages / dashboards - likely due to the widget features overriding the functionality.

    The good news is that that if you are viewing a report directly, the report will freeze the first column, but only when you are viewing the report directly and not from the home page or embed.

    I have been able to test this using Chrome, Firefox and Safari. I hope this is helpful in answering your question or at least gives you a better impression of what you can expect from this feature.

    Best,

    QuickBase Customer Care


  • 3.  RE: Freezing the first column function or formula?

     
    Posted 04-10-2014 16:29
    Hi Tom, Thanks for the response. Couple questions...

    I don't understand how it is the browser that decides what freezes or not. If that's true, shouldn't there be some functionality in the browser settings to change to be able me to freeze the columns?

    Secondly, when you say viewing the report directly, I want to make sure I understand what you mean. To view the report directly, I click on a Table icon for any table I've created to the right of Home & Users. When I click on this, it automatically take me to the List all report. Whenever I scroll to the right, nothing freezes in either Firefox or IE. My company laptop does not have Chrome or Safari, and I am not sure I can/am allowed to get it.

    My previous project I was on used QB and this exact same App format and I used IE. It would freeze the first 2 columns which were the "Edit/view" column with the pencil and eye, and the 2nd column which was the Site ID#. All other columns scrolled. Currently, I have about 9 created reports beyond the default reports of List All, List Changes, and others, but none of them freeze the first column on either IE or Firefox.


  • 4.  RE: Freezing the first column function or formula?

    Posted 03-07-2018 19:44
    Hi All,

    It's been 4 years since last post on the issue, so now is there anyway to make first or couple first two columns freeze?

    Thanks,
    Jeng


  • 5.  RE: Freezing the first column function or formula?

    Posted 03-07-2018 20:29
    It might work in IE but I don't have access to IE right now to test. But you are correct. In general the columns will freeze titles but not the left side. 


  • 6.  RE: Freezing the first column function or formula?

    Posted 03-07-2018 23:31
    Looking forward if any updates from you too. Thanks


  • 7.  RE: Freezing the first column function or formula?

    Top
    Contributor
    Posted 03-07-2018 20:26
    You can do it with script. 


  • 8.  RE: Freezing the first column function or formula?

    Top
    Contributor
    Posted 03-07-2018 20:40
    You just write a little script to modify QuickBase's <table> similar to this:

    http://jsbin.com/uxecel/4/edit?html,css,output

    It it easy to do however I am busy preparing for my Portuguese meetup tonight so I can own the Brazilian market.


  • 9.  RE: Freezing the first column function or formula?

    Posted 03-07-2018 23:30
    Where in QB should I place script into?

    Thanks