**
That would work if you have that as a required field, but if you can allow null values if you do not have a value to feed in, it would fail. Then you would need workflow to exclude entries that have a null, and set some temp field with the entry id of an exsiting entry, check the entry id and if not null display an error saying the value already exists..
 
Cheers
 
Joe D'Souza
Remedy Developer / Consultant,
BearingPoint,
Virginia.


----- Original Message ----
From: "Nall, Roger" <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Tuesday, August 22, 2006 10:59:13 AM
Subject: Re: help, help, help

**

Sara,

 

To enforce unique values in a field I would suggest a unique index. As to a ‘Request ID’ type field you may need some sort of a stored procedure for that.

 

HTH,

 

Roger A. Nall

OSSNMS Sr. Remedy Administrator/Developer

T-Mobile USA

Desk: 973-644-3963

Cell: 973-652-6723

FAX: 973-267-6628

sf49fanv     AIM IM

RogerNall   Yahoo IM

 


From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG ] On Behalf Of sara abate
Sent: Tuesday, August 22, 2006 10:46 AM
To: arslist@ARSLIST.ORG
Subject: help, help, help

 

** I am a new remedy developer and I need help on two of the following things,
  
  1.  I want a field to have unique value.  How can I restrict the
field from having duplicate values?  In other words, Is there any way I can block if the current value entered is already in the database?
   
  2.  I want to create an auto generated field.  Anytime a ticket is
submitted, the field should be populated automaticlly in increments.  In
other word, I want a 'Request ID' kind of field on the form.
  
  Anybody can help me with this please email me at [EMAIL PROTECTED]
I will appreciate it.
  Thanks!
  
  Sara

 


Do you Yahoo!?
Next-gen email? Have it all with the all-new Yahoo! Mail. __20060125_______________________This posting was submitted with HTML in it___

__20060125_______________________This posting was submitted with HTML in it___

__20060125_______________________This posting was submitted with HTML in it___

Reply via email to