When I open a FMP database via IWP, it always defaults to a sort based
on record creation date. I'd prefer to create a script (or somehow
specify a different default sort) that sorts based on my criteria. I've
created the scipt with steps that are all IWP-compatible, but how do I
trigger it to occur when someone logs into IWP using a browser session?
What's the script step that handles this?

Thanks in advance, and apologies if this has been answered previously.
I searched but found nothing similar in the archives.

Check File...File Options.

There's an option there to run a script at opening.

G

Tim wrote:

Right, that much I know. That's checked now, but I think that's for the
opening of the file on the host machine. I'm trying to make it execute
when initiating a remote browser session using Instant Web Publishing.

Thanks for the response.

-tim

Grip wrote:

No, it's not just for the host machine. The script you specify activates
whenever someone opens the file, even as a client of a hosted file, and even
via IWP.

"Tim" <tim.pritchard (AT) gmail (DOT) com> wrote

Yup, that actually did the trick - I just needed to add the step of
going to what was now the first record. The sort was leaving me in the
last record after the sort was complete, so I didn't realize that it
had sorted. Adding the Go to Record [First] step set things right.

Thanks again...

-tim

Bill Marriott wrote:

One other question that now occurs to me - if I want the sort to end up
leaving me at the record closest to the current date, but in the future
- when none of the records may match the date on which the database is
being accessed - is there an easy way to pull that off?

In other words, say I have records that have dates in the date field
(which is my sort criteria) - maybe 1/6/07, 1/10/07, and 1/26/07 - and
it's 1/8/07. I want the record with 1/10/07 in it to come front and
center after the sort. Is there an extra step in the sort that will
make that happen? I assume it'd be a variation of the Go to record
script step I'm using now, but I don't know what criteria to enter in
the 'by calculation' script option, assuming that's the way to get it
done.

Thanks - again - in advance.

-tim

Tim wrote:

And yet another idea surfaces. I've worked around my question below by
creating a 'pending/complete' field to denote those records which are
in the future - all that's required for this to work properly is for me
to manually update that field to correspond with the correct status -
'complete' for those in the past, and 'pending' for those in the
future. This works well now since all the records in the future are in
the current month, but when a bunch of records with dates 4 months out
are added, this will start to fall apart, though.

I know I need to understand the date calcs better - it seems as though
there needs to be an if/then calc happening here, but I don't know how
to make the comparison with the current date - is there an operator for
that somewhere that I'm missing?

Another new wrinkle is that it'd be great if I could apply this sort
conditionally - in other words, show a different first record to groups
of people with different privilege sets, or by specific account login
name. Can't seem to access account names or privilege sets in a
calculation field dialog when trying to modify the script, though.
Anyone have any ideas about that?

I realize this is a lot, and far afield from the scope of my first
post. Thanks for any help you can provide.

-tim

Tim wrote: