Q: how to save found list 
Author Message
 Q: how to save found list
Does anyone know of a way to save a found list so that it can be
recalled?

Thanks.

Dave



Sat, 26 May 2001 03:00:00 GMT
 Q: how to save found list

I keep an extra layout with nothing but blank buttons with the default
script definition assigned when a script is created (minus the print and go
to layout command). If I do a find that I want to do again in the future, I
go to this layout, edit the script assigned to that button, and replace the
old find request with the new. It takes about 20 seconds to do this and
rename the button. If you want to do that find again, go to your button
layout and press the button for that find.

Alternatively, if the list is created not only with finds requests but with
omits, etc, you can create a field to store comments. If you call this field
"Find Comments" all you have to do is perform a Replace in this field so
that Find Comments=Find Comments + "fill in a comment here". This works well
for a while as it allows you to specify individuals to relocate but the Find
Comments field tends to get crowded after a while and needs to be cleaned
out - thus eliminating your ability to preserve these groupings over time.

Damian Brennan

PS there is a relational way to do this using an record ID number and the
import command but it is a bit more laborious unless properly scripted.

Quote:

>Does anyone know of a way to save a found list so that it can be
>recalled?

>Thanks.

>Dave



Sat, 26 May 2001 03:00:00 GMT
 Q: how to save found list

Quote:

> Does anyone know of a way to save a found list so that it can be
> recalled?

Do the find, then sort and display the list as you wish, then create a
script. The default script will restore the find, sort and layout which
originated the list. Customize to suit your requirements.

If it's a one-off list, you might export it as a file of some kind (SYLK,
tab-delimited, merge, whatever) for use in a word processor/spreadsheet,
whatever. That process, too, could be automated by a script.

--
Piers



Sun, 27 May 2001 03:00:00 GMT
 Q: how to save found list
Thanks for all the suggestions. As I need to recall lists that have odd
items included by omitting, I think what I'll do is create a new field
that will store a unique name assigned to the found set.

Dave



Sun, 27 May 2001 03:00:00 GMT
 Q: how to save found list
Another useful tool is a selection box field, for temporary recall of
complex data subsets.

The selection box field holds an X or nothing (or whatever marker you
like). Create a script to toggle the selection box, and make the box a
button to run the script. Then clicking on the box will toggle the
selection.

Other useful scripts include selecting a found set (replace), omitting a
found set (loop omit), and clearing all selections (replace). You will
need a script to find the selections if you are using a toggled
selection box.

Using this method, you can find different sets of records, batch marking
them as you go, and then find the selections to print or omit for your
final dataset.

Don't forget to clear all selections before beginning a job.

--- Margaret Nupponen  :)



Sun, 27 May 2001 03:00:00 GMT
 Q: how to save found list
I have put together a quick example of a file and scripts that I use to
save and later find any found set.  I have sent a copy to M. Hobbs and
would be happy to send the same to all who request it.  Reply to

PC will receive .zip file, (small downloads).

Al Partridge

Quote:

> Does anyone know of a way to save a found list so that it can be
> recalled?

> Thanks.

> Dave



Sun, 27 May 2001 03:00:00 GMT
 Q: how to save found list

Quote:

> I have put together a quick example of a file and scripts that I use to
> save and later find any found set.  I have sent a copy to M. Hobbs and
> would be happy to send the same to all who request it.  Reply to

> PC will receive .zip file, (small downloads).

> Al Partridge


> > Does anyone know of a way to save a found list so that it can be
> > recalled?

> > Thanks.

> > Dave



Sun, 27 May 2001 03:00:00 GMT
 Q: how to save found list

Quote:

> Does anyone know of a way to save a found list so that it can be
> recalled?

> Thanks.

> Dave

David,

I just answered this question in comp.sys.mac.databases here is the
solution again.

Subject:
             Re: Adding Records to Found Set
        Date:
             Fri, 11 Dec 1998 02:19:40 +1100
       From:

 Organization:
             Customer of OzEmail/Access One Pty Ltd, Melbourne,
Australia
 Newsgroups:
             comp.sys.mac.databases
  References:
             1

Quote:

> Is there any way of adding to a found set of records by doing

additional
finds?
Quote:

> I get a printed order form created in another system that has a
list of
> items on it. I have a Looping Script that allows me to simply
enter one
> find request after the other to check to see my Filemaker Pro

database
has

Quote:
> the corresponding items. If they don't exist, I exit the loop and
enter
> them into my FMP database.

> Is it possible to retain the items I find into a single set as I
loop
> through checking to see if my FMP data matches, essentially
building the
> identical order list as I go along. It would be great after
looping
> through the finds for individual records that I would have a
complete
> order list in FMP to look at.

> I could then export the found set, name it by order number and
retain the
> order intact as a Filmaker document.

  Mike,

Within your loops after you performed the find and paused the loop
add;

If ["Status( CurrentFoundCount) = > 1"]
    Set Field ["new flag filed",  ""x""]
    Replace ["new flag field", "Current contents"]
End If

After the loop add;
Perform Script [Sub-script, "Find flagged"]

A second script is required, name it Find flagged which will

Find (Restore)

You have to perform the find once on the new flagged field and then
create
the
second script.

Hope this will help!

Andy Schwarcz
Emma's Consultants



Tue, 29 May 2001 03:00:00 GMT
 
 [ 8 post ] 

 Relevant Pages 

1. DTS Packages/List when Saved to Repository

2. SAVE LIST HELP

3. Remove incorrectly saved SP, does not appear in the list

4. Saving contents of a list box as a file

5. PROBLEM SAVING CUSTOM LISTS IN EXCEL 5

6. Saving contents of a list box

7. ONDATARTR gives error when trying to list Save-set

8. D3 and FSI issues - Indexing, save-lists etc

9. Help - Unidata and SAVE.LIST with BY.EXP

10. SAVE-LIST / 3 times and you're out

11. Jbase and saved lists

12. OT: save-list in SQL


 
Powered by phpBB® Forum Software