Jump to content

Can't get this script to work


This topic is 7147 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I'm a little unclear on what exactly you're looking for. It looks like you're trying to do a find on seperate files at the same time, including unrelated records. Is that correct?

To save a find, you basically need to use Scriptmaker. You can either perform the find manually and then save it within the "Find[Restore]" script step, or you can have scriptmaker walk through the steps of the find.

A key point, if you can't perform the find manually, you won't be able to do it with Scriptmaker.

Link to comment
Share on other sites

You may need to combine a Find with some kind of looping Omit script. In contacts, you could have a calculation, I'll call it Crusty:

Max(SALES DETAIL::invoice date) less.gif (Status(CurrentDate) - 60)

Now, script a Find in contacts for Active.

Then, script a loop like so:

Loop

. If(folder sheet::Maintenance) or not Crusty

. . Omit

. Else

. . Go to Record (Next, exit after last)

. End If

End Loop

That should leave you with all your Active, non-maintenance contacts who have not done business recently. Now I take it you will mark them Inactive!

Link to comment
Share on other sites

This topic is 7147 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.