Survey 2.0: Ajax queries

Hi all,

This is the ODK 2.0 guy again.

Based on the "selects" example form, I'm trying to set up Ajax queries, to get a list of countries in North America (could be whatever - just testing features out). I checked on Yahoo's developpers tools and the syntax for the tables are right, they generate the expected tables.

But when I try to open the form (either in Application Designer or on the phone), I get a "Error while accessing or saving values to the database."

The error occurs at the creation of new instance, just after pressing the button to create it.

I've attached a snapshot of the query sheet.

Please try the attached Excel file. An AJAX query is used to populate the
countries values_list for the prompt named "country".

Also, if you make changes to a form that you had previously viewed in the
Chrome browser, you may have to select "Clear Browsing Data" to ensure
that Chrome uses the latest changes.

Clarice

selectsAJAX.xlsx (12.6 KB)

··· On Sat, Sep 6, 2014 at 1:37 PM, wrote:

Hi all,

This is the ODK 2.0 guy again.

Based on the "selects" example form, I'm trying to set up Ajax queries, to
get a list of countries in North America (could be whatever - just testing
features out). I checked on Yahoo's developpers tools and the syntax for
the tables are right, they generate the expected tables.

But when I try to open the form (either in Application Designer or on the
phone), I get a "Error while accessing or saving values to the database."

The error occurs at the creation of new instance, just after pressing the
button to create it.

I've attached a snapshot of the query sheet.

--

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.