Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

How do I "freeze" a column

Featured Replies

  • Newbies

Is there anyway that I can freeze a column like in Excel in a filemaker database? I have a DB with names that are the first Field column and I want to freeze the pane so when I scroll waaaay over to the right they'll travel with me confused.gif

You can simulate this using related fields and a relationship for each column. Make your layout no wider than your screen width. Determin number of columns. Set up a global field which will be the key field for the first data column to be displayed. Set up calculated fields to be key fields for the remaining columns, i.e., if the increment in the key is 1 then the next field is the global + 1. You need scripts to navigate left and right. The scripts set the value of the global. When run it gives the appearance of scrolling. You can have buttons that scroll one column, one page or to the begining or end.

  • Author
  • Newbies

Thanks Ralph!

Let me know if you need help with this.

  • 6 years later...
  • Newbies

Hi Ralph,

I'm really interrested in the technique you describe.

Could you please send a small database example using this technique ?

Thank you very much for your help,

Pascal

The original date on this is 2004! Don't expect an answer. BTW, if you need this, imho, stay in Excel.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.