FMPRO-L Archives

March 2014, Week 1

FMPRO-L@LISTSERV.DARTMOUTH.EDU

Options: Use Monospaced Font
Show HTML Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
John Weinshel <[log in to unmask]>
Reply To:
FileMaker Pro Discussions <[log in to unmask]>
Date:
Sun, 2 Mar 2014 11:31:42 -0800
Content-Type:
multipart/alternative
Parts/Attachments:
text/plain (4 kB) , text/html (14 kB)
I'm not clear just what the problem is, but that may be because I am not
following how you want to enter the ports.

Here's what I think you are describing. Please correct me where I'm wrong:
1. Users will be fiddling with the itinerary, so you need to update the
departure and arrival dates whenever any of the length of stays are changed.
2. If that is the case, that update would be managed by a script that, in
pseudo code, looks like this:
> 1. Set Variable $ArrivalDate to the date of the arrival in the first port.
> This could be a date field or global date field in the parent record.
> 2. GTRR to child records (best done in a separate window).
> 3. Sort the found set of child records by day number. You can't use the date,
> because it's being changed and is thus not dependable. If these might be
> switched around, you'll need a way to change these day numbers. They should
> not be primary keys.
> 4. Go to the first record.
> 5. Loop
> 6. Set Field[Arrival_Date; $ArrivalDate]
> 7. Set Variable $ArrivalDate to Departure_Date (the calculation of
> Arrival_Date + number_of_days)
> 8. Go to Next Field [exit after last]
> 9. Close Window (Current Window) if the GTRR in step 2 opened a second window
I can't otherwise see how 'arrival date is the departure date from the
previous record in the portal' would work easily and be dependable.
Extracting that previous record's departure date is doable but requires a
bit of extra programming. A loop for a handful of records should run almost
instantly. You could trigger it to run whenever a length-of-stay is changed,
but that seems tedious and a simple 'Update' button next to the portal ought
to suffice. If you do decide to use an on-mod trigger when the
length-of-stay is changed, make sure that field's value uses a pulldown list
of numbers; otherwise, the script will run after the '1' is entered for a 10
day stay. Not necessary if stays are dependably always shorter than 10 days.

I am assuming you are entering child records into a portal, on a Voyages
layout, where 'Allow creation of related records' is enabled for the
portal's TO. But, as I say, that may be a false assumption.

John Weinshel

From:  Peter Buchanan <[log in to unmask]>
Reply-To:  FileMaker Pro Discussions <[log in to unmask]>
Date:  Sun, 2 Mar 2014 15:12:30 +0200
To:  <[log in to unmask]>
Subject:  Re: Exit portal trigger

Hi John
 
I have two tables, Voyage (parent) and Ports (related records).
 
For each voyage, user creates portal records,  entering a port name and
number of days in each port. A departure date (calculation field) = number
of days plus arrival date.
 
Arrival date is the departure date from the previous record in the portal.
Except in first record, where user enters a date.
 
I run a loop script to set the arrival date into each record. GTRR, go to
first record, set departure date to a variable, go to next record, apply
variable to arrival date field etc.
 
I am trying to trigger the loop script when the user exits the portal,
instead of having to click a button on the layout to recalc the dates.
 
Regards
Peter
 
 
 
 
 

From: FileMaker Pro Discussions [mailto:[log in to unmask]] On
Behalf Of John Weinshel
Sent: 02 March 2014 04:40
To: [log in to unmask]
Subject: Re: Exit portal trigger
 

So far as I know, the portal object itself cannot be entered or exited.

 

While you can name the portal and try to capture its focus state using
GetLayoutObjectAttribute(portal_name; "hasFocus" or "Source" or
"ContainedObjects"), an OnObjectExit script setting this value will not fire
when you move into or out of the portal. Running that script on entry from
every other enterable object on the layout would be a terribly kludgy
workaround.

 

I'd be happily surprised to hear that a portal is exit- and enter-able.

 

What are you trying to accomplish? There may be another way to get there.

 

John Weinshel

 

From: Peter Buchanan <[log in to unmask]>
Reply-To: FileMaker Pro Discussions <[log in to unmask]>
Date: Sat, 1 Mar 2014 17:35:56 +0200
To: <[log in to unmask]>
Subject: Exit portal trigger

 

Hi
 
Windows and FM 12 Pro.
 
Is there a script trigger that will run when a user clicks (with mouse)
anywhere outside the portal?
 
I tried OnObjectExit, but this runs each time user moves to the next portal
row, whereas I only want the script to run when he exits the portal.
 
Thanks
 
Peter
 
 




ATOM RSS1 RSS2