Freezing the first column function or formula?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered

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.

Photo of Les

Les

  • 0 Points

Posted 5 years ago

  • 0
  • 1
Photo of Tom

Tom

  • 0 Points
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
Photo of Les

Les

  • 0 Points
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.
Photo of Jeng Wata

Jeng Wata

  • 90 Points 75 badge 2x thumb
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
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,268 Points 50k badge 2x thumb
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. 
Photo of Jeng Wata

Jeng Wata

  • 90 Points 75 badge 2x thumb
Looking forward if any updates from you too. Thanks
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,184 Points 20k badge 2x thumb
You can do it with script. 
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,184 Points 20k badge 2x thumb
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.
Photo of Jeng Wata

Jeng Wata

  • 90 Points 75 badge 2x thumb
Where in QB should I place script into?

Thanks