This release includes a number of significant new features
If you select menu then history you can see a list of all survey instances that have been submitted to the server or deleted.
The view is updated after you perform a refresh to synchronise with the server. In addition you can also delete an instance from the main screen by doing a long press on it. You will then select “reject” and will have to provide a reason.
Mapbox Tiles for use as offline maps
Both vector and raster tiles are supported. A while ago offline map tiles were supported. However this was when the maps used the google maps API. ODKCollect have been progressively migrating to the MapBox API which supports tiles in a different format. However now the feature is back. Sample tiles are available here: https://github.com/klokantech/vector-tiles-sample just download them and copy the mbtiles file onto the phone’s sdcard under /sdcard/fieldTask/layers.
If you have a date question and want to use the Persian calendar specify an appearance of persian.
Organisations using Smap are increasingly managing work using data records that correspond to someone or something in the real world. This might be the maintenance of equipment, or the delivery of services such as education to a student, training to a teacher, health services to a patient or climate change resilience improvements to a community.
These applications represent an active form of Case Management where information is recorded against a case over time and used to guide the delivery of services. In the August release we have added a number of features to support this, including:
Find and view the record of data that represents a case
Update that data in a controlled way with logs and security
Request a task be sent via email, or to a mobile phone app, requesting an action be taken and data be collected
View all changes made to a case
View the status of all tasks
Send reminders if a task has not been completed via email or SMS or to fieldTask users
These activities can now be managed using a “Console” which allows a user to manage cases using the same forms that are used by the field workforce.
What is a Record?
In the Smap universe every time you submit results from a survey you create or update a record. You can group surveys so that they all share the same records. This allows you to, for example, create a record with survey A and then update it with survey B. Each case can be recorded in one or more of these records and so this feature is what provides a lot of the power of Smap as a case management tool.
When you select surveys on the records page, if they are in the same group then you will see the same records for each of them although the columns that you see in the table will be determined by the columns in the survey.
Actually this is a slight simplification in that you can also use security roles to restrict the records shown on a per form per user basis so not all forms in a group need show the same records to the same users.
Replacement of WebForms with a Console module
Here is some history to explain where the console came from. In the old Web Forms module, as well as having a list of forms you could launch in you browser, there were menu options for Browse Results and Managed Forms. Browse results was going to be the new analysis page but we never managed to make it better than the old Analysis page so it just lurked in Web Forms not being particularly useful. Managed Forms was similar to Browse results but it allowed you to attach another form and edit the submitted data using that form. This has been used in applications such as Feedback and Accountability.
Now Browse Results and Managed Forms have been merged and renamed to “Records”. The WebForms module itself has been renamed to “Console”. It still includes the page to launch forms and respond to tasks using your browser but it now has a focus on individual data records rather than analysis of all the collected data.
A scalable records page
By scalable we mean that the console can handle hundreds of thousands of records. Previously the browse results page had problems when customers had this many records as it tried to load all the data into the browser first and then filter.
If you look at the records page you will see that it is in two parts. The top half consists of filters that are applied on the database before data is retrieved. Underneath are the table view, map view and calendar view. For these the filters are applied in the browser. Hence you can select the survey, the from date, to date, an advanced filter and max records and a new query will be made on the database to get that data. The first time you open a survey the limit will be set to 1,000 so that you don’t have to wait to get the data. You can then change the limit of you need to see more, or less, records.
Modifying a Case
When managing a case you will need to be able to make changes to the data directly from the console. The first step is to lock a case for editing. Once you have done that it is assigned to you and other people cannot edit the same record, although an administrator could re-assign the case to someone else. In the diagram below the “Unassigned Records” switch is selected so that cases not assigned to anyone can be selected. An unassigned record has then been selected by clicking on it. The button “Lock for Editing” can then be clicked.
Once you have locked a record the edit button will be shown. The questions you can change are determined by the Oversight survey that you have selected as well as any security roles that have been applied. These questions are shown on the right hand side of the page and are labelled as “Management Data”. Any remaining questions in the main survey that are not in the oversight survey are shown as read only on the left hand side for your reference.
In the above image there are 2 questions in the management form, a geopoint question and a text question labelled as “comment”. You can select a new location, change the comment and then click “Save”. The existing data for the record will be updated.
Reviewing changes to a Case
If you click on the events tab you can view all changes made as well as see all task and reminders that have been created for the record. You can also create new tasks that can be assigned to your field work force to update the case or send a reminder.
In the above diagram changes have been made to the record using the survey called “Map”. The location question and questions “q2” and “hi” were changed. For location questions; points, lines, areas the old location is shown in blue and the new location in red.
A task has also been created on this record but it has not yet been assigned to anyone.
There is a lot more functionality in this upcoming release that I will talkcover once the software is deployed to the servers. Hopefully this post will give you some ideas for the types of case management applications you will be able to create from about the middle of August.
There is a new version of FieldTask available in the google play store. This has some cool new features.
Relevance and Constraint work inside a page
This long awaited feature has been added by the ODKCollect community. It means that you can now put multiple questions on one page of the screen using the “field-list” appearance and make some of the questions visible depending on answers to other questions on the same page.
A simple example is a text question for “other”. This can now appear automatically under the select question when the “other” choice is selected.
Track changes to answers while a survey is being completed
This takes auditing to a whole new level. Changes are written to a csv file.
In the example above the user initially entered a value of “Tom” as the answer to question 1. They then went back and changed that value to “Neil”. Note the Duration column. This was added by taking the difference between the start (in milli seconds) and the finish and then dividing by 1000.
Select the URL for the survey for which you want the log file
Select the URL labeled “audit_log” for the submission that you want to review
You should change the above URL to point to your Smap server and you can log in with your username and password to see your surveys. If you just want to see the demo csv file then log on to the sg server using api:api
Added reminders for tasks. These reminders are specified as a type of “notification”. You can set the time after a task has been accepted for a reminder email or SMS to be sent to the user who accepted it, or to someone else. So for example you could have a reminder after 2 days for the assigned user to “Get on with it!”. You could also set another reminder that if the task is not completed within 5 days a reminder is sent to a supervisor that includes a link to the task so that the supervisor can complete it. You can specify the reminder interval in hours or minutes as well as days, I’d like to think that “minutes” is there mainly so I can demonstrate the feature, however it may prove useful in fast moving problem domains.
Allow URLs of images to be set as dynamic defaults for image questions. For example you could use cascading selects to select a schematic from thousands of available images. This schematic can then be annotated by the user and submitted with the completed form. This feature is now available in Webforms and in fieldTask 6.21. Here is an example form that gets the images from Wikipedia. Commonly however you will want to retrieve the images from the same Smap server that you are using to complete the form. By getting the images from the same server you won’t be blocked by CORS. Wikipedia does not enforce CORS but sites that require authentication, such as other Smap servers, would.
Added dynamic defaults to webforms. A dynamic default is specified in the “calculation” attribute of a question. Hence you can set the initial answer to a question based on the answer to a preceding question. Allowing images to be used as dynamic default values as described above is a special case of this new feature. This feature is already available in fieldTask.
Customise the appearance of the web site for an organisation by setting the colour of the menu bars and by specifying the main picture on the home page. You can specify these themes in the Organisations tab of the user management page.
Add support for “track changes”. This is a feature from the ODK community that audits every change to a question answer while a form is being completed. So it adds to the existing audit capability that allows you to record the total time spent in each question and the GPS coordinates when it was finally answered. You can enable “track changes” in the settings dialog of the online editor. However you will need the soon to be released fieldTask 6.21 in order to use it.
The big change in this release is the addition of GPS coordinates to named locations.
When you add or edit a task you can set the GPS coordinates, an NFC identifier or both to specify where the task should take place. This is what we call an anonymous location since you are not using a “Named Location”.
However you can now also enter the name of a “location” that has the NFC UID and/or the GPS coordinates pre-defined. To do this Select the group name first and then the location name. (This change addresses issue #468).
Named locations are shown in the “Shared Resources” page. Select the Admin module then “Shared Resources” , then select the “Locations” tab to view them. Click on the “Download” button to get the current locations in an excel file, or an empty template if you have not specified any locations.
Loading Named Locations from an Excel file
Locations are organised into groups and each group is shown in a separate tab of the excel file. Create new tabs giving each one a unique group name. Then for each group create locations. You can specify:
UID: The identifier of an NFC chip at the location
name: The name of the location
lat: The latitude in GPS coordinates
lon: The longitude
The location name must be unique within the group. When the file is ready select “Add Files” and then “Upload”.
Updating a location when editing a task
After selecting a location you may adjust the GPS coordinates or change the NFC UID. You then have the option of:
Continuing with an anonymous location
Updating the location with the new coordinates / NFC UIC
Saving a new named location
Added “auto” as a parameter option in the online editor to automatically start camera, barcodes and NFC reader when the user swipes to that question. The auto start is only applied when swiping forwards, there is not already a value recorded for the question and the question is the first one on the page. (This update implements issue #475)
Drastically reduced the memory required when importing data from an excel spreadsheet. This was tested importing 80,000 rows each with 500 columns without any problem. This new version is also much faster than the previous import.
Its all about Tasks in this release. Lots of great new features.
Auto start of external applications in fieldTask. (requires fieldTask 6.10). An external application will be automatically launched if you set the parameter “auto=yes”.
Geofencing for tasks. A “Show Distance” can be set on a task so that it will only be shown to the user if they are within that distance of the task location. In addition a “download distance” can be set on a task group. Tasks in that group will only be downloaded when the user is closer that that distance from the average center of all the tasks in the task group.
Set initial data for a task.
This is for tasks that have been downloaded to fieldTask. The app will show and hide them as the user moves in and out of the geofence.
There are two geofence capabilities added in this release.
“Show Distance”. The tasks are downloaded to the phone but only shown to the user when they are close enough to the task location. This distance is set per task.
“Download Distance”. Tasks are only downloaded to the device when the user is close enough. This distance is set on a task group.
Set Initial Data for a Task
Amazingly this was not previously possible. You could set a task to update an existing record however now you can also create a brand new submission but initialise it with some arbitrary data. When creating tasks from existing data you can select one of the following 3 options:
No initial data means that your form will open empty. “Pre-populate form with existing data” is the new option, the data will be taken from the existing record and mapped to compatible questions in the new form that you want completed and the original data will not be updated. The third choice “Update Existing Results” continues to allow you to update an existing record. The data for that record will be shown in the form that you are going to complete.
You can’t yet add initial data when you add an ad-hoc task via the user interface. However you can do this via the new tasks API (see below).
Add an audit API to return geoJson data on location and duration of each question asked in the survey
Add the user identifier as a valid value for use in an advanced filter
Record the PDF template for a survey in the surveys change log so that previous versions can be referenced
Add ability to delete meta questions in the online editor as well as add the pdf_no appearance to them so that they are not included in PDF exports
Including data from linked surveys in PDFs
Smap allows you to combine Surveys to make “Systems“, where data in one survey can be linked to data in another. For example a survey recording the delivery of aid may include the identifier of the beneficiary. You can analyse this data taking account of the links between them by extracting the data into external tools like Power BI. However inside Smap itself we haven’t provided any capabilities to join data from different surveys during analysis. This new feature is the first step on that path.
When you create a PDF containing data from a single survey submission you can optionally specify:
Include reference data
Only include data from surveys launched from the current survey
If you include the second option you don’t need to specify a key question but only data collected by launching the child survey on the phone will be included.
Password Policy settings for FieldTask
FieldTask Version 6.02 has a logon page. By default this is shown when the app is first run so the user can set the server, username and password without having to go to the settings menu. After successful logon it is not shown again. This corresponds to the default password policy of “Never show logon page”. In the tab for fieldTask options on the usermanagement page you can also specify a policy of “Always show logon page” which will require the user to enter their password every time they start the app; and “Periodically show logon page” which will require the user to enter their password again a specified number of days after their last successful logon.
Large API exports were causing out of memory errors. These data exports using /api/v1/data are now streamed so there should not be any size limits.
Lets face it, collecting data can get a bit dull and there is often not an obvious connection between the data collected and any subsequent actions. However it is possible to take a more active approach to monitoring, to move beyond mobile data collection as a passive tool and start using it to have an immediate impact while still getting the data you need to assess performance.
Monitoring is an excellent application for mobile data collection tools which make it more timely, affordable and effective. One way of collecting monitoring data is to embed the data collection into a delivery process so that when you do something, you also document what you have done. In other words monitoring your own actions. This can be a useful alternative to more conventional longitudinal surveys.
You can put the emphasis on data collection but depending on the answers you are getting the tool can also prompt you to provide immediate advice to the interviewee or to deliver a service and then record that service delivery. This approach can be called “Push Surveys” as you are doing a survey but are happy to change the state of what you are surveying.
Alternatively you may be focussed mainly on service delivery but incidentally recording data during that process. For this you need a “Management System” such as Asset Management, Accountability or a Patient Management System.
Smap has the following capabilities to support both “Push Survey” and “Management System” approaches to monitoring.
Push survey Capabilities
Expert Systems. You can use “relevance” in forms to create expert rules that can identify advice or further action to take.
Artificial Intelligence. From fieldTask you can call AI services in the cloud to answer more complex questions that might also involve the analysis of images, video or audio in order to identify required actions. (Not available offline)
Graphs. FieldTask can present collected information in graphs to help in providing immediate feedback to an interviewee or community. (Works offline)
Reference data. Lookup data previously collected in the same survey or other surveys and use that in identifying the action or feedback to provide. (Works offline)
Keys. A unique “key” can be associated with each survey. This key could be a beneficiary id or a part number for a piece of equipment. Along with the key you can specify a “key policy” such as “merge”. If you have a key policy of “merge” and you submit a survey with the same key as an existing record then the new data will be merged with the existing record.
Reference Data. These enable an identifier from another survey such as a beneficiary id to be added when completing a different survey, perhaps one that records delivery of aid.
Managed Forms. Allow you to review and modify data collected from the field. One use of this is to transcribe audio recordings into text.
Grouped Forms. By grouping forms which share the same data you can present multiple views of a single data set.
Launch a form from within a survey. When completing a survey in the field it may be necessary to launch another Form and link the data between these forms.
Tasks. Assign a task to a user.
Notifications. Automatically email PDFs and tasks to people.
While completing a survey on a phone or tablet with fieldTask the user can start another survey / form and then when they have finished that they are returned to their original survey. The data collected by these two surveys are linked for analysis.
Two new question types have been added; “parent_form”, “child_form”. The difference between these is in how the collected data is linked.
Launching a Parent Form
There might be many records in a form that point to a parent form. For example you may be reporting problems on pieces of equipment. So you open the problem report form and select the equipment identifier, then record the problems for that one piece of equipment. However if equipment has not already been added to the system then you can launch a parent form, from within your problem form, to create an entry for that equipment. You can then continue filling in the problem report knowing that it will be linked to the new piece of equipment for analysis. All of this works offline.
In the above example the key Question would hold the identifier for the piece of equipment.
Launching a child form
There might be many records in the child form that point to the first form . For example you may be registering students for school attendance and you encounter a student for which there is no record. You can then launch a child form to create an entry for that student who will be linked to the school.
In the above example the key question would hold the identifier for the school.
The online editor now greatly simplifies the setting of parameters and appearance. You can select these from options presented on the screen rather than having to type them in. This is particularly useful for cases like the search appearance where you can now select from a list of csv files or forms to reference and then select the columns from those that you want to include. No more awkward looking up of form identifiers! This is also useful when adding a new parent_form or child_form question type as you can simply select the form you want to launch using the parameters dialog.
Added support for range widgets in webforms
Allow backward navigation in a form to be prevented by using a setting on the server.
User activity views have been added to the dashboard. If you open a table view or a map view then you can specify the subject as “User Activity”. Then select a user to show their activity.
The source of data, such as the form name that was used to collect it, or the file name that was imported is now shown in the table view on the dashboard.
Added display_name to choices. Display names have been available for questions for a while. These allow you to specify a name to replace the question name in reports but one that is not constrained by the limitations of the odk question name. For example you can include spaces. These are now available for choices. This is particularly useful for select_multiple questions as now you can replace default column headers such as “Question Name – choice_name” with something more meaningful such as “The selected choice 10 !!!!”.
Add the ability to restrict activity within an organisation. For example you can prevent the submitting of any new survey results, access to the data api or sending of notifications. If any change is made to these settings the organisation owner will be notified by email.
Added some initial customisation of the webform page appearance. For example you can now set background colours for some of the components.
Add a new data processing option to reports. Transformation of data from Long to Wide. hence if you have done a longitudinal survey you can get a report on things within that survey with one row per thing and all the time series data converted to additional columns.
Added some settings data into a settings workbook when creating an excel report. This now shows the timezone used in the report as well as the start and end time of any date filtering applied.
Replacing a select_one question with a select_multiple question after data collection had started caused further submissions to the form to fail. Now fixed.
Multiple bug fixes in webforms. Images in choices now work again as does the selection of drop down select questions.