It would probably work, but if it was me I would rather go with Carey's approach. If they change their mind down the line and say, "Well, I love it but you know it would be cool if I could do it for all in this division except this one..." Carey's way they can just deselect the ones they don't want to create a record for.
With Carey's way you could also use an external qualification to drive the table results, so you can have multiple drop downs ie. State, Center, Division, etc. each time they select a dropdown it will change the results in the table without having to design custom SQL queries. Just my 2 cents :) Dylan -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent: Wednesday, September 26, 2007 12:39 PM To: [email protected] Subject: Re: Creation of mlutiple records Thanks Carey, Would something like this work? I was thinking of maybe using Direct SQL to do a Select and then an Insert. One of the questions he asked was could we allow the users to select like a division as well as a state or a state and a center. I figured if I set a flag on each field to make sure there was a value there, and then run Direct SQL to select the corresponding records and do the insert, I could give them what I'm pretty sure is exactly they want. The only thing I'm not sure of is making sure I get the Change Request ID as well as the results set from the Bill Area form. Is this overly complicated or would something like this work too? Thanks, Michael A. McManus, SSgt, USAF Remedy Developer HQ 754 ELSG/DOMH DSN: 596-6478 / Comm: 334-416-6478 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Wednesday, September 26, 2007 9:29 AM To: [email protected] Subject: Re: Creation of mlutiple records Michael, Just my two cents.... I would give the users a but that says... "add multiple billing areas from this state" and have it open another dialog. That dialog would have a table field and the user would be able to "Select all" or select a sub set of the records in the table field. Then a button that says "Create records for selected Billing Areas" that loops over the selected records in the table and closes the dialog. That allows the user to see that there are really 1500 Billing Areas in that State before you go off and create 1500 records. But it still allows them to do just that when it is really needed too. It also gives you a shot at telling the user things like... "You selected more than 50... are you really sure? (Note this will take a while so be patient after you say 'Yes'.)" But in general table looping is the way I would go with such an activity. HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On 9/26/07, McManus Michael A SSgt HQ 754 ELSG/DOMH <[EMAIL PROTECTED]> wrote: > ** > Listers, > > I have a requirement to allow users to add multiple > billing areas to a change request. Currently, they click a button > called Add Billing Area, which opens a dialog called Change Bill Area. > The user selects a billing area id from a character field with a menu > attached which fires a push fields that creates a record in the Change Bill Area form. > I've added the ability for the user to select via billing area name, > state, center and division in addition to ID but what I'd like to do, > is allow users to select a state (or division, etc.) from that drop > down, and then create a request for every billing area in that state. > I'm sure I'll need to loop through that results set somehow, but I'm > unfamiliar with that type of workflow in Remedy. Any help is greatly appreciated. > > > > ARS 6.3, SQL 2K, and Server 2000 > > > > Thanks much, > > > > Michael A. McManus, SSgt, USAF > > Remedy Developer > > HQ 754 ELSG/DOMH > > DSN: 596-6478 / Comm: 334-416-6478 ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" __________ NOD32 2553 (20070926) Information __________ This message was checked by NOD32 antivirus system. http://www.eset.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
