Looking for a single field to contain a range

Hello Helpful Community

Working on a really long data collection form with too many (my opinion)
fields. There are multiple places in the survey that ask for current
price, max price, min price.

What I'm hoping for is a method that will accept a range in a single field
for min and max values.
I've thought of just using a text field and include instructions in the
hint ("Enter the minimum value, followed by the maximum value, separated by
a single space")

But I need to make sure the data is fully usable when it reaches the
database - can be sorted, calculated, etc.

I'm using the odk build tool, but open to suggestions. Any ideas?

Ruth

I would not put these all in one field.

Anything stored in a single field will be very difficult to pick apart
during data analysis.

And if you expect numbers, it is best to use a numeric data type so that
bad characters and invalid numbers (..10, --1, -31-, 3..32 etc.) can be
detected at the point of data collection -- rather than after-the-fact
during analysis.

You can use a group with a "field-list" appearance to display the current,
min and max questions on a single page rather than having them span across
multiple pages.

For larger surveys, you should use an Excel spreadsheet and XLSForm. It is
far more powerful and much better for managing larger surveys -- especially
when you have many relevant conditions.

··· On Mon, May 2, 2016 at 2:38 PM, Ruth Little wrote:

Hello Helpful Community

Working on a really long data collection form with too many (my opinion)
fields. There are multiple places in the survey that ask for current
price, max price, min price.

What I'm hoping for is a method that will accept a range in a single field
for min and max values.
I've thought of just using a text field and include instructions in the
hint ("Enter the minimum value, followed by the maximum value, separated by
a single space")

But I need to make sure the data is fully usable when it reaches the
database - can be sorted, calculated, etc.

I'm using the odk build tool, but open to suggestions. Any ideas?

Ruth

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

Thanks Mitch
This group has helped me so many times, usually just by searching topics
and following links
Thanks for your quick reply. I'm working on a slightly customized version
of Collect, and have requested we re-sync the code base so that I can use
the field-list appearance. Its the best solution.

Best regards,

Ruth

··· On Monday, May 2, 2016 at 8:30:01 PM UTC-4, Mitch Sundt wrote: > > I would not put these all in one field. > > Anything stored in a single field will be very difficult to pick apart > during data analysis. > > And if you expect numbers, it is best to use a numeric data type so that > bad characters and invalid numbers (..10, --1, -31-, 3..32 etc.) can be > detected at the point of data collection -- rather than after-the-fact > during analysis. > > You can use a group with a "field-list" appearance to display the current, > min and max questions on a single page rather than having them span across > multiple pages. > > For larger surveys, you should use an Excel spreadsheet and XLSForm. It > is far more powerful and much better for managing larger surveys -- > especially when you have many relevant conditions. > > > On Mon, May 2, 2016 at 2:38 PM, Ruth Little <ru...@kestrel-tech.com > wrote: > >> Hello Helpful Community >> >> Working on a really long data collection form with too many (my opinion) >> fields. There are multiple places in the survey that ask for current >> price, max price, min price. >> >> What I'm hoping for is a method that will accept a range in a single >> field for min and max values. >> I've thought of just using a text field and include instructions in the >> hint ("Enter the minimum value, followed by the maximum value, separated by >> a single space") >> >> But I need to make sure the data is fully usable when it reaches the >> database - can be sorted, calculated, etc. >> >> I'm using the odk build tool, but open to suggestions. Any ideas? >> >> Ruth >> >> -- >> -- >> Post: opend...@googlegroups.com >> Unsubscribe: opendatakit...@googlegroups.com >> Options: http://groups.google.com/group/opendatakit?hl=en >> >> --- >> You received this message because you are subscribed to the Google Groups >> "ODK Community" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to opendatakit...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Mitch Sundt > Software Engineer > University of Washington > mitche...@gmail.com >