Find Script

[drbigwillystyle]

I need to make a search script that will take the information from one field on a layout and search all of the records and display them on a different layout. Please help.

[The Bridge]

quote:

---

Originally posted by Willy Devorak:

I need to make a search script that will take the information from one field on a layout and search all of the records and display them on a different layout. Please help.

---

Based on your description, I'm assuming you want to do something like the following:

You are on a layout that shows detail for, say, a person at a company.

You want to be able to find all other people at that company and go to a list layout.

One approach would be to do this:

Create a global text field called Temp_Company (using the example I gave above)

Your script would be something like:

Set Field (Temp_Company) = Company_Name

Enter Find Mode

Set Field (Company_Name) = Temp_Company

Perform Find

Go to Layout (List_Layout)

Hope this gives you a start in the right direction

[drbigwillystyle]

I tried this and it only showed the record that the layout i want to search was on. Have anything else?

[The Bridge]

quote:

---

Originally posted by Willy Devorak:

I tried this and it only showed the record that the layout i want to search was on. Have anything else?

---

The layout you want to end up on should be in List View. Go to the View menu and select View as List. This will display all records in the current found set as formatted in the layout. Try to keep the Body part as small as possible to maximize the number of records shown in the list.

I'm guessing by your response that there's some confusion between a record and a layout. The information in a record doesn't change from layout to layout, just the information displayed.

Hope this helps!