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.

evaluate field then label, otherwise slide

RacingLists
in Calculation Engine (Define Fields)

Featured Replies

Hi: I checked my trusty book, 'FileMaker Pro 8 THE MISSING MANUAL', and it's missing all kinds of things.

I have three rows of data in the body - data1 to data3. Data1 always appears in every record and there's a mix of data2 and data3 appearing. I would like to label the data on the same row in the body of the layout only if there is data present. That way, if there's no data, the fields and labels don't print and everything slides up. In the example provided, the calc doesn't work, can anyone help? Thanks in advance! Maybe there's a better way to do this?

Labels.ZIP

Is this for a report? I think you might not be aware that sliding only works in preview mode. Switch to preview mode and see if it is doing what you are expecting.

To do this in browse mode is a much trickier matter...

-Raz

  • Author

yes, in preview mode is what I want to do. I've solved it- sort of - I think - or at least it works. I created a value field with a radio button, label3mark, marked it, and viola. Anyone with an easier way without having to mark the records?

You have a syntax error in your calculation. Try instead:

If ( not IsEmpty ( Data2 ) ; "Datalabel2" )

You can also combine all labels in a single calculation field:

"Label 1" &

Case ( not IsEmpty ( Data2 ) ; "¶Label2" ) &

Case ( not IsEmpty ( Data3 ) ; "¶Label3" )

Adjust the field's line spacing to align each label with its data field.

  • Author

absolutely great. Thanks! I'll give it a go.

Create an account or sign in to comment

https://fmforums.com/topic/41852-evaluate-field-then-label-otherwise-slide/
Go to topic listing

Important Information

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

I accept

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.