Thanks Fred. This is sort of what I had in mind with my "Parsing Form" idea. But using the "Info Form" as the "Parsing Form" simplifies it.
The reason I need the guide is that the list of names is in a column on a single field, so I have to parse each name out one at a time and process it. Dwayne ---- Original message ---- >Date: Fri, 12 Jun 2009 13:54:06 -0500 >From: "Grooms, Frederick W" <frederick.w.gro...@xo.com> >Subject: Re: Using filter to parse field and create subfile records >To: arslist@ARSLIST.ORG > >I usually do that type of thing by adding a Display Only Processing ID to the >Info Form. You then just push the Main Form ID to the Processing ID on the >Info Form. A Modify Filter on the Info Form detects that there is a >processing ID and can do a push to Subfile. No guide necessary. > >Fred > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin >Sent: Friday, June 12, 2009 1:42 PM >To: arslist@ARSLIST.ORG >Subject: Using filter to parse field and create subfile records > >Dear List, > >I have three forms: Main Form, Subfile Form and Info Form. > >On Submit, Main Form goes to Info Form to get a list of names for which it >needs to create Subfile Form records. Each Subfile Form record will have a >Name, and Main Form ID which links it to the Main Form. > >So “On Submit” a filter gets the names list, then calls a guide that parses >out the list. It retrieves each name into a temporary field, and does a “Push >Fields” to create a Subfile Form record. > >The problem is that calling the guide happens in Phase 1, but the Push Fields >happens in Phase 3. So, by the time the push fields happens, the temporary >field has been overwritten, and all Subfile records get the final name. > >I could make the push fields happen in Phase 1, but the Main Form/Entry ID >won’t have been set. It would be nice if it could wait till Phase 3 to call >the guide, but I don’t know of any way of doing that. These entries are being >created via a web template, so I can’t use Active Links. > >One possibility would be to push both the Main Form/Entry ID and the Name List >to a Parsing Form with a single record, then let the Parsing Form create the >Subfile records. > >It seems needlessly complicated, but is there a better way? > >Dwayne Martin >James Madison University > >(ARS 7.1 Patch 3, RH Linux server, Oracle 10.2 db)