Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jan 27, 2020 01:27 AM
I’m new to Airtable, I’m trying to freeze several rows at the top, in addition to the ability to freeze columns (like “freeze panes” in Excel). Is this possible on the free plan? Is there a better solution?
For example, let’s say my records are students and my columns are classes. Each class has some metadata - its location, times and teacher. Currently it’s specified in the first several rows, instead of them holding student data, so the student list begins at about row 6. I need to see this info when I’m scrolling the list of students.
Thanks.
Jan 27, 2020 04:07 AM
Hey there! my recommendation is that you put the other data in a different table and reference it using a “link to”
so create one table for Students and another for classes.
Hope that helps!
Jan 27, 2020 04:46 AM
Thanks @andywingrave. I’m not sure how this will solve the problem that the data disappears when I scroll down. Am I missing something…?
Jan 27, 2020 04:50 AM
Hey! Yes - Because each Student would be aligned with a class, so the data will scroll with you, as it will now be on the record?
Please can you give an example of the data you’re trying to freeze?
Jan 27, 2020 05:03 AM
h*ttp://prntscr.com/qthlag (I can’t post images or links - a rep issue probably? Please remove the asterisk)
That is the general layout, the gray BG is the data that I want to remain fixed when I’m scrolling. In Excel I just hit “freeze panes” when standing on B5 and it does the trick :slightly_smiling_face:
Jan 27, 2020 05:32 AM
You could try something like this -
But this is just replicating the data structure you have. I would probably recommend a timetable like structure for this - Perhaps look in the airtable universe for some inspiration - Eg: Shool Club Management System - Airtable Universe
Jan 27, 2020 05:49 AM
Thanks @andywingrave, I will keep exploring :).
Apr 28, 2023 10:53 AM
Honestly can't believe this is still not possible 3 years later....such a basic thing 🙃