Case-sensitive coalesce field values

shallumittal
Tera Contributor

Hi,

We have a requirement to implement case sensitive value for field. For example if the existing record has value "ABCD"  and another user insert the value of same field as "abcd" or "ABcd", then the system should accept the value. But if we will again try to enter the value "ABCD" then we should get error message.

Note: This requirement is to insert or update record manually. Not valid for transfor map

Any suggestion would be appreciated.

2 REPLIES 2

Jaspal Singh
Mega Patron
Mega Patron

Hi Shallu,

 

There exists a field called Coalesce Case Sensitive in Field Form map that can be used. I recommend you to go through link for the same.

 

Thanks,

Jaspal Singh

 

Hit Helpful or Correct on the impact of response.

shallumittal
Tera Contributor

Thanks for your reply.

As I mentioned, we are not going to use transform map.

We need case sensitive value check before insert/update operation on form.  For example:

If I am creating a new record and entered the field value as "abcd" then system should accept the value even "ABCD" value existing in some record.

However, if I again try to insert same value "abcd" then I should get the error i.e."Value already exist" - case sensitive value

 

Thanks