Question
Common Wealth Bank of Australia
AU
Last activity: 26 Aug 2020 8:17 EDT
Restrict user from entering duplicate values on a property.
We have a requirement to restrict users from entering duplicate values across various properties. Most of the properties belongs to a page list and of various types such as dropdowns,auto complete.
Do we have an OOTB function that restricts user from entering duplicate values for a property that resides in a page list?
Accepted Solution
Updated: 3 Feb 2016 22:45 EST
Common Wealth Bank of Australia
AU
There is no OOTB way for restricting duplicate entries on a page list.
Here are the steps I followed to fix this issue and it worked out for my requirement, the duplicates are validated successfully.
- Create a Property in the Work- Class , this property should be the same definition as the pagelist - property definition.
- Use the property in the work- class as the user entry field in the Section.
- On change of the above property call an activity, which will verify the pagelist using the IsInPageList function.
- If the property value already exists on the pagelist, then set the property-message for the work- property as "Duplicates not allowed" and Do not append the new page to the pagelist
- If the property value doesn't exist, create a new page with the property and its value then add it to the Pagelist.
Below is the screenshot of the duplicate values check and the message displayed, in my case an activity will be called on click of the "+" icon beside the input field.
Pegasystems Inc.
IN
There is no direct function to restrict duplicate values in a page-list. However, you can use IsInPageList function from Validate rule or Post activity to add validation for duplicate values.
Let us know if this helps.
Common Wealth Bank of Australia
AU
Thansk Pankaj. I have used IsinPageList to validate the property in PageList.
However, I can't validate the values of the property in pagelist data class directly. I had to create a simple property in the work- class which corresponds to the values in pagelist property.
User then need to use this simple property to insert or modify the values in the pagelist property.
This solution seems more like a workaround.
It would be great to have feature which validates duplicate entries when the user enters a value in repeating grid directly.
Accepted Solution
Updated: 3 Feb 2016 22:45 EST
Common Wealth Bank of Australia
AU
There is no OOTB way for restricting duplicate entries on a page list.
Here are the steps I followed to fix this issue and it worked out for my requirement, the duplicates are validated successfully.
- Create a Property in the Work- Class , this property should be the same definition as the pagelist - property definition.
- Use the property in the work- class as the user entry field in the Section.
- On change of the above property call an activity, which will verify the pagelist using the IsInPageList function.
- If the property value already exists on the pagelist, then set the property-message for the work- property as "Duplicates not allowed" and Do not append the new page to the pagelist
- If the property value doesn't exist, create a new page with the property and its value then add it to the Pagelist.
Below is the screenshot of the duplicate values check and the message displayed, in my case an activity will be called on click of the "+" icon beside the input field.