I've been using Survey 2.0 a bit now and really need some of the features
such as having the database on the device so we can go back to old survey
entries and even modify them. Is there any way to create a 'sort order' for
a particular column in the list view?
As an example, if one column of data was 'status' I would like to sort by
'open' first and 'closed' last (these could be 1-Open and 2-Closed if that
would make it easier). I don't believe this feature exists in the current
tools but if it's there and I'm just missing it any tips would be
appreciated.
If you have a select prompt with a choice value, the database will store
the value, and not the translated name.
We therefore expect the sorting to be done in the javascript and not on the
SQL query, as that is where the translations are applied to these selection
values (so you can sort alphabetically in the native language -- or not, if
you always want 'yes' to appear before 'no').
Since you have direct control in Tables, this is easy to do.
Within Survey, we haven't exposed a means to sort the linked table values.
We will put that on our list of features to add.
For now, this would require a custom prompt type.
ยทยทยท
On Mon, Dec 21, 2015 at 11:16 AM, Che Geiser wrote:
Hi,
I've been using Survey 2.0 a bit now and really need some of the features
such as having the database on the device so we can go back to old survey
entries and even modify them. Is there any way to create a 'sort order' for
a particular column in the list view?
As an example, if one column of data was 'status' I would like to sort by
'open' first and 'closed' last (these could be 1-Open and 2-Closed if that
would make it easier). I don't believe this feature exists in the current
tools but if it's there and I'm just missing it any tips would be
appreciated.