I have data in CSV format which provides information for a set of projects in terms of which people are on those projects, their job role etc.
I have created a feedback form to be filled out at the end of each project and I want to be able to reference the data to do the following:
1. Display the people on that project as options for a question. E.g. One of the questions will be " Who are you giving feedback to?" and the options should be just the people on that project. I would be happy to do this by creating a constructed list if it's feasible.
2. Show people different content within questions based on their job role.
E.g. We have a question asking if the person has exceeded/met/not met each required competency, though the criteria required to achieve 'met' changes depending on seniority and specialism. Presently we have assigned people to a quota based on what number they are in the list of people to give feedback to (ordered from lowest position to highest), then we've used the tooltip function to provide hover-over details of what is required depending on their role. This works to an extent but requires a lot of updating whenever job roles change or someone joins/leaves, so we'd like to do it by linking to an external source as mentioned if it's possible. See below for our code within the 'Met' option on this question.
[% Begin Unverified Perl
if(GETVALUE("JobRoleQuota")<3) {return TOOLTIP("Met*", "<u>Level 1</u>
<br />-Drawing sound conclusions based on all the evidence, in line with objectives", 200,40); }
if(GETVALUE("JobRoleQuota")>2 && GETVALUE("JobRoleQuota")<6) {return TOOLTIP("Met*", "<u>Level 2</u>
<br />-Dealing with complex and inter-related information to interpret patterns and links", 200,40); }
End unverified %]
So far the only way I can see that might achieve this is to upload the CSV file to a web server then use File > Data Management > Get Data > From web server, to save it.
I've looked on the forum and Sawtooth help but I can't find any way to reference this data within questions once it is imported. So my questions are:
- Is it possible for me to use this method?
- If so, could someone advise me how to do it in terms of what function(s) to use and how to reference the database file with the imported data?
- If not, please could you advise if there is an alternative method which could achieve the same goal?
Thanks
Mike