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.

Featured Replies

I don't know what else to call it.

This didn't happen in FileMaker 6 and I'm at a loss: If you string together text and a field from a related table, either in a concatenated field or as a merge field, FileMaker insists on making a new line of everything beyond the field content, including the initial space after the ". It doesn't do it if the field is in the same table, however. The workaround is obvious, but I hate to create unnecessary fields just for the purpose.

Is there another way?

Huh?

Can you post a screen shot?

  • Author

OK.

First the field in layout mode. Nice and long.

Second what appears in browse mode.

Can't add more than two files, so continues in next post.

Bild_1.png

Bild_2.png

  • Author

Then add a second line to layout

and you get the rest of the contents of the field in the second line, including the initial space.

(ggds....) is the contents of the related field :

Posting the definition next...

Bild_3.png

Bild_4.png

  • Author

Here's how the field was defined.

Exactly the same thing happens if I write the text in the layout and include the related field as a merge field. It doesn't happen in either case if the field is from the same table.

Bild_5.png

Whats in that related field... are you sure there isn't a paragraph?

Try this just incase:

"Line one " & Substitute( yourfield ; "¶" ; "") & " the rest"

If that display's correctly then you have a paragraph in your related field.. If it doesn't display correctly welll... Ah, replicate the problem in another field and post it.

Cheers

It works fine for me. Can you post a layout shot of your Bild_4.png shot? You might be jumping from various examples and not pinning down the problem ... it happens sometimes when testing.

Can you also read me your Format > Line Spacing > Custom settings (after selecting the field)?

LaRetta

  • Author

Eureka. Thank you for your help.

It seems there was a paragraph in the related field - because it is the result of a Get Value;1 function. Apparently that includes the carriage return at the end of the first line. Should have occurred to me. Thanks for putting me on the right track!

GetValue should not include a pilcrow. LeftValues will though. Maybe that's what you're using?

  • Author

Sorry, you're right, it was LeftValues...

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.