Copying fields when in Find Mode 
Author Message
 Copying fields when in Find Mode

Heya,

When a user performs a find for a student no and it can't find it in the
db, I want a message to pop up and ask if they want to add the student to
the database, if yes I want to create a new record with the student no
copied in already..

I have the message thing working - I just can't seem to copy the studnet
no field when it is in find mode..

any suggestions???

  Maria Ttoullounge          
--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--
   Database Development Officer               ph: 02 9385 6887
   Computer Science & Engineering, UNSW      fax: 02 9385 5995
  If nothing else works, take a hot shower. - Andrew Rooney
--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--



Tue, 04 Nov 2003 12:49:36 GMT
 Copying fields when in Find Mode

(I don't know what a "no" is. I thought it a typo at first, but not 3 times,
as you are generally a careful poster).

Start your script with:

Set Error Capture[On]

and then, after you Perform Find[], look to see if no records were found:

If[Status(CurrentError)=401]

and then proceed.

To grab the name, set a global text field to the searched-for name before
the find, and then use that value for the new record.

--

John Weinshel
Datagrace
Associate Member, Filemaker Solutions Alliance
Vashon Island, WA
(206) 463-1634


..

Quote:

> Heya,

> When a user performs a find for a student no and it can't find it in the
> db, I want a message to pop up and ask if they want to add the student to
> the database, if yes I want to create a new record with the student no
> copied in already..

> I have the message thing working - I just can't seem to copy the studnet
> no field when it is in find mode..

> any suggestions???

>   Maria Ttoullounge
> --*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--
>    Database Development Officer               ph: 02 9385 6887
>    Computer Science & Engineering, UNSW      fax: 02 9385 5995
>   If nothing else works, take a hot shower. - Andrew Rooney
> --*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--



Tue, 04 Nov 2003 13:34:42 GMT
 Copying fields when in Find Mode
[posted and mailed]

Quote:

> (I don't know what a "no" is. I thought it a typo at first, but not 3 times,
> as you are generally a careful poster).

Working at a Uni not far from Maria, I think she means
"Student Number" (what we would call a SID here)

Quote:

> Start your script with:

> Set Error Capture[On]

> and then, after you Perform Find[], look to see if no records were found:

> If[Status(CurrentError)=401]

> and then proceed.

And then she wants to capture the Student Number that was searched on,
and make that the basis of a New record...

Cheers

Webko

[rest of original message]

Quote:

> To grab the name, set a global text field to the searched-for name before
> the find, and then use that value for the new record.

> --

> John Weinshel
> Datagrace
> Associate Member, Filemaker Solutions Alliance
> Vashon Island, WA
> (206) 463-1634



> ..

> > Heya,

> > When a user performs a find for a student no and it can't find it in the
> > db, I want a message to pop up and ask if they want to add the student to
> > the database, if yes I want to create a new record with the student no
> > copied in already..

> > I have the message thing working - I just can't seem to copy the studnet
> > no field when it is in find mode..

> > any suggestions???

> >   Maria Ttoullounge
> > --*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--
> >    Database Development Officer               ph: 02 9385 6887
> >    Computer Science & Engineering, UNSW      fax: 02 9385 5995
> >   If nothing else works, take a hot shower. - Andrew Rooney
> > --*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--



Tue, 04 Nov 2003 13:40:39 GMT
 Copying fields when in Find Mode

Heyas,

Thanks guys - but I actually figured it out all by lonesome - 2 seconds
after sending this email (der)..

Sorry for not being clear - yeah I meant Number :)

I did basically what you suggest - I checked for the CurrentError and then
went back to mofify find and then Set the global field and it worked
great..

thanks heaps for replying..

Muchlies appreciated :)

Me

Quote:

> [posted and mailed]


> > (I don't know what a "no" is. I thought it a typo at first, but not 3 times,
> > as you are generally a careful poster).

> Working at a Uni not far from Maria, I think she means
> "Student Number" (what we would call a SID here)

> > Start your script with:

> > Set Error Capture[On]

> > and then, after you Perform Find[], look to see if no records were found:

> > If[Status(CurrentError)=401]

> > and then proceed.

> And then she wants to capture the Student Number that was searched on,
> and make that the basis of a New record...

> Cheers

> Webko

> [rest of original message]

> > To grab the name, set a global text field to the searched-for name before
> > the find, and then use that value for the new record.

> > --

> > John Weinshel
> > Datagrace
> > Associate Member, Filemaker Solutions Alliance
> > Vashon Island, WA
> > (206) 463-1634



> > ..

> > > Heya,

> > > When a user performs a find for a student no and it can't find it in the
> > > db, I want a message to pop up and ask if they want to add the student to
> > > the database, if yes I want to create a new record with the student no
> > > copied in already..

> > > I have the message thing working - I just can't seem to copy the studnet
> > > no field when it is in find mode..

> > > any suggestions???

> > >   Maria Ttoullounge
> > > --*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--
> > >    Database Development Officer               ph: 02 9385 6887
> > >    Computer Science & Engineering, UNSW      fax: 02 9385 5995
> > >   If nothing else works, take a hot shower. - Andrew Rooney
> > > --*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--

  Maria Ttoullounge          
--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--
   Database Development Officer               ph: 02 9385 6887
   Computer Science & Engineering, UNSW      fax: 02 9385 5995
  If nothing else works, take a hot shower. - Andrew Rooney
--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--


Tue, 04 Nov 2003 14:33:24 GMT
 Copying fields when in Find Mode
Oh--it's Student Number!

It's bedtime here. We'll let you all take it from here.

John


Quote:
> [posted and mailed]


> > (I don't know what a "no" is. I thought it a typo at first, but not 3
times,
> > as you are generally a careful poster).

> Working at a Uni not far from Maria, I think she means
> "Student Number" (what we would call a SID here)

> > Start your script with:

> > Set Error Capture[On]

> > and then, after you Perform Find[], look to see if no records were
found:

> > If[Status(CurrentError)=401]

> > and then proceed.

> And then she wants to capture the Student Number that was searched on,
> and make that the basis of a New record...

> Cheers

> Webko

> [rest of original message]

> > To grab the name, set a global text field to the searched-for name
before
> > the find, and then use that value for the new record.

> > --

> > John Weinshel
> > Datagrace
> > Associate Member, Filemaker Solutions Alliance
> > Vashon Island, WA
> > (206) 463-1634




- Show quoted text -

Quote:
> > ..

> > > Heya,

> > > When a user performs a find for a student no and it can't find it in
the
> > > db, I want a message to pop up and ask if they want to add the student
to
> > > the database, if yes I want to create a new record with the student no
> > > copied in already..

> > > I have the message thing working - I just can't seem to copy the
studnet
> > > no field when it is in find mode..

> > > any suggestions???

> > >   Maria Ttoullounge
> > > --*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--
> > >    Database Development Officer               ph: 02 9385 6887
> > >    Computer Science & Engineering, UNSW      fax: 02 9385 5995
> > >   If nothing else works, take a hot shower. - Andrew Rooney
> > > --*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--



Tue, 04 Nov 2003 15:08:40 GMT
 Copying fields when in Find Mode
Where can I find a list of error codes and how to use them?

Mason

--
Mason Williams
Digital Systems Director
Hi-Rel Laboratories, Inc.


(509) 325-5800
fax   325-9508

Quote:

> Organization: The University of New South Wales
> Newsgroups: comp.databases.filemaker
> Date: Fri, 18 May 2001 16:33:24 +1000


> Subject: Re: Copying fields when in Find Mode

> Heyas,

> Thanks guys - but I actually figured it out all by lonesome - 2 seconds
> after sending this email (der)..

> Sorry for not being clear - yeah I meant Number :)

> I did basically what you suggest - I checked for the CurrentError and then
> went back to mofify find and then Set the global field and it worked
> great..

> thanks heaps for replying..

> Muchlies appreciated :)

> Me


>> [posted and mailed]


>>> (I don't know what a "no" is. I thought it a typo at first, but not 3 times,
>>> as you are generally a careful poster).

>> Working at a Uni not far from Maria, I think she means
>> "Student Number" (what we would call a SID here)

>>> Start your script with:

>>> Set Error Capture[On]

>>> and then, after you Perform Find[], look to see if no records were found:

>>> If[Status(CurrentError)=401]

>>> and then proceed.

>> And then she wants to capture the Student Number that was searched on,
>> and make that the basis of a New record...

>> Cheers

>> Webko

>> [rest of original message]

>>> To grab the name, set a global text field to the searched-for name before
>>> the find, and then use that value for the new record.

>>> --

>>> John Weinshel
>>> Datagrace
>>> Associate Member, Filemaker Solutions Alliance
>>> Vashon Island, WA
>>> (206) 463-1634



>>> ..

>>>> Heya,

>>>> When a user performs a find for a student no and it can't find it in the
>>>> db, I want a message to pop up and ask if they want to add the student to
>>>> the database, if yes I want to create a new record with the student no
>>>> copied in already..

>>>> I have the message thing working - I just can't seem to copy the studnet
>>>> no field when it is in find mode..

>>>> any suggestions???

>>>> Maria Ttoullounge
>>>> --*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--
>>>> Database Development Officer               ph: 02 9385 6887
>>>> Computer Science & Engineering, UNSW      fax: 02 9385 5995
>>>> If nothing else works, take a hot shower. - Andrew Rooney
>>>> --*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--

> Maria Ttoullounge
> --*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--
> Database Development Officer               ph: 02 9385 6887
> Computer Science & Engineering, UNSW      fax: 02 9385 5995
> If nothing else works, take a hot shower. - Andrew Rooney
> --*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--



Tue, 04 Nov 2003 23:39:36 GMT
 Copying fields when in Find Mode
Mason,

They are inconveniently and unexpectedly listed in the online help under
Status(CurrentError).

--

John Weinshel
Datagrace
Associate Member, Filemaker Solutions Alliance
Vashon Island, WA
(206) 463-1634


Quote:
> Where can I find a list of error codes and how to use them?

> Mason

> --
> Mason Williams
> Digital Systems Director
> Hi-Rel Laboratories, Inc.


> (509) 325-5800
> fax   325-9508


> > Organization: The University of New South Wales
> > Newsgroups: comp.databases.filemaker
> > Date: Fri, 18 May 2001 16:33:24 +1000


> > Subject: Re: Copying fields when in Find Mode

> > Heyas,

> > Thanks guys - but I actually figured it out all by lonesome - 2 seconds
> > after sending this email (der)..

> > Sorry for not being clear - yeah I meant Number :)

> > I did basically what you suggest - I checked for the CurrentError and
then
> > went back to mofify find and then Set the global field and it worked
> > great..

> > thanks heaps for replying..

> > Muchlies appreciated :)

> > Me


> >> [posted and mailed]


> >>> (I don't know what a "no" is. I thought it a typo at first, but not 3
times,
> >>> as you are generally a careful poster).

> >> Working at a Uni not far from Maria, I think she means
> >> "Student Number" (what we would call a SID here)

> >>> Start your script with:

> >>> Set Error Capture[On]

> >>> and then, after you Perform Find[], look to see if no records were
found:

> >>> If[Status(CurrentError)=401]

> >>> and then proceed.

> >> And then she wants to capture the Student Number that was searched on,
> >> and make that the basis of a New record...

> >> Cheers

> >> Webko

> >> [rest of original message]

> >>> To grab the name, set a global text field to the searched-for name
before
> >>> the find, and then use that value for the new record.

> >>> --

> >>> John Weinshel
> >>> Datagrace
> >>> Associate Member, Filemaker Solutions Alliance
> >>> Vashon Island, WA
> >>> (206) 463-1634




- Show quoted text -

Quote:
> >>> ..

> >>>> Heya,

> >>>> When a user performs a find for a student no and it can't find it in
the
> >>>> db, I want a message to pop up and ask if they want to add the
student to
> >>>> the database, if yes I want to create a new record with the student
no
> >>>> copied in already..

> >>>> I have the message thing working - I just can't seem to copy the
studnet
> >>>> no field when it is in find mode..

> >>>> any suggestions???

> >>>> Maria Ttoullounge
> >>>> --*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--
> >>>> Database Development Officer               ph: 02 9385 6887
> >>>> Computer Science & Engineering, UNSW      fax: 02 9385 5995
> >>>> If nothing else works, take a hot shower. - Andrew Rooney
> >>>> --*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--

> > Maria Ttoullounge
> > --*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--
> > Database Development Officer               ph: 02 9385 6887
> > Computer Science & Engineering, UNSW      fax: 02 9385 5995
> > If nothing else works, take a hot shower. - Andrew Rooney
> > --*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--



Tue, 04 Nov 2003 23:50:52 GMT
 Copying fields when in Find Mode
Thanks John, just what I needed!

Mason

Quote:

> Organization: CenturyTel.Net
> Newsgroups: comp.databases.filemaker
> Date: Fri, 18 May 2001 08:50:52 -0700
> Subject: Re: Copying fields when in Find Mode

> Mason,

> They are inconveniently and unexpectedly listed in the online help under
> Status(CurrentError).

> --

> John Weinshel
> Datagrace
> Associate Member, Filemaker Solutions Alliance
> Vashon Island, WA
> (206) 463-1634



>> Where can I find a list of error codes and how to use them?

>> Mason

>> --
>> Mason Williams
>> Digital Systems Director
>> Hi-Rel Laboratories, Inc.


>> (509) 325-5800
>> fax   325-9508


>>> Organization: The University of New South Wales
>>> Newsgroups: comp.databases.filemaker
>>> Date: Fri, 18 May 2001 16:33:24 +1000


>>> Subject: Re: Copying fields when in Find Mode

>>> Heyas,

>>> Thanks guys - but I actually figured it out all by lonesome - 2 seconds
>>> after sending this email (der)..

>>> Sorry for not being clear - yeah I meant Number :)

>>> I did basically what you suggest - I checked for the CurrentError and
> then
>>> went back to mofify find and then Set the global field and it worked
>>> great..

>>> thanks heaps for replying..

>>> Muchlies appreciated :)

>>> Me


>>>> [posted and mailed]


>>>>> (I don't know what a "no" is. I thought it a typo at first, but not 3
> times,
>>>>> as you are generally a careful poster).

>>>> Working at a Uni not far from Maria, I think she means
>>>> "Student Number" (what we would call a SID here)

>>>>> Start your script with:

>>>>> Set Error Capture[On]

>>>>> and then, after you Perform Find[], look to see if no records were
> found:

>>>>> If[Status(CurrentError)=401]

>>>>> and then proceed.

>>>> And then she wants to capture the Student Number that was searched on,
>>>> and make that the basis of a New record...

>>>> Cheers

>>>> Webko

>>>> [rest of original message]

>>>>> To grab the name, set a global text field to the searched-for name
> before
>>>>> the find, and then use that value for the new record.

>>>>> --

>>>>> John Weinshel
>>>>> Datagrace
>>>>> Associate Member, Filemaker Solutions Alliance
>>>>> Vashon Island, WA
>>>>> (206) 463-1634



>>>>> ..

>>>>>> Heya,

>>>>>> When a user performs a find for a student no and it can't find it in
> the
>>>>>> db, I want a message to pop up and ask if they want to add the
> student to
>>>>>> the database, if yes I want to create a new record with the student
> no
>>>>>> copied in already..

>>>>>> I have the message thing working - I just can't seem to copy the
> studnet
>>>>>> no field when it is in find mode..

>>>>>> any suggestions???

>>>>>> Maria Ttoullounge
>>>>>> --*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--
>>>>>> Database Development Officer               ph: 02 9385 6887
>>>>>> Computer Science & Engineering, UNSW      fax: 02 9385 5995
>>>>>> If nothing else works, take a hot shower. - Andrew Rooney
>>>>>> --*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--

>>> Maria Ttoullounge
>>> --*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--
>>> Database Development Officer               ph: 02 9385 6887
>>> Computer Science & Engineering, UNSW      fax: 02 9385 5995
>>> If nothing else works, take a hot shower. - Andrew Rooney
>>> --*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--



Wed, 05 Nov 2003 00:29:29 GMT
 
 [ 8 post ] 

 Relevant Pages 

1. A find field without going into find mode

2. Find mode - copying requests from another file

3. Read-only acces to fields, but be able to copy content in Browse mode

4. Global fields and "Enter Find" mode

5. How to get field contents in Find mode

6. Pop-up fields in the FIND mode

7. Set field and find mode

8. Find mode and set fields?

9. can the autoselect field on find mode be turned off

10. find in one field in browse mode?

11. Weird Bug: 3 Copy/Pastes from Global Fields for find script

12. Bulk copy of database in suspect mode?


 
Powered by phpBB® Forum Software