validation on column

  • 24 December 2019
  • 3 replies
  • 15 views

i need to do validation on the column to make the below:

 

1- i need no value repetiton on the column.

 

2- and if the value already exsist show error message "This value aleary exsist".


3 replies

Badge +7

Hello  @ahmadamam ,


 


Please check the content below to help solve your issue:


 


How to validate for existing entry


https://community.k2.com/t5/K2-Blackpearl-Forum-Posts/How-to-validate-for-existing-entry/td-p/93338


 


 


Prevent Duplicate entry validation


https://community.k2.com/t5/K2-Five/Prevent-Duplicate-entry-validation/td-p/108044


 


match current logged in user to picker value


https://community.k2.com/t5/K2-Five/match-current-logged-in-user-to-picker-value/td-p/104132


 


All the best.

Hi there  @ahmadamam 


 


I did a quick Project on this and I was able to achieve this by making the column to have unique values only.


 


Have a look at the screenshot.


 


Let me know if it works for your solution.


 


Regards


Hulisani





Good day ahmadamam


 


Please also see following links for additional ideas.


“Check Duplicate entry in editable list view”: https://community.k2.com/t5/General/Check-Duplicate-entry-in-editable-list-view/td-p/107163,


“How to validate for duplicate row entry on a list view”: https://community.k2.com/t5/K2-Blackpearl-Forum-Posts/How-to-validate-for-duplicate-row-entry-on-a-list-view/td-p/99836,


“How to display distinct field row in list view when initializing”: https://community.k2.com/t5/K2-Blackpearl-Forum-Posts/How-to-display-distinct-field-row-in-list-view-when-initializing/td-p/102388.


 


Best,


Sunrise

Reply