Has anyone ever created a data table / ActiveForm with Canvas with a fixed table header, i.e. scrolling down will leave the header where it is - like we all did in good old ActiveForms in Perspectives.
I assume this topic is not really related to Canvas itself, but I would be very interested to see a working example with Canvas. Would also be good to have something like that as built-in attribute in Canvas, as I expect there are a lot of needs for this scenario.
Jack, that would be awsome. Basically the only piece of puzzle I’m still missing for a painless transition from Websheets to Canvas. I had some tries with different CSS from different sources, but they all messed up my table layout, so can’t wait to see a working example. Thank you very much!
Please see the below, you’ll need to create a new blank canvas page called “exaple freeze panes”, and then replace the html and js files with the below. (in samples)
You can either replace the css file with the below, or append the content to your own.
Thanks for sharing but unfortunately we are not able to download the .js file. Could you please reupload your file but add .txt extension so we can download it.
Jack, this example is brilliant and works perfectly following your instructions, as Vincent already commented.
Will now try to transfer this to a working example in our company.
PS: I did not expect fixed columns to work the same way, so even better. At the end I would need both as our finance guys prefer to stare at huge tables …
I’ve got a couple of questions:
The side rows (or rows’ headers) and the main table’s rows would become misaligned:
if the label is too long and appears on 2 or 3 lines, increasing the row’s height while the rows of the main body keep their original height
if there are cells you can input in the main body, increasing the height of the row while the label keeps its original height.
=> To fix that I’ve fixed the table’s rows height to 60px (best compromise I could find)
Did you guys have any other idea / a more elegant way to address that?
And other thing, did the sorting by clicking on the column’s header kept working after spliting the table in 4?
(On my side it seems doing a really random sorting)