Unique value check upon submit

il y a 10 ans 1 jour #537 par Dennis Fung
Unique value check upon submit a été créé par 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

Connexion ou Créer un compte pour participer à la conversation.

il y a 9 ans 11 mois #541 par David Villena
Réponse de David Villena sur le sujet 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.

Connexion ou Créer un compte pour participer à la conversation.

il y a 9 ans 11 mois #542 par Dennis Fung
Réponse de Dennis Fung sur le sujet 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

Connexion ou Créer un compte pour participer à la conversation.

Temps de génération de la page : 0.047 secondes
Propulsé par Kunena

We use cookies so that you can place orders and we can provide a better service. You can control the use of cookies at the individual browser level. If you reject cookies, you may still use our website, but your ability to use some features or areas of our website may be limited.

Learn More