How to check or ensure that a text field is unique within the column.
I have text field that user need to keyin a value , id like to prevent user to enter an existing value from that column.
Something like ;
SELECT CASE WHEN count(distinct col1)= count(col1)
THEN 'column values are unique' ELSE 'column values are NOT unique' END
FROM tbl_name;
Thanks again Darren for quick respond and guidance, I was thinking that if Im just missing something basic functionality within glide. Will do make some internal cross validation for desired output.