If memory serves me correctly (and it's been a few years since I created a TAF to hit FM Pro), you can reference the result by using the tag <@ACTIONRESULT xxx 1> where 'xxx' is equal to the name of the action in your TAF. Here is what the online documentation says for the <@ACTIONRESULT ...> tag:
"Note: For FileMaker Pro data sources (Mac OS), Insert actions return a single item of data--the record ID of the newly created record--that may be accessed by <@ACTIONRESULT InsertActionName 1>." You can use the <@ACTIONRESULT ...> tag in any action after your insert action as long as it is in the same call to the TAF. Once the results are returned to the browser (i.e. by hitting a RETURN action), the value of <@ACTIONRESULTS ...> is no longer available. If you need to keep it, assign it to a variable. If your 'job id' value is not the same as the record ID, you'll need to add a SEARCH action below the insert. Use the <@ACTIONRESULT ...> tag as the value in the search criteria (with record id as the field to search on) and have 'job id' be one of the fields returned by the search. Hope this helps, Steve Smith Skadt Information Solutions Office: (519) 624-4388 GTA: (416) 606-3885 Fax: (519) 624-3353 Cell: (416) 606-3885 Email: [EMAIL PROTECTED] Web: http://www.skadt.com > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Paul Hart > Sent: October 9, 2002 3:53 AM > To: Multiple recipients of list witango-talk > Subject: Witango-Talk: ID field in response to new record > > > Hi, I'm new to the list and wondered if anyone can help me with what I > think is quite a trivial problem - I just can't seem to get it to work. > > I'm using witango on a Mac server linked to a filemaker database which is > used as a job booking system. What I would like to do is provide a job ID > number back to the person booking the job when they add a new record, in > the response page. The manual says that witango can do this and will get > the data back from the newly created record, but goes on to say that the > primary key columns must appear in the Columns list of the > builder. This is > where I get a bit stuck. I have included what I think is the > correct field > name in the response html, but get nothing. I have tried to drag the > special record ID field into the Columns of the record building > and I get a > message to say that it can't be put in the the list as it's a > special field. > > Does anyone know what I'm doing wrong ? > > Regards Paul. > > --------------------------------------------------------------- > Paul Hart > IT Manager > Medical Research Council > Laboratory of Molecular Biology > Hills Road, Cambridge, CB2 2QH. England. > > Tel: +44 (0)1223 245133/DDI 402394 > Mobile: 07867 500598 > Fax: +44 (0)1223 213556 > > email: [EMAIL PROTECTED] > http://www2.mrc-lmb.cam.ac.uk > http://www2.mrc-lmb.cam.ac.uk/personal/pdh/Go_For_it.html > --------------------------------------------------------------- > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
