Case-sensitive coalesce field values
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-30-2019 04:41 AM
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.
- Labels:
-
Enterprise Asset Management

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-30-2019 04:44 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-30-2019 04:56 AM
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