Q: How to create Unique Index by combing two or more form field together ?

Q: How to create Unique Index by combing two or more form field together ?

  1. I know ZC only allows only one field in making unique index. Through deluge script, you can combine two or more fields in submit action to restrict dupplication. I know and did the same, but it worked partially for me. 
  2. My issue is - as ZC consider lower and upper case separately, it allows duplicate entry when the data entered differently mixing lower and upper case though spelling remains the same.
  3. I tried upper  function in my deluge script, still it didn't worked properly. It only works when data is entered exactly the same way as entered in the previous record.
  4. But I want my deluge script would fire it when there is any duplication. For example; My Field A, date vale is "MAN", and Field B data value is "Shirt". I acn enter shirt as "SHirt', or ShiRt", but it MUST be treated as unique value.
  5. My partial deluge script on submit action is like:
if (Sub_Category[(Main_Category == input.Main_Category && Sub_Category == input.Sub_Category)].count()  >  0) {
  ... all my relevant codes go here..
}
 where; 
input.Main_Category - is a lookup value, and input.Sub_Category - a string value entered as ShiRT or SHIrt".
I tried by putting uppercase function as upper(Sub_Category) == upper(input.Sub_Category). It gives syntax error with upper(Sub_Category).

Can someone give me some insight how to work it out.

Regards,

Mollah Ibrahim
Oscillosoft Pty Ltd
M: +61 430 029 925