Hi there ‌

So I want to make sure I understand -- it seems like your desired goal is that if someone has already submitted another entry for (for example) Malaysia for 1st H1 FY2015, that someone else can't come along and also submit something for Malaysia for 1st H1 FY2015 - but they could submit for India for 1st H1 FY2015, or for Malaysia for 2nd H1 FY2015. Is that correct?

Does this also mean that subsidiary is controlled in the same way? Ie, could - if Malaysia 1st H1 FY2015 Subsidiary "A" has been submitted - someone else submit Malaysia 1st H1 FY2015 Subsidiary "B"? I assume yes.

Initially you set 'Enforce Unique Values' on 'Period' column alone, not for all 3 columns. After, When you try to set 'Enforce Unique Values' on 'Region' column by the time duplicates were already present in the 'Regions' list so only it throws error. In order to set 'Enforce Unique Values' first try to delete duplicate values exists in 'HCM' list.

If you want to allow values in 'HCM' list (Unique 'Period' values for different 'Regions' and for different 'Subsidiaries') like below you want to use 'JavaScript' coding (to check the combination of values exists in 'HCM' list or not).

Exactly Rhia Wieclawek This is the scenario ..

Does Nintex have any configuration that meets this above requirement? OR

else I need to write JavaScript that has suggested?

‌ ..Thanks for your feedback ...

Rhia Wieclawek‌ Lakshmi C‌ Tomasz Poszytek‌

I am able to use the JavaScript and REST to check if a user has filled the SAME value of Region, Subsidiary and Period  in my SAVE/Submit button in the Nintex Form as follows:

However,  if user fills the values exists in the list either for Region or Subsidiary or Period, a JavaScript message should be shown as, “The Region / Subsidiary / Period value exists in the form. Please adjust the values accordingly” and form Should not submit till user has not filled the appropriate values in the form.  

I have to tap something kind of event in the alert(“Exists”) as highlighted above,  so that user is NOT able to submit the form.

Q: How can I ‘cancel’ the Submit if a user has filled a duplicate value in the list?

Any suggestions would be greatly appreciated.    

Try to put all your validation code in a function 'fnValidation()' and invoke it using a validation rule. It will make the submit will triggered only after your validation succeeded.

it could as well be achieved following way with no javascript code

- create calculated list field that concatenates values of all the fields to be unique into single value (eg.  'Malaysia_IPOH_1FY2016')

- create calculated value control on the form that will concatenate form control values just the same way

- create validation rule with formula like:

not(IsNullOrEmpty(lookup('HCM','CalcListField',CalcControl,'ID')))‍‍