Hi Lisa,
Maybe you could clear out the data in the 1:st selection if the same value
is choosen for the 2:nd etc.
This is how I would do it:
Fields:
536871001 - Work Phone
536871002 - Home Phone
536871003 - Cell Phone
536871991 - First Choise
536871992 - Second Choise
536871993 - Third Choise
Create a Fixed Character Menu:
Label/Value
Work Phone/536871001
Home Phone/536871002
Cell Phone/536871003
Create three ACTL attached to the First/Second/Third choise fields:
ACTL for First Choise Field
Execute On: Menu Choise
Action: Run Process:
Application-Copy-Field-Value 536871991 $First Choise$
Action: Set Fields: CURRENT SCREEN
Second Choise = REPLACE($Second Choise$, $First Choise$, "")
Third Choise = REPLACE($Third Choise$, $First Choise$, "")
For example selecting "Work Phone" for the 'First Choise' field will
populate it with the Field ID of the Work Phone field.
The ACTL will then immediately replace the Field ID with the value of the
Work Phone.
The second Action of the ACTL will then make sure that the Second and
Third Choise will not contain the same phone number.
Create a similar ACTL for the Second and Third choise fields.
If it seems complicated, let me know, and I will try to explain some more.
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
* RRR|Translator - Manage and automate your language translations.
Find these products, and many free tools and utilities, at http://rrr.se.
> Hmmmm, this might even be better, because another complexity I have is
> that if the user selects HOME for "Call First" I don't want HOME to be a
> selection for Call Second since it's already been selected.
>
> ANOTHER brilliant solution! Thanks so much!!
>
>
> Lisa
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky
> Sent: Monday, May 11, 2009 7:11 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: 3 Fields into one Selection Field
>
> Hi,
>
> Why not have a char-menu show the values "Work Phone", "Home Phone" and
> "Cell Phone". Then have active-links that triggers on Menu Choise that
> populates the fields with the right value.
>
> Best Regards - Misi, RRR AB, http://www.rrr.se
>
> Products from RRR Scandinavia:
> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
> * RRR|Translator - Manage and automate your language translations.
> Find these products, and many free tools and utilities, at http://rrr.se.
>
>> I'm creating an on call system and I have three fields, Work Phone,
>> Home Phone and Cell Phone. I also have three other fields called Call
>> First, Call Second, Call Third.
>>
>> I'd like to have the Numbers in the first three fields be a selection
>> on a drop down menu for each of the other three fields. Is there a
>> way to do this? (I don't think so).
>>
>> I have it set up the they can choose from a set of responses like "Work"
>> "Home" and "Cell" but I would rather have the actual phone numbers for
>> them to choose from.....
>>
>> Lisa Kemes
>> AR System Developer
>> Tyco Electronics
>> 717-810-2408 tel
>> 717-810-2124 fax
>> lisa.ke...@tycoelectronics.com
>>
>>
>>
>>
>> ______________________________________________________________________
>> _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers
>> Are"
>>
>> --
>> This message was scanned by ESVA and is believed to be clean.
>>
>>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum
> Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
