Copying fields when in Find Mode
Author |
Message |
Maria T #1 / 8
|
 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 |
|
 |
John Weinshe #2 / 8
|
 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 |
|
 |
Tim Boot #3 / 8
|
 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 |
|
 |
Maria T #4 / 8
|
 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 |
|
 |
John Weinshe #5 / 8
|
 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
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 |
|
 |
Mason William #6 / 8
|
 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 |
|
 |
John Weinshe #7 / 8
|
 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
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 |
|
 |
Mason William #8 / 8
|
 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 |
|
|
|