Skip 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.

Conditional formatting across two records?

MariaAux
in Calculation Engine (Define Fields)

Featured Replies

Hi there,

I have list of classes (6 on Mon, 7 on Tue etc. - 40 records in all) in list view that I would like to print with a thick balck line between the days, not between each class. I was having a think how to do this and the only solution I could come up with was to create a an empty text box and create a conditional formatting in which if the 'Day' field in the current record is different to that of the 'Day' field in the next record, then the empty text box would be conditionally formatted as black fill.

However, I am struggling to create a formula for comparing the data of a recordm in a current field with the data of a record in the next record... Would you please be able to help me? Or even better, do you have any ideas how to do this another way?

Thanks so much in advance and have a fabulous day.

Why don't you use a sub-summary part (when sorted by day)?

  • Author

That is exactly what I was looking for. Elegant, easy solution.

Thanks so much and have a fabulous day.

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

Account

Navigation

Search

Search

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.