hi,
I have this table kish. The column contains the rank of the household and
the line number of household members. for example, if you enter 4 for the
rank of household and 3 as the number of members contained in this
household, SO ODK must return 1, the number which is at the intersection
of the column 4 and the line 3. Could you tell me how can i implement it
this in ODK.
Thanks a lot
I think what would be easiest is to put this table into an external
file and use the data preloading function described at
http://opendatakit.org/help/form-design/data-preloading/.
The key would be the number of members and the columns would be rank.
Yaw
On Wed, Jul 9, 2014 at 5:04 PM, Legarraudien pagarraud1@gmail.com wrote:
hi,
I have this table kish. The column contains the rank of the household and
the line number of household members. for example, if you enter 4 for the
rank of household and 3 as the number of members contained in this
household, SO ODK must return 1, the number which is at the intersection of
the column 4 and the line 3. Could you tell me how can i implement it this
in ODK.
Thanks a lot--
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.
Someone implementing a Kish grid pointed to this thread. They are using an entirely repeating pattern across rows, unlike the example shown above. For the example above, a lookup is necessary. For a regularly repeating pattern such as:
The following expression should get the desired result:
if(${rank} mod ${member_count} = 0, ${member_count}, ${rank} mod ${member_count})
This uses the mod operator which gives the remainder of division.