"Standard-Text" Insertion

[AeroGuy]

I used FileMaker to create a database for my company's Invoicing/Quotation system. When creating Quotations for companies, there are certain phrases/words, etc that employees will have to use on a regular basis. In the past, Invoices and Quotes were made using Microsoft Word and there was a way of saving certain 'standard-text' into the program and then just inserting it whenever you needed it (to help speed up the process'n whatnot)...

is there any way of doing this in FileMaker? is there a way that i can save different phrases/sentences/paragraphs in FM and then just choose to insert it whenever i need it?

Thanks,

Me

[Lee Smith]

You can do this.

You will need to create a field to hold the phrases in (I would make it a repeating field), a value list of keywords that represent the different phrases, and then make your display field a calculation, that will get the repetition based on which keyword is selected.

HTH

Lee

[Fitch]

A simple way would be to create a phrase field, and format it as a value list.

Put a button next to the phrase field, that runs this script:

Insert Calculated Result (phrase)

Be sure that "Select contents" is NOT checked. Also, don't specify a field -- that way, you can insert text into any field, wherever your cursor happens to be. Specify only the calculation.

Now, you may run into a problem where you select a phrase then immediately click the button, without first clicking into another field. This will cause the phrase to be inserted again into the phrase field, and we don't want that. The solution is to modify your script like so:

If (not Status (CurrentFieldName) = "phrase")

.. Insert Calculated Result (phrase)

End If

[AeroGuy]

Dear Fitch,

I created the phrase field (i call it "Common Phrases") that holds a list of words (blah1, blah2, etc...) by way of a value-list. so, after creating this field, i'm able to click on it (while in Browse Mode) and choose a phrase (blah1, blah2, etc).

The problem is that these phrases aren't being inserted into the field (a large, textbox-like field called "description") after i run the script/button. My script is just one line and is as follows: Insert Calculated Result ["Common Phrases"]

This is correct, right? so, while in browse-mode, i go to the Common Phrases field, i choose the phrase that i want, then i click in the "description" text-box, and then i click on the button to insert the phrase... but it doesn't work. what am i doing wrong here?

[andygaunt]

Hi

Now follow this post instead

As you keep posting the same question!!!

Did not see this post before replying to one of your other posts.

[Fitch]

The attached file demonstrates the technique I described.