Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

Posted

To start off, I am still pretty knew to FM7 and even newer to scripts, so if something is written wrong I am sorry. Anyway, in my DB I am trying to make a report that will list all our open orders at any one time. I have it set up right now with just a simple radio box ("Job Complet Y or N") that needs to be updated manually when a job is completed(which is a little clumsy but best way i could think of; would love suggestions on that). I set up a script that will work(once) but when I would go list all records, run it again, it would list every record regardless of what was checked.

I have two expenations I think can explain it. First, is that I'm setting up my layout wrong somehow. This is how I set it up. I did a search with "Job Complete=No", then switch to layout view and create a New Layout/Report using the wizard and then set up my criteria. When I switch to browse view it is perfect. Second, my script is wrong because it is not actully "Finding" my records.

Here is my script:

-Enter Find Mode [Restore]-(action) Find Records-(criteria) Order Entry::Job Complete [=No]

-Go to Layout ["Open Orders-Shop"(Order Entry)]

-Enter Browse Mode[]

-Sort Records [Restore;No Dialog]

Thank you for any help.

Posted

Try

-Enter Find Mode [Restore]-(action) Find Records-(criteria) Order Entry::Job Complete [=No]

-Perfom Find

-Go to Layout ["Open Orders-Shop"(Order Entry)]

-Sort Records [Restore;No Dialog]

You need to do a Perform Find after entering Find Mode. If you do not the find is not performed and when it got to Enter Browse Mode it ignored your Find critera

Posted

You need a Perform Find [ ] step after entering Find Mode, or nothing happens. Is the find performed on a layout associated with the Order Entry TO?

This topic is 7089 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
×
×
  • Create New...

Important Information

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