Find and global fields in FileMaker 7

  • Follow


FM 7 Mac OS X

In my customer database I'm trying to set up a script that either use
the name enterered in a global text field to make a new record or do a
find for similar records. The first works well, but I'm not able to get
the global value into the find request. I've tried Go to field, Set
field, Insert text and calculated result, Copy and Paste, Perform
another script, but it seems that the value in the global field not is
present before after Perform find.

I would be very pleased to come further with this one.
-- 
Rgds Helge Hafstad
helge.hafstad@mac.com
Bergen - Norway     
0
Reply helgehd (2) 3/3/2005 11:03:49 PM

Helge Hafstad <helgehd@start.no> wrote:

> FM 7 Mac OS X
> 
> In my customer database I'm trying to set up a script that either use
> the name enterered in a global text field to make a new record or do a
> find for similar records. The first works well, but I'm not able to get
> the global value into the find request. I've tried Go to field, Set
> field, Insert text and calculated result, Copy and Paste, Perform
> another script, but it seems that the value in the global field not is
> present before after Perform find.
> 
> I would be very pleased to come further with this one.
A quick idea:
Maybe you can use the Let function in your script before entering find
mode.
0
Reply no 3/4/2005 10:15:18 AM


Jens Rasmussen <no@way.dk> wrote:

> > FM 7 Mac OS X
> > 
> > In my customer database I'm trying to set up a script that either use
> > the name enterered in a global text field to make a new record or do a
> > find for similar records. The first works well, but I'm not able to get
> > the global value into the find request. I've tried Go to field, Set
> > field, Insert text and calculated result, Copy and Paste, Perform
> > another script, but it seems that the value in the global field not is
> > present before after Perform find.
> > 
> > I would be very pleased to come further with this one.
> >
> A quick idea:
> Maybe you can use the Let function in your script before entering find
> mode.

Thanks, Jens, but the global field is filled in before entering Find
mode, so I can't see the difference. Anyway, I'm not familiar with the
Let function so anyone could eventually give me some help here...;-)
-- 
Rgds Helge Hafstad
helge.hafstad@mac.com
Bergen - Norway
0
Reply helgehd 3/4/2005 1:40:50 PM

you have entered the value in the global field
in the script
goto search
set <mySearchField> to <myGlobalfield>
perform find

should do the trick

Ursus



"Helge Hafstad" <helgehd@start.no> schreef in bericht 
news:1gstk1g.1p936oy1hnkaz4N%helgehd@start.no...
> FM 7 Mac OS X
>
> In my customer database I'm trying to set up a script that either use
> the name enterered in a global text field to make a new record or do a
> find for similar records. The first works well, but I'm not able to get
> the global value into the find request. I've tried Go to field, Set
> field, Insert text and calculated result, Copy and Paste, Perform
> another script, but it seems that the value in the global field not is
> present before after Perform find.
>
> I would be very pleased to come further with this one.
> -- 
> Rgds Helge Hafstad
> helge.hafstad@mac.com
> Bergen - Norway 


0
Reply ursus 3/4/2005 2:13:20 PM

"Helge Hafstad" wrote:

> FM 7 Mac OS X
> 
> In my customer database I'm trying to set up a script that either use
> the name enterered in a global text field to make a new record or do a
> find for similar records. The first works well, but I'm not able to get
> the global value into the find request. I've tried Go to field, Set
> field, Insert text and calculated result, Copy and Paste, Perform
> another script, but it seems that the value in the global field not is
> present before after Perform find.
> 
> I would be very pleased to come further with this one.

I'm not sure I understand what exactly you are trying to do but this may
help.  The global field value is the same for every record.

Global field named global1
Text filed named field1

The text is entered manually into global1

To perform a find in field1 using the contents of global1:

Enter find mode
Set field (table:field1; table:global1)
Perform find

What error are you getting exactly?

Geoff

0
Reply G 3/4/2005 3:19:44 PM

4 Replies
296 Views

(page loaded in 0.07 seconds)

Similiar Articles:













7/22/2012 8:00:51 PM


Reply: