FileMaker Pro, repeating fields and pasting from Clipboard
FileMaker Pro, repeating fields and pasting from Clipboard
- Subject: FileMaker Pro, repeating fields and pasting from Clipboard
- From: Dan Doughtie <email@hidden>
- Date: Wed, 05 Sep 2001 10:01:36 -0400
I'm hoping some of you FMP experts can help me.
I Applescript FMP quite a bit but have been stumped by two items: one
purely a FMP syntax question and one that is more Finder related.
Filemaker's gray difference between a cell and a field is somewhat
confusing. I finally figured out how to find out how many repeating fields
there are in a cell/field. I finally figured out if you set a field's
contents to a variable as a list you get all the repeating data. And vice
versa. If you throw a list at a list at a repeating field you populate the
fields. Here's my dilemma.
If I have a repeating field/cell that has, for example, 10 repeating fields.
How do I retrieve/place data in a specific field, the 7th field for example.
Also, how do I ask which is the last field to contain valid data?
Now here' s the dumb question for the day. FMP has a great feature that lets
you grab all the data on layout, a record at one time or all records. But it
places that data in the Clipboard. I can then manually paste it or have a
FMP script paste it in another field. I want to eliminate the middle man. I
want to have it go straight to a variable.
So, how do you set a variable to the contents of the Clipboard or i.e.
"paste" to a variable in an Applescript?
Thanks,
Dan Doughtie
Morris Computer Services