Pushing the values to the "Info Form" and letting it create the subfile entries
worked, and wasn't nearly as complicated as I expected.
Dwayne
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
--- Begin Message ---
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)
--- End Message ---
