Skip to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Can't get this script to work

Featured Replies

I need to set up a script that will perform the following search.

1. find ALL aCTIVE DEALERS from THE [ CONTACTS ] file

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.

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!

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.