Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Getting pasted text to conform to a format!


This topic is 6457 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

Hello! We run our business from a Filemaker Pro 8 database we designed and built ourselves. It works very well for our purposes, and has been highly customized to make our lives easy (this is the truly magical benefit of FileMaker Pro).

However, one aggrivating issue we haven't been able to resolve involves getting text that we paste into fields in our database (usually from a website) to conform to the size, color and font we use for the rest of the database. We've checked through the text formatting options for all of the fields, and eventhough they're all the same, when we paste text in, it maintains the color and formatting of the webpage we copied it from. The user then has to select the contents of the field, and change the color, size and sometimes the font back to the defaults. It's a big waste of time, not to mention, it looks ugly when somebody forgets to do it.

Can anybody think of an easy solution for this? Many thanks in advance for your replies.

Jason

Posted

Welcome Jason,

FM7/8 does retain the style of pasted text unless your users use the option to paste without style (hold down the option key when pasting.) But you can also specify an auto-enter calc on those fields to remove the formatting automatically.

In version 7, use this auto-enter calc:

Evaluate ( Quote ( Field ) )

In version 8, you can use:

TextFormatRemove ( Field )

Be sure to deselect the option "Do not replace existing value of field..."

  • 1 year later...
  • Newbies
Posted

Hi -

I'm having the same problem Jason was, but when I try to do what you suggested, it doesn't work. Any idea as to why?

thanks,

Noam

Welcome Jason,

FM7/8 does retain the style of pasted text unless your users use the option to paste without style (hold down the option key when pasting.) But you can also specify an auto-enter calc on those fields to remove the formatting automatically.

In version 7, use this auto-enter calc:

Evaluate ( Quote ( Field ) )

In version 8, you can use:

TextFormatRemove ( Field )

Be sure to deselect the option "Do not replace existing value of field..."

Posted

Checklist:

1) Your field is an Auto Enter Field

2) You have deselected the option "Do not replace existing value of field..."

3) The field you are referencing in Evaluate ( Quote ( Field ) ) is your auto enter field.

This topic is 6457 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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