Scripted Multiple Find Request

[Chuck]

Are the fields you are pasting into on the layout that you are on when you are trying to paste? If not, then the paste won't work.

I tend to avoid copy and paste unless what I'm trying to do isn't possible in any other way, or the other way would take far longer and be far more complicated (so I sometimes use Copy All Records to get all of the IDs for a found set, for instance). Part of the reason for this is that I don't want to eliminate anything the user may have in the clipboard (this is the dominant reason), but the other reason is that you must have the field on the layout to use these steps.

Set Field doesn't have this limitation. You can use Set Field to alter the value of a field regardless of if it is on the current layout or not. Also, if tempname isn't a global field, then it can't be referenced while in Find mode.

Try rewriting your script like this, where tempname is a global field:

code:

---

Go to Layout [ searchname ]

Pause/Resume Script

Enter Find Mode []

Set Field [ owner1, tempname ]

New Record/Request

Set Field [ owner2, tempname ]

New Record/Request

Set Field [ owner3, tempname ]

New Record/Request

Set Field [ owner4, tempname ]

Perform Find []

Go to Layout [ listview ]

---

Make the Search button on the layout that the user enters the value into tempname simply a "Resume Script" step. This way the user can either hit Enter or click the button to continue the script.

Chuck

[ June 26, 2001: Message edited by: Chuck ]

[ June 26, 2001: Message edited by: Chuck ]

[RBSolutions]

I have a solution that allows a user to input a name in a search field, then select the search button. This data must then be passed to 4 other fields using the New Record/Request function. I have a script written that seems to go stupid in its current configuration and I could use some help.

The nitty gritty of my requirements are

User enters search criteria into tempname and selects SEARCH

data in tempname is passed to $file:Owner1, $file:Owner2, $file:Owner3, $file:Owner4 using the New Record/Request function (This is necessary because it is possible for up to 4 people to be joint owners of a piece of property and I must find all instances of tempname in each field)

($file:Owner1, 2, 3 & 4 are portal fields)

the user is then taken to the layout "listview" where the results is displayed

My current script looks sort of like this - (not the exact Filemaker code, but you'll get the point)

goto layout ("searchname")

copy select ("tempname")

enter find mode()

paste select ("tempname","owner1")

new record/request

paste select ("tempname", "owner2")

new record/request

paste select ("tempname", "owner3")

new record/request

paste select ("tempname", "owner4")

perform Find

go to layout ("listview")

Would I be better off to do this in a loop function? It's really frustrating since it looks like it should work. Any ideas that you have would sure be appreciated.

Dan

[ June 26, 2001: Message edited by: RBSolutions ]

[RBSolutions]

Thanks Chuck, you're a life saver. As I suspected, it was "simple" thing that I had performed before but had brain-skipped in my current situation. This should work out well. I'll come back and post the script for others once I get it worked out.

Dan