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 to preserve field format when pasting text?

John McDaniel
in Calculation Engine (Define Fields)

Featured Replies

  • Newbies

When pasting text into a FM field from the Finder (as in copying a filename) or when pasting text from another application (Text Edit, for instance), the FileMaker field takes the text and maintains the format of the text as it was formatted in the source document. Is there any way to prevent this?

Can you set a field to take any text pasting and convert it to the format settings for that field?

Thanks for any help (using FM 5.5 BTW).

John McDaniel

Paste without style.

On a Mac it is the key combination of Cmd Option V

HTH

Lee

  • Author
  • Newbies

True.

Well... count me as one who thinks there should be a "conform data pasted from external source to field format" option for text fields. Just trying to make things as simple as possible for a database user.

Thanks, j mcd

You can workaround this problem in a couple of ways.

1. Create a script that replaces the field with itself

2. You can always hide the field once it has been pasted into, by stacking a calculation field that equals it on top of it.

For an example of this, see my file Phone Number Entry that I attached to this thread (Layout Stacked) Click Here

HTH

Lee

Create an account or sign in to comment

https://fmforums.com/topic/18430-how-to-preserve-field-format-when-pasting-text/
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.