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: arslist@ARSLIST.ORG
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"
