Bienvenue, Invité
Nom d'utilisateur : Mot de passe : Se souvenir de moi

SUJET : Field validation to prevent user entering a value already in the database?

Field validation to prevent user entering a value already in the database? il y a 10 mois 6 jours #101581

Hi,

I want to have a field in my survey - just a simply short text field - that won't allow the user to enter a value if it has already been provided as an answer by someone else (same field, same survey, different users). The validation should NOT be case sensitive.

The survey is asking people's suggestions for names (animal rescue charity), so if they suggest a name that has already been suggested by another survey return it should not allow them to submit the survey until they change it.

Can this be done, and if so any suggestions as to how?
L'administrateur a désactivé l'accès en écriture pour le public.

Field validation to prevent user entering a value already in the database? il y a 10 mois 4 jours #101639

  • tpartner
  • Portrait de tpartner
  • Hors ligne
  • LimeSurvey Team
  • Messages : 4191
  • Remerciements reçus 787
  • Karma: 359
You will need to make an AJAX call to a remote script that queries the database for previous answers.
Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

LimeSurvey is open-source and run entirely by volunteers so please consider donating to support the project.
L'administrateur a désactivé l'accès en écriture pour le public.
Modérateurs: ITEd
Temps de génération de la page : 0.128 secondes
Donation Image