Good Day!

It would be great if someone could shed some light on how do i go about verifying numbers against a list of numbers.
e.g.
I would want to have a validation of the employee number entered by the user against a list/database of users to ensure that it is an employee of the company and not a contractor or a partner employee staff.

Is this possible on the limesurvey? If so, how do I go about this validation in any way?

Appreciate any help in the matter.

Thanks a bunch.
M.

There is nothing built in to LimeSurvey to validate against an external database. You will need to make an AJAX call to a remote file that queries the external DB.

I would want to verify against an excel sheet or csv file or any flat file which would be present on the same machine? Is this still possible with the build in features of limesurvey? If not, could you please direct me as to how would i be able to accomplish it.

Thanks in Advance,
M.

Although for a different purpose, some of these workarounds may give you insight on how to access a remote CSV file via JavaScript - www.limesurvey.org/manual/Workarounds:_M...wers_for_text_inputs

Thanks Tpartner....


==================================
Environment:
Limesurvey Version 2.50+ Build 160718
==================================

Well, I am currently working on the an Arabic survey and on input of the variable as specified "{INSERTANS:877769X101X886}" according to the link provided:

<script type="text/javascript" charset="utf-8">
alert("{INSERTANS:877769X101X886}");
</script>

I run into the following output string:

<span id='LEMtailor_Q_886_43'>23412342134</span>

rather than it giving me the following output string:

23412342134

as specified in the document. Any idea what I may be doing wrong. I tried using "{INSERTANS:{SGQ}}" again to no avail...

Any help would great....

Expression Manager wraps piped text in <span> elements. You should be able to clean it up something like this (untested):