Re: Email Campaign managment and Portals



Did you remember to drag a field into the portal area of the layout,
and specifying its definition? (Are the relationships set right?)
otherwise...(quoting)
you want to duplicate the parent record and also all related
records (all the portal's content).

right

One way to do that is to export the related records, create your new
record
in the parent file, set a global to the ID of that new record, and then
import the related records back into the child file and set their
parent_ID
to the value of the global.

In the parent file
- Go to related records (show only related)
- Perform sub-script (external) (Export script)
- duplicate record
- set field (global_ID, ID)
- Perform sub-script (external) (Import script)
- refresh window

In the child file
1. Export script
- Export Records (Restore, No dialog, "temp.fp5")
(You'll have to perform the export manually once, then open the script
as if
to edit it. As you click OK to close the edition window, a dialogue
will
come up asking whether you want to keep or replace the export order.
Choose
to replace).
2. Import script
- Import Records (Restore, No dialogue, "temp.fp5")
(Same as with the export. Do it manually once and then open the script
and
set it to use that import order)
- Replace (No dialog, parent_ID, constant relationship::global_ID)

A constant relationship is a usefull technique to pull data from other
files. You define a calculated field (=1) is each file, and use a
relationship between these fields to access globals in other files.
((c)Marc-André Paiement)

.



Relevant Pages

  • Re: bash: use global/local in a single process script?
    ... process script. ... I infrequently write small scripts for build management purposes. ... I know that all variables in a bash script are in fact ... (Actually programs do access globals from the environment, ...
    (comp.unix.shell)
  • Re: Go to related records then find a subset
    ... > I have scripted a Go to related records. ... > Find script step that includes all the desired parameters + the flag ... run a second script in the related file that uses that data plus the ...
    (comp.databases.filemaker)
  • Re: Speed quirk: redundant line gives six-fold speedup
    ... > referenced again, directly or indirectly, by the rest of the script. ... It seems to be related to the number of globals. ... module level globals have bad lookup times compared to function ... I'm very surprised that the lookup times jump around so much. ...
    (comp.lang.python)
  • Re: Set Field vs. Copy/Paste
    ... and likewise a portal on the Donations layout allowing creation of film ... In the first script, you don't need to go to the related record. ... into globals before creating the record. ...
    (comp.databases.filemaker)
  • Re: Classes / Functions / Autonomy
    ... and they will never interfere with the rest of the script. ... Of course when I first started out, I was using globals. ... Hrm, Im thinking of things like Database Name, Highlight Colours, I even went anal at one point and stored a URL that would retrieve info from a database. ... var bgColor; ...
    (comp.lang.php)