Fwd: Re: Using filter to parse field and create subfile records SOLVED
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" >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 ---
Re: Using filter to parse field and create subfile records
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:arsl...@arslist.org] On Behalf Of Dwayne Martin Sent: Friday, June 12, 2009 2:24 PM To: arslist@ARSLIST.ORG 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" >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)
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" >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)
Re: Using filter to parse field and create subfile records
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)
Re: Using filter to parse field and create subfile records
You can use a Set Fields instead of Push Fields. Set Fields will run in Phase 1. On Fri, Jun 12, 2009 at 2:42 PM, Dwayne Martin wrote: > 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) > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
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)