Shouldn't this be an ActiveLink-- onload with qualification ( 'Instance ID' = $NULL$ ) AND ($OPERATION$ = "CREATE" ) and set fields: Instance ID = $PROCESS$ @@:Application-Generate-GUID
You should create Field 179 also and place it on the form. Brien On Thu, Oct 16, 2008 at 10:02 AM, Dwayne Martin <[EMAIL PROTECTED]> wrote: > Yes, it's 255. > > Dwayne > > ---- Original message ---- > >Date: Thu, 16 Oct 2008 11:26:07 -0500 > >From: "Grooms, Frederick W" <[EMAIL PROTECTED]> > >Subject: Re: Creating subfile records from list on submit > >To: [email protected] > > > >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: [email protected] > >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: [email protected] > >> > >> ** > >> 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: [email protected] > >> 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: [email protected] > >> 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" > > > _______________________________________________________________________________ > 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"

