Hi 
I would like to know if we can use pulldata from two separate csv files, at once.
At the moment I have my form with two questions.
-
Select your city
Simple dropdown with list of few cities. -
Select your hospital
Dropdown with pull data from āhospitals.csvā, filtered by the City selected on the previous question.
The result is that the user sees only the hospitals for the city that he selected.
The above is working perfectly so far.
But now I would like to update the form. I would like to introduce a second layer of filtering, this time based on the signed-in User account (kobotoolbox username) and a list of the actual hospitals that the user should have access to (āuser-permissions.csvā).
The updated form should still have two questions.
-
Select your city
Simple dropdown with list of few cities. -
Select your hospital
Dropdown with pull data from āhospitals.csvā, filtered by the City selected on the previous question and further filtered by the signed-in username (via āuser-permissions.csvā).
The result is that the user sees only the hospitals for the city that he selected and that he also has access to.
Before jumping to the tech details of how this can be achieved, my main question at this point is the feasibility. Can it be done within the capabilities of xlsform and Kobotoolbox?
Our collection tool is ODK Collect for 99% of situations and sometimes we use Enketo web form.
