Ok ... Then in the design below the guide would be on the Info Form (since that has the field with the list of names) where Processing ID is not null and could do a Phase 1 Push to Subfile
Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Dwayne Martin Sent: Friday, June 12, 2009 2:24 PM To: [email protected] Subject: Re: Using filter to parse field and create subfile records 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" <[email protected]> >Subject: Re: Using filter to parse field and create subfile records >To: [email protected] > >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:[email protected]] On Behalf Of Dwayne Martin >Sent: Friday, June 12, 2009 1:42 PM >To: [email protected] >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)
