|
| find from another field |
 |
Thu, 13 Mar 2008 19:30:34 -040 |
This is stupid because it seems like it ought to be easy, but
Filemaker's rules are making it hard.
I want to have a user enter a date in a field, call it findThis, then
run a script to perform a find to find that date in another field. Call
it theDate.
In pseudocode, I tried
enter find mode
set field theDate to field findThis
perform find
But when you go into find mode, all the fields go blank. Set variable
won't do it because apparently you can't set a field value to a
variable. Applescript won't do it because you can't pass variables from
a Filemaker script to an Applescript, and apparently an applescript
|
| Post Reply
|
| Re: find from another field |
 |
Thu, 13 Mar 2008 20:22:22 -040 |
In article <140320081243177564%helpful_harry@nom.de.plume.com>,
Helpful Harry <helpful_harry@nom.de.plume.com> wrote:
> In article <ws21-627B2A.19303413032008@newsstand.cit.cornell.edu>,
Bill
> Steele <ws21@cornell.edu> wrote:
>
> > This is stupid because it seems like it ought to be easy, but
> > Filemaker's rules are making it hard.
> >
> > I want to have a user enter a date in a field, call it findThis, then
> > run a script to perform a find to find that date in another field.
Call
> > it theDate.
> >
> > In pseudocode, I tried
> > enter find mode
> > set field theDate to field findThis
> > perform find
> >
> >
> > But when you go into find mode, all the fields go blank. Set variable
> > won't do it because apparently you can't set a field value to a
> > variable. Applescript won't do it because you can't pass variables
from
> > a Filemaker script to an Applescript, and apparently an applescript
> > inside a Filemaker script can't issue a do script to Filemaker.
>
> Change the FindThis field to a Global field rather than a normal one.
> Because they aren't part of any record, Global fields do not "go
blank"
> when entering Find mode.
>
> Or in newer versions of FileMaker you can probably also transfer the
> FindThis value to a variable before entering Find mode.
>
> Helpful Harry
> Hopefully helping harassed humans happily handle handiwork hardships ;o)
Global field is the way to do that, as Helpful Harry says. That is true
for newer versions of FileMaker as well.
--
Bill Collins
|
| Post Reply
|
| Re: find from another field |
 |
Fri, 14 Mar 2008 12:43:17 +130 |
In article <ws21-627B2A.19303413032008@newsstand.cit.cornell.edu>, Bill
Steele <ws21@cornell.edu> wrote:
> This is stupid because it seems like it ought to be easy, but
> Filemaker's rules are making it hard.
>
> I want to have a user enter a date in a field, call it findThis, then
> run a script to perform a find to find that date in another field. Call
> it theDate.
>
> In pseudocode, I tried
> enter find mode
> set field theDate to field findThis
> perform find
>
>
> But when you go into find mode, all the fields go blank. Set variable
> won't do it because apparently you can't set a field value to a
> variable. Applescript won't do it because you can't pass variables from
> a Filemaker script to an Applescript, and apparently an applescript
> inside a Filemaker script can't issue a do script to Filemaker.
Change the FindThis field to a Global field rather than a normal one.
Because they aren't part of any record, Global fields do not "go
blank"
when entering Find mode.
Or in newer versions of FileMaker you can probably also transfer the
FindThis value to a variable before entering Find mode.
Helpful Harry
|
| Post Reply
|
|
|
|
|
|
|
|
|
|