Suppress No Records Found message

[John Chamberlain]

This is going to seem very trivial, but my users have asked for it, so here goes:

I have an opening script that searches for duplicate or incomplete records. Most of the time there are no records to correct.

Is there a way to suppress the "No Records Found" message, and just exit the script if there are no records to display?

[bcooney]

Use Set Error Capture On before the Find.

Use If [ get (foundcount)=0]

in your script to probably Go to a Layout.

[millmaine]

I have a script that does exactly this and works well.

Our situation requires it to go a step further in that it creates a new record once it arrives at the new layout.

What I'd really like it to do is even one more step and set two fields of that new record with the data entered into those fields in the original find request.

Any thoughts?

[bcooney]

You'd need to capture their search criteria. One way is to have them enter criteria in global fields. Then the Find button would run a script that enters find mode, sets the fields to the globals, and performs find. If no recs are found, go to layout, new record and use set field to set the desired fields to the globals.

[millmaine]

That's what I've been trying but I must have a flaw in my logic because I've spent hours on this now and just can't make it work.

I hate asking for someone to do the work for me but is there an example script you can show me?

[John Chamberlain]

Here you go

[millmaine]

?

[John Chamberlain]

Sorry for that - User Name is John, and no password is necessary

[John Chamberlain]

Even more embarrassing Password is Gracie!

[bcooney]

See attached demo.

FindNew.fp7.zip

[millmaine]

Thanks, I got there in the end but this is nice and elegant and helps a lot.