Just off hand ... Is your Temp ID field at least 38 characters big? -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Thursday, October 16, 2008 11:21 AM To: arslist@ARSLIST.ORG Subject: Re: Creating subfile records from list on submit
Thank you, Joe and Frederick ! I am trying the "Application-Generate-GUID" method. My Filter does a "Set Fields" that sets a "Temp ID" field to: $PROCESS$ Application-Generate-GUID I get, "**** Error while performing filter action: Error 38" I couldn't find anything about Error 38 in the BMC Knowledge Base. I tried putting quotes around "Application-Generate-GUID" even tho I knew that was wrong, but got the same error. Any idea what I am doing wrong? Dwayne ---- Original message ---- >Date: Wed, 15 Oct 2008 14:22:45 -0700 >From: Joe DeSouza <[EMAIL PROTECTED]> >Subject: Re: Creating subfile records from list on submit >To: arslist@ARSLIST.ORG > > ** > You could also have the system generate a GUID on > the parent record and store it in a hidden field > that you could use to bind the child records to the > parent record by pushing the GUID instead of the > EntryID.. Create the GUID on opening the parent > record if the GUID field is null, and use this. > > Use Application-Generate-GUID in a Set Fields Run > process to generate it. > > Joe > ----- Original Message ---- > From: "Grooms, Frederick W" > <[EMAIL PROTECTED]> > To: arslist@ARSLIST.ORG > Sent: Wednesday, October 15, 2008 4:49:33 PM > Subject: Re: Creating subfile records from list on > submit > > We put a Display Only "Processing ID" field on the > 3rd form and have the main form push to the 3rd form > (Standard Phase 2 action). All workflow on the 3rd > form takes into account if Processing ID is Null or > not. i.e. Data validation takes place if Processing > ID = $NULL$. If Processing ID != $NULL$ then it > pushes data to the subform (again standard Phase 2 > action). > > Just to keep things clear we rename Modified Date > and Last Modified By to Touched Date and Touched By > and have our own Modified Date and Last Modified By > fields that are filled in by a filter when > Processing ID = $NULL$. > > Fred > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne > Martin > Sent: Wednesday, October 15, 2008 3:44 PM > To: arslist@ARSLIST.ORG > Subject: Creating subfile records from list on > submit > > Dear List, > > I have a main form and a subfile form. The subfile > has two (actually more, but this is just for > illustration) fields, a Parent ID field that > contains the Entry ID of the main form, and an Info > field. On submission of the main form, I use a > filter to retrieve a list from a third form, then > process that list to create subfile entries. Eg, it > would retrieve a list like: > > abcde > hijkl > mnopq > > Then if the main form Request ID is 87 it should > produce subfile entries > of: > > Parent ID: 87 > Info: abdde > > Parent ID: 87 > Info: hijkl > > Parent ID: 87 > Info: mnopq. > > So, on submission of the main form, filters process > the list, and move each entry on the list into a > temp field and do a Push Field to create the subfile > record. > > Here's the problem. Push Fields get deferred to > phase 2, and by that time the temp field is > overwritten so no subfile records get created. If I > add `! to the end if the filter name, the filter > runs in phase 1, but the main form Entry ID hasn't > been created yet. > > The ideal would be to run the workflow in an Active > Link "After Submit," but there are times when the > main form itself is created via Push Field action, > so the Active Links won't run. > > Any suggestions? > > (ARS 7.1, patch 3, RH Linux server, Oracle 10.2 db) > > Dwayne Martin > James Madison University > __Platinum Sponsor: www.rmsportal.com ARSlist: > "Where the Answers Are" html___ ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"