Unique value check upon submit
Dennis Fung
New Member
Posts: 4
10 år 1 dag siden #537
af Dennis Fung
Unique value check upon submit blev oprettet af Dennis Fung
Hi,
I am new to CC. I would like to know it is possible to create a field with Unique value.
I love the "Make field required" option. Is there a way for "Make field unique'.
Thanks,
Dennis
I am new to CC. I would like to know it is possible to create a field with Unique value.
I love the "Make field required" option. Is there a way for "Make field unique'.
Thanks,
Dennis
Venligst Log på eller Opret en konto for at deltage i samtalen
David Villena
Moderator
Posts: 6
9 år 11 måneder siden #541
af David Villena
Besvaret af David Villena på emne Unique value check upon submit
Hi Dennis,
Unfortunately we don't have that option when adding a table field on Component Creator. You'll have to use a DB manager, as phpMyAdmin or similar, to add any key or index to a table.
Regards,
David.
Unfortunately we don't have that option when adding a table field on Component Creator. You'll have to use a DB manager, as phpMyAdmin or similar, to add any key or index to a table.
Regards,
David.
Venligst Log på eller Opret en konto for at deltage i samtalen
Dennis Fung
New Member
Posts: 4
9 år 11 måneder siden #542
af Dennis Fung
Besvaret af Dennis Fung på emne Unique value check upon submit
Hi,
Thanks for your confirmation. I managed to used the phpMyAdmin to change the field to unique key which avoid user to save the similar data twice.
However, shall above scenario happen, Component Creator is showing the SQL error message. Anyway I can change this error message to more user friendly message, such as "this data is in used."
Thanks,
Dennis
Thanks for your confirmation. I managed to used the phpMyAdmin to change the field to unique key which avoid user to save the similar data twice.
However, shall above scenario happen, Component Creator is showing the SQL error message. Anyway I can change this error message to more user friendly message, such as "this data is in used."
Thanks,
Dennis
Venligst Log på eller Opret en konto for at deltage i samtalen
Tid til at oprette siden: 0.048 sekunder