Hi everybody,

I have a simple filemaker database with several fields. when I press Command+C without selecting a single field, my clipboard gets a chain text of all fields of the selected record separated by tabs.

I dont have any experience with filemakers scripting or with apple scripting.

What I want to achieve is to modify this copied data. Lets say I only want to have the content of selected fields, separated by a "n".

My first approach was to try to do this with automator, but I couldn't figure out how to manipulate the clipboard content.

My next approach was to somehow do it in filemaker: either with a button that copies the the defined fileds to the clipboard or with a field, that actually displays the content of defined fields, is note editable but one can copy the content into the clipboard.

If someone could tell me what approach is the most promising one and how this could be achieved - that would be great!

Thanks in advance!

Best,

tromton

Edited March 21, 201015 yr by Guest

Use a layout that contains the fields you want.

thanks for you reply!

i have actually done that, I have done a Label layout, where i could fill in content of different field from one record, that was exactly what I whanted. Only problem for me was that I could not copy this information, since the content of the label layout is not selectable. I can copy the whole record, which gives me a string with the selected field of the label layout separated by tabs, but not in the formatted way I want it to be.

Is there a way to make a layout like the the label layout, but with a selectable content field? or even better, can i somehow control the content that is going to the clipboard, when I copy the record?

thanks for your thoughts!

best,

tobias

But you already said you knew exactly how to do that. So it isn't at all clear what your question really is.

"when I press Command+C without selecting a single field, my clipboard gets a chain text of all fields of the selected record separated by tabs."

Yes, I was actually not looking for a way to copy all the fields, but only a selection of fields formatted in a defines way.

I actually found a way to do it, by adding a new calculation field to the table, and doing a text output with a formula like this:

Field & "¶"" & Field2 & ", " & Field3 & "¶" & Field4 & "¶" & Field5 & "¶ This and That:" & Field10 & "¶" & Field13

Thanks for your help anyways.

Best,

Tromton

You don't need a calc field; you can just use a global and a script.

Set field[ gClip; thisField & "¶" & thatField etc]

Freeze window

Cut[gClip]

Commit record

The global needs to be on the layout but you can make it small and even place it under something if you want to hide it.

You could also use AppleScript to set the clipboard directly, with no additional fields required.