Can calculations function within Repeats?

Dears,

Do we have a solution for this issue, because I face the same problem and I
want to know if it's possible with ODK Collect now.

I use the index-repeat function with position(..) inside my form designed
with excel but without success.

I try the same example designed here, but it's not working also.

Thanks
Matayo

··· Le jeudi 6 juin 2013 16:09:23 UTC+2, abta...@gmail.com a écrit : > > I'm trying to do some simple addition and multiplication calculations > within a Repeat group. The calculations function for the first entry, but > fails for every additional entry. Can calculations function within repeats > beyond the first entry? And if they can, how do you configure the > calculation? > > Thanks, > Will >

Dear Matayo,

Calculations do work within repeat groups, and if even the sample form
doesn't work then perhaps you're running a version of Collect that doesn't
support indexed-repeat()? Are you running the latest version?

Also, the more detail you give, the more helpful people can be. For
example, you say that it's not working -- but how, exactly, is it not
working? And I'm assuming by "example" that you mean sample, but what
example do you mean? Be as detailed as you can and then you'll get the best
help. For example, if there is an error message, the exact details about
that error will be more helpful than just saying that there is an error
message. The people who help out in these forums thrive on details.

Thanks,

Chris

··· On Fri, Jul 18, 2014 at 3:46 AM, Stanyslas Matayo wrote:

Dears,

Do we have a solution for this issue, because I face the same problem and
I want to know if it's possible with ODK Collect now.

I use the index-repeat function with position(..) inside my form designed
with excel but without success.

I try the same example designed here, but it's not working also.

Thanks
Matayo

Le jeudi 6 juin 2013 16:09:23 UTC+2, abta...@gmail.com a écrit :

I'm trying to do some simple addition and multiplication calculations
within a Repeat group. The calculations function for the first entry, but
fails for every additional entry. Can calculations function within repeats
beyond the first entry? And if they can, how do you configure the
calculation?

Thanks,
Will

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

Dear Christopher,

Thanks for your reply.

I try to calculate age for each person with details, It work for the first
person in repeat but the second one has the same age with the first, I work
with ODK Collect v 1.4.3 and XLSForm.

Please find attached the sample of my excel file where age is available.

Thanks
Matayo

Vulnerabilty_Assessment_Sample.xls (518 KB)

··· 2014-07-18 11:55 GMT+02:00 Christopher Robert :

Dear Matayo,

Calculations do work within repeat groups, and if even the sample form
doesn't work then perhaps you're running a version of Collect that doesn't
support indexed-repeat()? Are you running the latest version?

Also, the more detail you give, the more helpful people can be. For
example, you say that it's not working -- but how, exactly, is it not
working? And I'm assuming by "example" that you mean sample, but what
example do you mean? Be as detailed as you can and then you'll get the best
help. For example, if there is an error message, the exact details about
that error will be more helpful than just saying that there is an error
message. The people who help out in these forums thrive on details.

Thanks,

Chris

On Fri, Jul 18, 2014 at 3:46 AM, Stanyslas Matayo matayobweta@gmail.com wrote:

Dears,

Do we have a solution for this issue, because I face the same problem and
I want to know if it's possible with ODK Collect now.

I use the index-repeat function with position(..) inside my form designed
with excel but without success.

I try the same example designed here, but it's not working also.

Thanks
Matayo

Le jeudi 6 juin 2013 16:09:23 UTC+2, abta...@gmail.com a écrit :

I'm trying to do some simple addition and multiplication calculations
within a Repeat group. The calculations function for the first entry, but
fails for every additional entry. Can calculations function within repeats
beyond the first entry? And if they can, how do you configure the
calculation?

Thanks,
Will

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Matayo,

There are no "calculate" fields (rows) in your attached form. Moreover, to
confirm, your "calculation" column is completely empty. Therefore, there
are no calculations. I also find no "age" fields.

You'll want to calculate the age within the same repeat group with the
birthdays. If you want to access those ages, then, outside the repeat
group, you'll need to use indexed-repeat().

Good luck,

Chris

··· On Fri, Jul 18, 2014 at 6:40 AM, Stanyslas Matayo wrote:

Dear Christopher,

Thanks for your reply.

I try to calculate age for each person with details, It work for the first
person in repeat but the second one has the same age with the first, I work
with ODK Collect v 1.4.3 and XLSForm.

Please find attached the sample of my excel file where age is available.

Thanks
Matayo

2014-07-18 11:55 GMT+02:00 Christopher Robert chrislrobert@gmail.com:

Dear Matayo,

Calculations do work within repeat groups, and if even the sample form
doesn't work then perhaps you're running a version of Collect that doesn't
support indexed-repeat()? Are you running the latest version?

Also, the more detail you give, the more helpful people can be. For
example, you say that it's not working -- but how, exactly, is it not
working? And I'm assuming by "example" that you mean sample, but what
example do you mean? Be as detailed as you can and then you'll get the best
help. For example, if there is an error message, the exact details about
that error will be more helpful than just saying that there is an error
message. The people who help out in these forums thrive on details.

Thanks,

Chris

On Fri, Jul 18, 2014 at 3:46 AM, Stanyslas Matayo matayobweta@gmail.com wrote:

Dears,

Do we have a solution for this issue, because I face the same problem
and I want to know if it's possible with ODK Collect now.

I use the index-repeat function with position(..) inside my form
designed with excel but without success.

I try the same example designed here, but it's not working also.

Thanks
Matayo

Le jeudi 6 juin 2013 16:09:23 UTC+2, abta...@gmail.com a écrit :

I'm trying to do some simple addition and multiplication calculations
within a Repeat group. The calculations function for the first entry, but
fails for every additional entry. Can calculations function within repeats
beyond the first entry? And if they can, how do you configure the
calculation?

Thanks,
Will

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

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

Dear Christopher,

I sent a wrong document.

This is the good one.

Thanks
Matayo

Assessment_Sample.xls (160 KB)

··· 2014-07-18 12:46 GMT+02:00 Christopher Robert :

Matayo,

There are no "calculate" fields (rows) in your attached form. Moreover, to
confirm, your "calculation" column is completely empty. Therefore, there
are no calculations. I also find no "age" fields.

You'll want to calculate the age within the same repeat group with the
birthdays. If you want to access those ages, then, outside the repeat
group, you'll need to use indexed-repeat().

Good luck,

Chris

On Fri, Jul 18, 2014 at 6:40 AM, Stanyslas Matayo matayobweta@gmail.com wrote:

Dear Christopher,

Thanks for your reply.

I try to calculate age for each person with details, It work for the
first person in repeat but the second one has the same age with the first,
I work with ODK Collect v 1.4.3 and XLSForm.

Please find attached the sample of my excel file where age is available.

Thanks
Matayo

2014-07-18 11:55 GMT+02:00 Christopher Robert chrislrobert@gmail.com:

Dear Matayo,

Calculations do work within repeat groups, and if even the sample form
doesn't work then perhaps you're running a version of Collect that doesn't
support indexed-repeat()? Are you running the latest version?

Also, the more detail you give, the more helpful people can be. For
example, you say that it's not working -- but how, exactly, is it not
working? And I'm assuming by "example" that you mean sample, but what
example do you mean? Be as detailed as you can and then you'll get the best
help. For example, if there is an error message, the exact details about
that error will be more helpful than just saying that there is an error
message. The people who help out in these forums thrive on details.

Thanks,

Chris

On Fri, Jul 18, 2014 at 3:46 AM, Stanyslas Matayo <matayobweta@gmail.com wrote:

Dears,

Do we have a solution for this issue, because I face the same problem
and I want to know if it's possible with ODK Collect now.

I use the index-repeat function with position(..) inside my form
designed with excel but without success.

I try the same example designed here, but it's not working also.

Thanks
Matayo

Le jeudi 6 juin 2013 16:09:23 UTC+2, abta...@gmail.com a écrit :

I'm trying to do some simple addition and multiplication calculations
within a Repeat group. The calculations function for the first entry, but
fails for every additional entry. Can calculations function within repeats
beyond the first entry? And if they can, how do you configure the
calculation?

Thanks,
Will

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Matayo,

You don't need indexed-repeat() in this case, since the calculation is
within the same repeat group as the date that it uses. Thus, you can just
remove the indexed-repeat() and refer to the date of birth directly. It
should work fine.

Best,

Chris

··· On Fri, Jul 18, 2014 at 6:49 AM, Stanyslas Matayo wrote:

Dear Christopher,

I sent a wrong document.

This is the good one.

Thanks
Matayo

2014-07-18 12:46 GMT+02:00 Christopher Robert chrislrobert@gmail.com:

Matayo,

There are no "calculate" fields (rows) in your attached form. Moreover,
to confirm, your "calculation" column is completely empty. Therefore, there
are no calculations. I also find no "age" fields.

You'll want to calculate the age within the same repeat group with the
birthdays. If you want to access those ages, then, outside the repeat
group, you'll need to use indexed-repeat().

Good luck,

Chris

On Fri, Jul 18, 2014 at 6:40 AM, Stanyslas Matayo matayobweta@gmail.com wrote:

Dear Christopher,

Thanks for your reply.

I try to calculate age for each person with details, It work for the
first person in repeat but the second one has the same age with the first,
I work with ODK Collect v 1.4.3 and XLSForm.

Please find attached the sample of my excel file where age is available.

Thanks
Matayo

2014-07-18 11:55 GMT+02:00 Christopher Robert chrislrobert@gmail.com:

Dear Matayo,

Calculations do work within repeat groups, and if even the sample form
doesn't work then perhaps you're running a version of Collect that doesn't
support indexed-repeat()? Are you running the latest version?

Also, the more detail you give, the more helpful people can be. For
example, you say that it's not working -- but how, exactly, is it not
working? And I'm assuming by "example" that you mean sample, but what
example do you mean? Be as detailed as you can and then you'll get the best
help. For example, if there is an error message, the exact details about
that error will be more helpful than just saying that there is an error
message. The people who help out in these forums thrive on details.

Thanks,

Chris

On Fri, Jul 18, 2014 at 3:46 AM, Stanyslas Matayo < matayobweta@gmail.com> wrote:

Dears,

Do we have a solution for this issue, because I face the same problem
and I want to know if it's possible with ODK Collect now.

I use the index-repeat function with position(..) inside my form
designed with excel but without success.

I try the same example designed here, but it's not working also.

Thanks
Matayo

Le jeudi 6 juin 2013 16:09:23 UTC+2, abta...@gmail.com a écrit :

I'm trying to do some simple addition and multiplication calculations
within a Repeat group. The calculations function for the first entry, but
fails for every additional entry. Can calculations function within repeats
beyond the first entry? And if they can, how do you configure the
calculation?

Thanks,
Will

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

Dear Christopher,

Thanks for the support, i'll try it directly.

Thanks
Matayo

··· 2014-07-18 12:55 GMT+02:00 Christopher Robert :

Matayo,

You don't need indexed-repeat() in this case, since the calculation is
within the same repeat group as the date that it uses. Thus, you can just
remove the indexed-repeat() and refer to the date of birth directly. It
should work fine.

Best,

Chris

On Fri, Jul 18, 2014 at 6:49 AM, Stanyslas Matayo matayobweta@gmail.com wrote:

Dear Christopher,

I sent a wrong document.

This is the good one.

Thanks
Matayo

2014-07-18 12:46 GMT+02:00 Christopher Robert chrislrobert@gmail.com:

Matayo,

There are no "calculate" fields (rows) in your attached form. Moreover,
to confirm, your "calculation" column is completely empty. Therefore, there
are no calculations. I also find no "age" fields.

You'll want to calculate the age within the same repeat group with the
birthdays. If you want to access those ages, then, outside the repeat
group, you'll need to use indexed-repeat().

Good luck,

Chris

On Fri, Jul 18, 2014 at 6:40 AM, Stanyslas Matayo <matayobweta@gmail.com wrote:

Dear Christopher,

Thanks for your reply.

I try to calculate age for each person with details, It work for the
first person in repeat but the second one has the same age with the first,
I work with ODK Collect v 1.4.3 and XLSForm.

Please find attached the sample of my excel file where age is available.

Thanks
Matayo

2014-07-18 11:55 GMT+02:00 Christopher Robert chrislrobert@gmail.com:

Dear Matayo,

Calculations do work within repeat groups, and if even the sample form
doesn't work then perhaps you're running a version of Collect that doesn't
support indexed-repeat()? Are you running the latest version?

Also, the more detail you give, the more helpful people can be. For
example, you say that it's not working -- but how, exactly, is it not
working? And I'm assuming by "example" that you mean sample, but what
example do you mean? Be as detailed as you can and then you'll get the best
help. For example, if there is an error message, the exact details about
that error will be more helpful than just saying that there is an error
message. The people who help out in these forums thrive on details.

Thanks,

Chris

On Fri, Jul 18, 2014 at 3:46 AM, Stanyslas Matayo < matayobweta@gmail.com> wrote:

Dears,

Do we have a solution for this issue, because I face the same problem
and I want to know if it's possible with ODK Collect now.

I use the index-repeat function with position(..) inside my form
designed with excel but without success.

I try the same example designed here, but it's not working also.

Thanks
Matayo

Le jeudi 6 juin 2013 16:09:23 UTC+2, abta...@gmail.com a écrit :

I'm trying to do some simple addition and multiplication
calculations within a Repeat group. The calculations function for the
first entry, but fails for every additional entry. Can calculations
function within repeats beyond the first entry? And if they can, how do
you configure the calculation?

Thanks,
Will

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Dear Christopher,

I faced one problem before with the choice_filter before when I use direct
access to other field, I received one exception telling me that I should
consider using the index-repeat to fix this issues with choice_filter. When
I use index-repeat the exception disappear and everything gone well. If i
understand correctly your advice, this is not the case with calculation and
relevant?

Thanks
Matayo

··· 2014-07-18 12:57 GMT+02:00 Stanyslas Matayo :

Dear Christopher,

Thanks for the support, i'll try it directly.

Thanks
Matayo

2014-07-18 12:55 GMT+02:00 Christopher Robert chrislrobert@gmail.com:

Matayo,

You don't need indexed-repeat() in this case, since the calculation is
within the same repeat group as the date that it uses. Thus, you can just
remove the indexed-repeat() and refer to the date of birth directly. It
should work fine.

Best,

Chris

On Fri, Jul 18, 2014 at 6:49 AM, Stanyslas Matayo matayobweta@gmail.com wrote:

Dear Christopher,

I sent a wrong document.

This is the good one.

Thanks
Matayo

2014-07-18 12:46 GMT+02:00 Christopher Robert chrislrobert@gmail.com:

Matayo,

There are no "calculate" fields (rows) in your attached form. Moreover,
to confirm, your "calculation" column is completely empty. Therefore, there
are no calculations. I also find no "age" fields.

You'll want to calculate the age within the same repeat group with the
birthdays. If you want to access those ages, then, outside the repeat
group, you'll need to use indexed-repeat().

Good luck,

Chris

On Fri, Jul 18, 2014 at 6:40 AM, Stanyslas Matayo < matayobweta@gmail.com> wrote:

Dear Christopher,

Thanks for your reply.

I try to calculate age for each person with details, It work for the
first person in repeat but the second one has the same age with the first,
I work with ODK Collect v 1.4.3 and XLSForm.

Please find attached the sample of my excel file where age is
available.

Thanks
Matayo

2014-07-18 11:55 GMT+02:00 Christopher Robert chrislrobert@gmail.com
:

Dear Matayo,

Calculations do work within repeat groups, and if even the sample
form doesn't work then perhaps you're running a version of Collect that
doesn't support indexed-repeat()? Are you running the latest version?

Also, the more detail you give, the more helpful people can be. For
example, you say that it's not working -- but how, exactly, is it not
working? And I'm assuming by "example" that you mean sample, but what
example do you mean? Be as detailed as you can and then you'll get the best
help. For example, if there is an error message, the exact details about
that error will be more helpful than just saying that there is an error
message. The people who help out in these forums thrive on details.

Thanks,

Chris

On Fri, Jul 18, 2014 at 3:46 AM, Stanyslas Matayo < matayobweta@gmail.com> wrote:

Dears,

Do we have a solution for this issue, because I face the same
problem and I want to know if it's possible with ODK Collect now.

I use the index-repeat function with position(..) inside my form
designed with excel but without success.

I try the same example designed here, but it's not working also.

Thanks
Matayo

Le jeudi 6 juin 2013 16:09:23 UTC+2, abta...@gmail.com a écrit :

I'm trying to do some simple addition and multiplication
calculations within a Repeat group. The calculations function for the
first entry, but fails for every additional entry. Can calculations
function within repeats beyond the first entry? And if they can, how do
you configure the calculation?

Thanks,
Will

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

--
You received this message because you are subscribed to a topic in
the Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Yes, correct. You can search the community group to find other solutions to
the choice_filter issue.

Best,

Chris

··· On Fri, Jul 18, 2014 at 7:06 AM, Stanyslas Matayo wrote:

Dear Christopher,

I faced one problem before with the choice_filter before when I use direct
access to other field, I received one exception telling me that I should
consider using the index-repeat to fix this issues with choice_filter. When
I use index-repeat the exception disappear and everything gone well. If i
understand correctly your advice, this is not the case with calculation and
relevant?

Thanks
Matayo

2014-07-18 12:57 GMT+02:00 Stanyslas Matayo matayobweta@gmail.com:

Dear Christopher,

Thanks for the support, i'll try it directly.

Thanks
Matayo

2014-07-18 12:55 GMT+02:00 Christopher Robert chrislrobert@gmail.com:

Matayo,

You don't need indexed-repeat() in this case, since the calculation is
within the same repeat group as the date that it uses. Thus, you can just
remove the indexed-repeat() and refer to the date of birth directly. It
should work fine.

Best,

Chris

On Fri, Jul 18, 2014 at 6:49 AM, Stanyslas Matayo <matayobweta@gmail.com wrote:

Dear Christopher,

I sent a wrong document.

This is the good one.

Thanks
Matayo

2014-07-18 12:46 GMT+02:00 Christopher Robert chrislrobert@gmail.com:

Matayo,

There are no "calculate" fields (rows) in your attached form.
Moreover, to confirm, your "calculation" column is completely empty.
Therefore, there are no calculations. I also find no "age" fields.

You'll want to calculate the age within the same repeat group with the
birthdays. If you want to access those ages, then, outside the repeat
group, you'll need to use indexed-repeat().

Good luck,

Chris

On Fri, Jul 18, 2014 at 6:40 AM, Stanyslas Matayo < matayobweta@gmail.com> wrote:

Dear Christopher,

Thanks for your reply.

I try to calculate age for each person with details, It work for the
first person in repeat but the second one has the same age with the first,
I work with ODK Collect v 1.4.3 and XLSForm.

Please find attached the sample of my excel file where age is
available.

Thanks
Matayo

2014-07-18 11:55 GMT+02:00 Christopher Robert <chrislrobert@gmail.com

:

Dear Matayo,

Calculations do work within repeat groups, and if even the sample
form doesn't work then perhaps you're running a version of Collect that
doesn't support indexed-repeat()? Are you running the latest version?

Also, the more detail you give, the more helpful people can be. For
example, you say that it's not working -- but how, exactly, is it not
working? And I'm assuming by "example" that you mean sample, but what
example do you mean? Be as detailed as you can and then you'll get the best
help. For example, if there is an error message, the exact details about
that error will be more helpful than just saying that there is an error
message. The people who help out in these forums thrive on details.

Thanks,

Chris

On Fri, Jul 18, 2014 at 3:46 AM, Stanyslas Matayo < matayobweta@gmail.com> wrote:

Dears,

Do we have a solution for this issue, because I face the same
problem and I want to know if it's possible with ODK Collect now.

I use the index-repeat function with position(..) inside my form
designed with excel but without success.

I try the same example designed here, but it's not working also.

Thanks
Matayo

Le jeudi 6 juin 2013 16:09:23 UTC+2, abta...@gmail.com a écrit :

I'm trying to do some simple addition and multiplication
calculations within a Repeat group. The calculations function for the
first entry, but fails for every additional entry. Can calculations
function within repeats beyond the first entry? And if they can, how do
you configure the calculation?

Thanks,
Will

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

--
You received this message because you are subscribed to a topic in
the Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

Dear Christopher,

Thanks, it's working.

Thanks
Matayo

··· 2014-07-18 13:09 GMT+02:00 Christopher Robert :

Yes, correct. You can search the community group to find other solutions
to the choice_filter issue.

Best,

Chris

On Fri, Jul 18, 2014 at 7:06 AM, Stanyslas Matayo matayobweta@gmail.com wrote:

Dear Christopher,

I faced one problem before with the choice_filter before when I use
direct access to other field, I received one exception telling me that I
should consider using the index-repeat to fix this issues with
choice_filter. When I use index-repeat the exception disappear and
everything gone well. If i understand correctly your advice, this is not
the case with calculation and relevant?

Thanks
Matayo

2014-07-18 12:57 GMT+02:00 Stanyslas Matayo matayobweta@gmail.com:

Dear Christopher,

Thanks for the support, i'll try it directly.

Thanks
Matayo

2014-07-18 12:55 GMT+02:00 Christopher Robert chrislrobert@gmail.com:

Matayo,

You don't need indexed-repeat() in this case, since the calculation is
within the same repeat group as the date that it uses. Thus, you can just
remove the indexed-repeat() and refer to the date of birth directly. It
should work fine.

Best,

Chris

On Fri, Jul 18, 2014 at 6:49 AM, Stanyslas Matayo < matayobweta@gmail.com> wrote:

Dear Christopher,

I sent a wrong document.

This is the good one.

Thanks
Matayo

2014-07-18 12:46 GMT+02:00 Christopher Robert chrislrobert@gmail.com
:

Matayo,

There are no "calculate" fields (rows) in your attached form.
Moreover, to confirm, your "calculation" column is completely empty.
Therefore, there are no calculations. I also find no "age" fields.

You'll want to calculate the age within the same repeat group with
the birthdays. If you want to access those ages, then, outside the repeat
group, you'll need to use indexed-repeat().

Good luck,

Chris

On Fri, Jul 18, 2014 at 6:40 AM, Stanyslas Matayo < matayobweta@gmail.com> wrote:

Dear Christopher,

Thanks for your reply.

I try to calculate age for each person with details, It work for the
first person in repeat but the second one has the same age with the first,
I work with ODK Collect v 1.4.3 and XLSForm.

Please find attached the sample of my excel file where age is
available.

Thanks
Matayo

2014-07-18 11:55 GMT+02:00 Christopher Robert <
chrislrobert@gmail.com>:

Dear Matayo,

Calculations do work within repeat groups, and if even the sample
form doesn't work then perhaps you're running a version of Collect that
doesn't support indexed-repeat()? Are you running the latest version?

Also, the more detail you give, the more helpful people can be. For
example, you say that it's not working -- but how, exactly, is it not
working? And I'm assuming by "example" that you mean sample, but what
example do you mean? Be as detailed as you can and then you'll get the best
help. For example, if there is an error message, the exact details about
that error will be more helpful than just saying that there is an error
message. The people who help out in these forums thrive on details.

Thanks,

Chris

On Fri, Jul 18, 2014 at 3:46 AM, Stanyslas Matayo < matayobweta@gmail.com> wrote:

Dears,

Do we have a solution for this issue, because I face the same
problem and I want to know if it's possible with ODK Collect now.

I use the index-repeat function with position(..) inside my form
designed with excel but without success.

I try the same example designed here, but it's not working also.

Thanks
Matayo

Le jeudi 6 juin 2013 16:09:23 UTC+2, abta...@gmail.com a écrit :

I'm trying to do some simple addition and multiplication
calculations within a Repeat group. The calculations function for the
first entry, but fails for every additional entry. Can calculations
function within repeats beyond the first entry? And if they can, how do
you configure the calculation?

Thanks,
Will

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

--
You received this message because you are subscribed to a topic in
the Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic in
the Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

When using a repeated field to select a value from, e.g., a cascading
select, you will likely need to precede your use of ".." with "current()/"

in the XML, it should be:

instance('towns')/data/state[name=current()/../chosenstate]/towns

vs.

instance('towns')/data/state[name=../chosenstate]/towns

The problem with the last expression is that the ../ is evaluated relative
to instance('towns')/data/state, so you are referencing
instance('towns')/data/chosenstate instead of your form's chosenstate
field.

By using current()/, you are saying that you want the ../chosenform to be
evaluated relative to the field you are currently rendering (presumably the
select-your-town field).

··· On Fri, Jul 18, 2014 at 4:39 AM, Stanyslas Matayo wrote:

Dear Christopher,

Thanks, it's working.

Thanks
Matayo

2014-07-18 13:09 GMT+02:00 Christopher Robert chrislrobert@gmail.com:

Yes, correct. You can search the community group to find other solutions

to the choice_filter issue.

Best,

Chris

On Fri, Jul 18, 2014 at 7:06 AM, Stanyslas Matayo matayobweta@gmail.com wrote:

Dear Christopher,

I faced one problem before with the choice_filter before when I use
direct access to other field, I received one exception telling me that I
should consider using the index-repeat to fix this issues with
choice_filter. When I use index-repeat the exception disappear and
everything gone well. If i understand correctly your advice, this is not
the case with calculation and relevant?

Thanks
Matayo

2014-07-18 12:57 GMT+02:00 Stanyslas Matayo matayobweta@gmail.com:

Dear Christopher,

Thanks for the support, i'll try it directly.

Thanks
Matayo

2014-07-18 12:55 GMT+02:00 Christopher Robert chrislrobert@gmail.com:

Matayo,

You don't need indexed-repeat() in this case, since the calculation is
within the same repeat group as the date that it uses. Thus, you can just
remove the indexed-repeat() and refer to the date of birth directly. It
should work fine.

Best,

Chris

On Fri, Jul 18, 2014 at 6:49 AM, Stanyslas Matayo < matayobweta@gmail.com> wrote:

Dear Christopher,

I sent a wrong document.

This is the good one.

Thanks
Matayo

2014-07-18 12:46 GMT+02:00 Christopher Robert <chrislrobert@gmail.com

:

Matayo,

There are no "calculate" fields (rows) in your attached form.
Moreover, to confirm, your "calculation" column is completely empty.
Therefore, there are no calculations. I also find no "age" fields.

You'll want to calculate the age within the same repeat group with
the birthdays. If you want to access those ages, then, outside the repeat
group, you'll need to use indexed-repeat().

Good luck,

Chris

On Fri, Jul 18, 2014 at 6:40 AM, Stanyslas Matayo < matayobweta@gmail.com> wrote:

Dear Christopher,

Thanks for your reply.

I try to calculate age for each person with details, It work for
the first person in repeat but the second one has the same age with the
first, I work with ODK Collect v 1.4.3 and XLSForm.

Please find attached the sample of my excel file where age is
available.

Thanks
Matayo

2014-07-18 11:55 GMT+02:00 Christopher Robert <
chrislrobert@gmail.com>:

Dear Matayo,

Calculations do work within repeat groups, and if even the sample
form doesn't work then perhaps you're running a version of Collect that
doesn't support indexed-repeat()? Are you running the latest version?

Also, the more detail you give, the more helpful people can be.
For example, you say that it's not working -- but how, exactly, is it not
working? And I'm assuming by "example" that you mean sample, but what
example do you mean? Be as detailed as you can and then you'll get the best
help. For example, if there is an error message, the exact details about
that error will be more helpful than just saying that there is an error
message. The people who help out in these forums thrive on details.

Thanks,

Chris

On Fri, Jul 18, 2014 at 3:46 AM, Stanyslas Matayo < matayobweta@gmail.com> wrote:

Dears,

Do we have a solution for this issue, because I face the same
problem and I want to know if it's possible with ODK Collect now.

I use the index-repeat function with position(..) inside my form
designed with excel but without success.

I try the same example designed here, but it's not working also.

Thanks
Matayo

Le jeudi 6 juin 2013 16:09:23 UTC+2, abta...@gmail.com a écrit :

I'm trying to do some simple addition and multiplication
calculations within a Repeat group. The calculations function for the
first entry, but fails for every additional entry. Can calculations
function within repeats beyond the first entry? And if they can, how do
you configure the calculation?

Thanks,
Will

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

--
You received this message because you are subscribed to a topic in
the Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email
to opendatakit-developers+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic in
the Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

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

Dear Mitch,

Thanks a lot for this information

Thanks it's the way to do it with XSLForm?

And if it not possible what to add in excel file and what to change after
that?

Thanks
Matayo

··· 2014-07-18 19:36 GMT+02:00 Mitch Sundt :

When using a repeated field to select a value from, e.g., a cascading
select, you will likely need to precede your use of ".." with "current()/"

in the XML, it should be:

instance('towns')/data/state[name=current()/../chosenstate]/towns

vs.

instance('towns')/data/state[name=../chosenstate]/towns

The problem with the last expression is that the ../ is evaluated relative
to instance('towns')/data/state, so you are referencing
instance('towns')/data/chosenstate instead of your form's chosenstate
field.

By using current()/, you are saying that you want the ../chosenform to be
evaluated relative to the field you are currently rendering (presumably the
select-your-town field).

On Fri, Jul 18, 2014 at 4:39 AM, Stanyslas Matayo matayobweta@gmail.com wrote:

Dear Christopher,

Thanks, it's working.

Thanks
Matayo

2014-07-18 13:09 GMT+02:00 Christopher Robert chrislrobert@gmail.com:

Yes, correct. You can search the community group to find other solutions

to the choice_filter issue.

Best,

Chris

On Fri, Jul 18, 2014 at 7:06 AM, Stanyslas Matayo <matayobweta@gmail.com wrote:

Dear Christopher,

I faced one problem before with the choice_filter before when I use
direct access to other field, I received one exception telling me that I
should consider using the index-repeat to fix this issues with
choice_filter. When I use index-repeat the exception disappear and
everything gone well. If i understand correctly your advice, this is not
the case with calculation and relevant?

Thanks
Matayo

2014-07-18 12:57 GMT+02:00 Stanyslas Matayo matayobweta@gmail.com:

Dear Christopher,

Thanks for the support, i'll try it directly.

Thanks
Matayo

2014-07-18 12:55 GMT+02:00 Christopher Robert chrislrobert@gmail.com
:

Matayo,

You don't need indexed-repeat() in this case, since the calculation
is within the same repeat group as the date that it uses. Thus, you can
just remove the indexed-repeat() and refer to the date of birth directly.
It should work fine.

Best,

Chris

On Fri, Jul 18, 2014 at 6:49 AM, Stanyslas Matayo < matayobweta@gmail.com> wrote:

Dear Christopher,

I sent a wrong document.

This is the good one.

Thanks
Matayo

2014-07-18 12:46 GMT+02:00 Christopher Robert <
chrislrobert@gmail.com>:

Matayo,

There are no "calculate" fields (rows) in your attached form.
Moreover, to confirm, your "calculation" column is completely empty.
Therefore, there are no calculations. I also find no "age" fields.

You'll want to calculate the age within the same repeat group with
the birthdays. If you want to access those ages, then, outside the repeat
group, you'll need to use indexed-repeat().

Good luck,

Chris

On Fri, Jul 18, 2014 at 6:40 AM, Stanyslas Matayo < matayobweta@gmail.com> wrote:

Dear Christopher,

Thanks for your reply.

I try to calculate age for each person with details, It work for
the first person in repeat but the second one has the same age with the
first, I work with ODK Collect v 1.4.3 and XLSForm.

Please find attached the sample of my excel file where age is
available.

Thanks
Matayo

2014-07-18 11:55 GMT+02:00 Christopher Robert <
chrislrobert@gmail.com>:

Dear Matayo,

Calculations do work within repeat groups, and if even the sample
form doesn't work then perhaps you're running a version of Collect that
doesn't support indexed-repeat()? Are you running the latest version?

Also, the more detail you give, the more helpful people can be.
For example, you say that it's not working -- but how, exactly, is it not
working? And I'm assuming by "example" that you mean sample, but what
example do you mean? Be as detailed as you can and then you'll get the best
help. For example, if there is an error message, the exact details about
that error will be more helpful than just saying that there is an error
message. The people who help out in these forums thrive on details.

Thanks,

Chris

On Fri, Jul 18, 2014 at 3:46 AM, Stanyslas Matayo < matayobweta@gmail.com> wrote:

Dears,

Do we have a solution for this issue, because I face the same
problem and I want to know if it's possible with ODK Collect now.

I use the index-repeat function with position(..) inside my form
designed with excel but without success.

I try the same example designed here, but it's not working also.

Thanks
Matayo

Le jeudi 6 juin 2013 16:09:23 UTC+2, abta...@gmail.com a écrit :

I'm trying to do some simple addition and multiplication
calculations within a Repeat group. The calculations function for the
first entry, but fails for every additional entry. Can calculations
function within repeats beyond the first entry? And if they can, how do
you configure the calculation?

Thanks,
Will

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

--
You received this message because you are subscribed to a topic
in the Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email
to opendatakit-developers+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic in
the Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic in
the Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Dear Mitch,

Sorry for the question, I get it.

Thanks
Matayo

··· 2014-07-19 0:20 GMT+02:00 Stanyslas Matayo :

Dear Mitch,

Thanks a lot for this information

Thanks it's the way to do it with XSLForm?

And if it not possible what to add in excel file and what to change after
that?

Thanks
Matayo

2014-07-18 19:36 GMT+02:00 Mitch Sundt mitchellsundt@gmail.com:

When using a repeated field to select a value from, e.g., a cascading

select, you will likely need to precede your use of ".." with "current()/"

in the XML, it should be:

instance('towns')/data/state[name=current()/../chosenstate]/towns

vs.

instance('towns')/data/state[name=../chosenstate]/towns

The problem with the last expression is that the ../ is evaluated
relative to instance('towns')/data/state, so you are referencing
instance('towns')/data/chosenstate instead of your form's chosenstate
field.

By using current()/, you are saying that you want the ../chosenform to be
evaluated relative to the field you are currently rendering (presumably the
select-your-town field).

On Fri, Jul 18, 2014 at 4:39 AM, Stanyslas Matayo matayobweta@gmail.com wrote:

Dear Christopher,

Thanks, it's working.

Thanks
Matayo

2014-07-18 13:09 GMT+02:00 Christopher Robert chrislrobert@gmail.com:

Yes, correct. You can search the community group to find other solutions

to the choice_filter issue.

Best,

Chris

On Fri, Jul 18, 2014 at 7:06 AM, Stanyslas Matayo < matayobweta@gmail.com> wrote:

Dear Christopher,

I faced one problem before with the choice_filter before when I use
direct access to other field, I received one exception telling me that I
should consider using the index-repeat to fix this issues with
choice_filter. When I use index-repeat the exception disappear and
everything gone well. If i understand correctly your advice, this is not
the case with calculation and relevant?

Thanks
Matayo

2014-07-18 12:57 GMT+02:00 Stanyslas Matayo matayobweta@gmail.com:

Dear Christopher,

Thanks for the support, i'll try it directly.

Thanks
Matayo

2014-07-18 12:55 GMT+02:00 Christopher Robert <chrislrobert@gmail.com

:

Matayo,

You don't need indexed-repeat() in this case, since the calculation
is within the same repeat group as the date that it uses. Thus, you can
just remove the indexed-repeat() and refer to the date of birth directly.
It should work fine.

Best,

Chris

On Fri, Jul 18, 2014 at 6:49 AM, Stanyslas Matayo < matayobweta@gmail.com> wrote:

Dear Christopher,

I sent a wrong document.

This is the good one.

Thanks
Matayo

2014-07-18 12:46 GMT+02:00 Christopher Robert <
chrislrobert@gmail.com>:

Matayo,

There are no "calculate" fields (rows) in your attached form.
Moreover, to confirm, your "calculation" column is completely empty.
Therefore, there are no calculations. I also find no "age" fields.

You'll want to calculate the age within the same repeat group with
the birthdays. If you want to access those ages, then, outside the repeat
group, you'll need to use indexed-repeat().

Good luck,

Chris

On Fri, Jul 18, 2014 at 6:40 AM, Stanyslas Matayo < matayobweta@gmail.com> wrote:

Dear Christopher,

Thanks for your reply.

I try to calculate age for each person with details, It work for
the first person in repeat but the second one has the same age with the
first, I work with ODK Collect v 1.4.3 and XLSForm.

Please find attached the sample of my excel file where age is
available.

Thanks
Matayo

2014-07-18 11:55 GMT+02:00 Christopher Robert <
chrislrobert@gmail.com>:

Dear Matayo,

Calculations do work within repeat groups, and if even the
sample form doesn't work then perhaps you're running a version of Collect
that doesn't support indexed-repeat()? Are you running the latest version?

Also, the more detail you give, the more helpful people can be.
For example, you say that it's not working -- but how, exactly, is it not
working? And I'm assuming by "example" that you mean sample, but what
example do you mean? Be as detailed as you can and then you'll get the best
help. For example, if there is an error message, the exact details about
that error will be more helpful than just saying that there is an error
message. The people who help out in these forums thrive on details.

Thanks,

Chris

On Fri, Jul 18, 2014 at 3:46 AM, Stanyslas Matayo < matayobweta@gmail.com> wrote:

Dears,

Do we have a solution for this issue, because I face the same
problem and I want to know if it's possible with ODK Collect now.

I use the index-repeat function with position(..) inside my
form designed with excel but without success.

I try the same example designed here, but it's not working also.

Thanks
Matayo

Le jeudi 6 juin 2013 16:09:23 UTC+2, abta...@gmail.com a
écrit :

I'm trying to do some simple addition and multiplication
calculations within a Repeat group. The calculations function for the
first entry, but fails for every additional entry. Can calculations
function within repeats beyond the first entry? And if they can, how do
you configure the calculation?

Thanks,
Will

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

--
You received this message because you are subscribed to a topic
in the Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email
to opendatakit-developers+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic in
the Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email
to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic in
the Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Dear Mitch,

I observe that XSLForm generate an absolute path but your example use a
relative path, Please can you telle me how can I use your advice.
current()/form/.... or I should use /current()/form/.... or /form/ ....
/../current() ... Please advice which solution is the good one?

Thanks
Matayo

··· 2014-07-19 0:24 GMT+02:00 Stanyslas Matayo :

Dear Mitch,

Sorry for the question, I get it.

Thanks
Matayo

2014-07-19 0:20 GMT+02:00 Stanyslas Matayo matayobweta@gmail.com:

Dear Mitch,

Thanks a lot for this information

Thanks it's the way to do it with XSLForm?

And if it not possible what to add in excel file and what to change after
that?

Thanks
Matayo

2014-07-18 19:36 GMT+02:00 Mitch Sundt mitchellsundt@gmail.com:

When using a repeated field to select a value from, e.g., a cascading

select, you will likely need to precede your use of ".." with "current()/"

in the XML, it should be:

instance('towns')/data/state[name=current()/../chosenstate]/towns

vs.

instance('towns')/data/state[name=../chosenstate]/towns

The problem with the last expression is that the ../ is evaluated
relative to instance('towns')/data/state, so you are referencing
instance('towns')/data/chosenstate instead of your form's chosenstate
field.

By using current()/, you are saying that you want the ../chosenform to
be evaluated relative to the field you are currently rendering (presumably
the select-your-town field).

On Fri, Jul 18, 2014 at 4:39 AM, Stanyslas Matayo <matayobweta@gmail.com wrote:

Dear Christopher,

Thanks, it's working.

Thanks
Matayo

2014-07-18 13:09 GMT+02:00 Christopher Robert chrislrobert@gmail.com:

Yes, correct. You can search the community group to find other

solutions to the choice_filter issue.

Best,

Chris

On Fri, Jul 18, 2014 at 7:06 AM, Stanyslas Matayo < matayobweta@gmail.com> wrote:

Dear Christopher,

I faced one problem before with the choice_filter before when I use
direct access to other field, I received one exception telling me that I
should consider using the index-repeat to fix this issues with
choice_filter. When I use index-repeat the exception disappear and
everything gone well. If i understand correctly your advice, this is not
the case with calculation and relevant?

Thanks
Matayo

2014-07-18 12:57 GMT+02:00 Stanyslas Matayo matayobweta@gmail.com:

Dear Christopher,

Thanks for the support, i'll try it directly.

Thanks
Matayo

2014-07-18 12:55 GMT+02:00 Christopher Robert <
chrislrobert@gmail.com>:

Matayo,

You don't need indexed-repeat() in this case, since the calculation
is within the same repeat group as the date that it uses. Thus, you can
just remove the indexed-repeat() and refer to the date of birth directly.
It should work fine.

Best,

Chris

On Fri, Jul 18, 2014 at 6:49 AM, Stanyslas Matayo < matayobweta@gmail.com> wrote:

Dear Christopher,

I sent a wrong document.

This is the good one.

Thanks
Matayo

2014-07-18 12:46 GMT+02:00 Christopher Robert <
chrislrobert@gmail.com>:

Matayo,

There are no "calculate" fields (rows) in your attached form.
Moreover, to confirm, your "calculation" column is completely empty.
Therefore, there are no calculations. I also find no "age" fields.

You'll want to calculate the age within the same repeat group
with the birthdays. If you want to access those ages, then, outside the
repeat group, you'll need to use indexed-repeat().

Good luck,

Chris

On Fri, Jul 18, 2014 at 6:40 AM, Stanyslas Matayo < matayobweta@gmail.com> wrote:

Dear Christopher,

Thanks for your reply.

I try to calculate age for each person with details, It work for
the first person in repeat but the second one has the same age with the
first, I work with ODK Collect v 1.4.3 and XLSForm.

Please find attached the sample of my excel file where age is
available.

Thanks
Matayo

2014-07-18 11:55 GMT+02:00 Christopher Robert <
chrislrobert@gmail.com>:

Dear Matayo,

Calculations do work within repeat groups, and if even the
sample form doesn't work then perhaps you're running a version of Collect
that doesn't support indexed-repeat()? Are you running the latest version?

Also, the more detail you give, the more helpful people can be.
For example, you say that it's not working -- but how, exactly, is it not
working? And I'm assuming by "example" that you mean sample, but what
example do you mean? Be as detailed as you can and then you'll get the best
help. For example, if there is an error message, the exact details about
that error will be more helpful than just saying that there is an error
message. The people who help out in these forums thrive on details.

Thanks,

Chris

On Fri, Jul 18, 2014 at 3:46 AM, Stanyslas Matayo < matayobweta@gmail.com> wrote:

Dears,

Do we have a solution for this issue, because I face the same
problem and I want to know if it's possible with ODK Collect now.

I use the index-repeat function with position(..) inside my
form designed with excel but without success.

I try the same example designed here, but it's not working
also.

Thanks
Matayo

Le jeudi 6 juin 2013 16:09:23 UTC+2, abta...@gmail.com a
écrit :

I'm trying to do some simple addition and multiplication
calculations within a Repeat group. The calculations function for the
first entry, but fails for every additional entry. Can calculations
function within repeats beyond the first entry? And if they can, how do
you configure the calculation?

Thanks,
Will

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

--
You received this message because you are subscribed to a topic
in the Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an
email to opendatakit-developers+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic
in the Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email
to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic in
the Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Dear Mitch,

Solution found.

Thanks
Matayo

··· 2014-07-19 7:38 GMT+02:00 Stanyslas Matayo :

Dear Mitch,

I observe that XSLForm generate an absolute path but your example use a
relative path, Please can you telle me how can I use your advice.
current()/form/.... or I should use /current()/form/.... or /form/ ....
/../current() ... Please advice which solution is the good one?

Thanks
Matayo

2014-07-19 0:24 GMT+02:00 Stanyslas Matayo matayobweta@gmail.com:

Dear Mitch,

Sorry for the question, I get it.

Thanks
Matayo

2014-07-19 0:20 GMT+02:00 Stanyslas Matayo matayobweta@gmail.com:

Dear Mitch,

Thanks a lot for this information

Thanks it's the way to do it with XSLForm?

And if it not possible what to add in excel file and what to change
after that?

Thanks
Matayo

2014-07-18 19:36 GMT+02:00 Mitch Sundt mitchellsundt@gmail.com:

When using a repeated field to select a value from, e.g., a cascading

select, you will likely need to precede your use of ".." with "current()/"

in the XML, it should be:

instance('towns')/data/state[name=current()/../chosenstate]/towns

vs.

instance('towns')/data/state[name=../chosenstate]/towns

The problem with the last expression is that the ../ is evaluated
relative to instance('towns')/data/state, so you are referencing
instance('towns')/data/chosenstate instead of your form's chosenstate
field.

By using current()/, you are saying that you want the ../chosenform to
be evaluated relative to the field you are currently rendering (presumably
the select-your-town field).

On Fri, Jul 18, 2014 at 4:39 AM, Stanyslas Matayo < matayobweta@gmail.com> wrote:

Dear Christopher,

Thanks, it's working.

Thanks
Matayo

2014-07-18 13:09 GMT+02:00 Christopher Robert chrislrobert@gmail.com
:

Yes, correct. You can search the community group to find other

solutions to the choice_filter issue.

Best,

Chris

On Fri, Jul 18, 2014 at 7:06 AM, Stanyslas Matayo < matayobweta@gmail.com> wrote:

Dear Christopher,

I faced one problem before with the choice_filter before when I use
direct access to other field, I received one exception telling me that I
should consider using the index-repeat to fix this issues with
choice_filter. When I use index-repeat the exception disappear and
everything gone well. If i understand correctly your advice, this is not
the case with calculation and relevant?

Thanks
Matayo

2014-07-18 12:57 GMT+02:00 Stanyslas Matayo matayobweta@gmail.com:

Dear Christopher,

Thanks for the support, i'll try it directly.

Thanks
Matayo

2014-07-18 12:55 GMT+02:00 Christopher Robert <
chrislrobert@gmail.com>:

Matayo,

You don't need indexed-repeat() in this case, since the
calculation is within the same repeat group as the date that it uses. Thus,
you can just remove the indexed-repeat() and refer to the date of birth
directly. It should work fine.

Best,

Chris

On Fri, Jul 18, 2014 at 6:49 AM, Stanyslas Matayo < matayobweta@gmail.com> wrote:

Dear Christopher,

I sent a wrong document.

This is the good one.

Thanks
Matayo

2014-07-18 12:46 GMT+02:00 Christopher Robert <
chrislrobert@gmail.com>:

Matayo,

There are no "calculate" fields (rows) in your attached form.
Moreover, to confirm, your "calculation" column is completely empty.
Therefore, there are no calculations. I also find no "age" fields.

You'll want to calculate the age within the same repeat group
with the birthdays. If you want to access those ages, then, outside the
repeat group, you'll need to use indexed-repeat().

Good luck,

Chris

On Fri, Jul 18, 2014 at 6:40 AM, Stanyslas Matayo < matayobweta@gmail.com> wrote:

Dear Christopher,

Thanks for your reply.

I try to calculate age for each person with details, It work
for the first person in repeat but the second one has the same age with the
first, I work with ODK Collect v 1.4.3 and XLSForm.

Please find attached the sample of my excel file where age is
available.

Thanks
Matayo

2014-07-18 11:55 GMT+02:00 Christopher Robert <
chrislrobert@gmail.com>:

Dear Matayo,

Calculations do work within repeat groups, and if even the
sample form doesn't work then perhaps you're running a version of Collect
that doesn't support indexed-repeat()? Are you running the latest version?

Also, the more detail you give, the more helpful people can
be. For example, you say that it's not working -- but how, exactly, is it
not working? And I'm assuming by "example" that you mean sample, but what
example do you mean? Be as detailed as you can and then you'll get the best
help. For example, if there is an error message, the exact details about
that error will be more helpful than just saying that there is an error
message. The people who help out in these forums thrive on details.

Thanks,

Chris

On Fri, Jul 18, 2014 at 3:46 AM, Stanyslas Matayo < matayobweta@gmail.com> wrote:

Dears,

Do we have a solution for this issue, because I face the same
problem and I want to know if it's possible with ODK Collect now.

I use the index-repeat function with position(..) inside my
form designed with excel but without success.

I try the same example designed here, but it's not working
also.

Thanks
Matayo

Le jeudi 6 juin 2013 16:09:23 UTC+2, abta...@gmail.com a
écrit :

I'm trying to do some simple addition and multiplication
calculations within a Repeat group. The calculations function for the
first entry, but fails for every additional entry. Can calculations
function within repeats beyond the first entry? And if they can, how do
you configure the calculation?

Thanks,
Will

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

--
You received this message because you are subscribed to a
topic in the Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an
email to opendatakit-developers+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic
in the Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email
to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic in
the Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email
to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic in
the Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Can you share the solution please?

··· On Saturday, July 19, 2014 at 9:40:51 PM UTC+2, Stanyslas Matayo wrote: > Dear Mitch, > > > Solution found. > > > Thanks > Matayo > > > > 2014-07-19 7:38 GMT+02:00 Stanyslas Matayo : > > > Dear Mitch, > > > I observe that XSLForm generate an absolute path but your example use a relative path, Please can you telle me how can I use your advice. current()/form/.... or I should use /current()/form/.... or /form/ .... /../current() ... Please advice which solution is the good one? > > > > > Thanks > Matayo > > > > 2014-07-19 0:24 GMT+02:00 Stanyslas Matayo : > > > > > > Dear Mitch, > > > Sorry for the question, I get it. > > > Thanks > > > Matayo > > > > 2014-07-19 0:20 GMT+02:00 Stanyslas Matayo : > > > > > > > Dear Mitch, > > > Thanks a lot for this information > > > Thanks it's the way to do it with XSLForm? > > > > > > And if it not possible what to add in excel file and what to change after that? > > > > > > > > Thanks > Matayo > > > > 2014-07-18 19:36 GMT+02:00 Mitch Sundt : > > > > > > > > > > > When using a repeated field to select a value from, e.g., a cascading select, you will likely need to precede your use of ".." with "current()/" > > > > > > > in the XML, it should be: > > > instance('towns')/data/state[name=current()/../chosenstate]/towns > > vs. > > instance('towns')/data/state[name=../chosenstate]/towns > > The problem with the last expression is that the ../ is evaluated relative to instance('towns')/data/state, so you are referencing instance('towns')/data/chosenstate instead of your form's chosenstate field. > > > > > > > By using current()/, you are saying that you want the ../chosenform to be evaluated relative to the field you are currently rendering (presumably the select-your-town field). > > > > > > > > > > > > > On Fri, Jul 18, 2014 at 4:39 AM, Stanyslas Matayo wrote: > > > > > > > Dear Christopher, > > > Thanks, it's working. > > > Thanks > Matayo > > > > 2014-07-18 13:09 GMT+02:00 Christopher Robert : > > > > > > > > > > Yes, correct. You can search the community group to find other solutions to the choice_filter issue. > > > > > > > > > Best, > > > Chris > > > > > > > > > > On Fri, Jul 18, 2014 at 7:06 AM, Stanyslas Matayo wrote: > > > > > > > > > > Dear Christopher, > > > I faced one problem before with the choice_filter before when I use direct access to other field, I received one exception telling me that I should consider using the index-repeat to fix this issues with choice_filter. When I use index-repeat the exception disappear and everything gone well. If i understand correctly your advice, this is not the case with calculation and relevant? > > > > > > > > > > > > Thanks > Matayo > > > > > > > > 2014-07-18 12:57 GMT+02:00 Stanyslas Matayo : > > > > > > > > > > > > > Dear Christopher, > > > Thanks for the support, i'll try it directly. > > > > > > > > > > > > Thanks > Matayo > > > > 2014-07-18 12:55 GMT+02:00 Christopher Robert : > > > > > > > > > > > > > > Matayo, > > > > You don't need indexed-repeat() in this case, since the calculation is within the same repeat group as the date that it uses. Thus, you can just remove the indexed-repeat() and refer to the date of birth directly. It should work fine. > > > > > > > > > > > > > > > Best, > > > Chris > > > > > > > > On Fri, Jul 18, 2014 at 6:49 AM, Stanyslas Matayo wrote: > > > > > > > > > > > > > > Dear Christopher, > > > I sent a wrong document. > > This is the good one. > > > > > > > > > > > > > > > Thanks > Matayo > > > > > 2014-07-18 12:46 GMT+02:00 Christopher Robert : > > > > > > > > > > > > > > > > > Matayo, > > > > There are no "calculate" fields (rows) in your attached form. Moreover, to confirm, your "calculation" column is completely empty. Therefore, there are no calculations. I also find no "age" fields. > > > > > > > > > > > > > > > > > > You'll want to calculate the age within the same repeat group with the birthdays. If you want to access those ages, then, outside the repeat group, you'll need to use indexed-repeat(). > > > > > > > > > > > > > > > > > > Good luck, > > > Chris > > > > > > > > On Fri, Jul 18, 2014 at 6:40 AM, Stanyslas Matayo wrote: > > > > > > > > > > > > > > > > > Dear Christopher, > > > Thanks for your reply. > > > I try to calculate age for each person with details, It work for the first person in repeat but the second one has the same age with the first, I work with ODK Collect v 1.4.3 and XLSForm. > > > > > > > > > > > > > > > > > > > Please find attached the sample of my excel file where age is available. > > > Thanks > Matayo > > > > 2014-07-18 11:55 GMT+02:00 Christopher Robert : > > > > > > > > > > > > > > > > > > > > Dear Matayo, > > > Calculations do work within repeat groups, and if even the sample form doesn't work then perhaps you're running a version of Collect that doesn't support indexed-repeat()? Are you running the latest version? > > > > > > > > > > > > > > > > > > > > > Also, the more detail you give, the more helpful people can be. For example, you say that it's not working -- but how, exactly, is it not working? And I'm assuming by "example" that you mean sample, but what example do you mean? Be as detailed as you can and then you'll get the best help. For example, if there is an error message, the exact details about that error will be more helpful than just saying that there is an error message. The people who help out in these forums thrive on details. > > > > > > > > > > > > > > > > > > > > > Thanks, > > > Chris > > > > > > > On Fri, Jul 18, 2014 at 3:46 AM, Stanyslas Matayo wrote: > > > > > > > > > > > > > > > > > > > > > Dears, > > > Do we have a solution for this issue, because I face the same problem and I want to know if it's possible with ODK Collect now. > > > > > > > > > > > > > > > > > > > > > I use the index-repeat function with position(..) inside my form designed with excel but without success. > > > I try the same example designed here, but it's not working also. > > > > > > > > > > > > > > > > > > > > > Thanks > Matayo > > Le jeudi 6 juin 2013 16:09:23 UTC+2, abta...@gmail.com a écrit : > > > > > > > > > > > > > > > > > > > > I'm trying to do some simple addition and multiplication calculations within a Repeat group. The calculations function for the first entry, but fails for every additional entry. Can calculations function within repeats beyond the first entry? And if they can, how do you configure the calculation? > > > > > > > > > > > > > > > > > > > Thanks, > Will > > > > > > > -- > > You received this message because you are subscribed to the Google Groups "ODK Developers" group. > > To unsubscribe from this group and stop receiving emails from it, send an email to opendatakit-developers+unsubscribe@googlegroups.com. > > > > > > > > > > > > > > > > > > > > > For more options, visit https://groups.google.com/d/optout. > > > > > > > > > > -- > > You received this message because you are subscribed to a topic in the Google Groups "ODK Developers" group. > > To unsubscribe from this topic, visit https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe. > > > > > > > > > > > > > > > > > > To unsubscribe from this group and all its topics, send an email to opendatakit-developers+unsubscribe@googlegroups.com. > > > > > > > > > > > > > > > > > > For more options, visit https://groups.google.com/d/optout. > > > > > > > > > > -- > > You received this message because you are subscribed to the Google Groups "ODK Developers" group. > > To unsubscribe from this group and stop receiving emails from it, send an email to opendatakit-developers+unsubscribe@googlegroups.com. > > > > > > > > > > > > > > > > > For more options, visit https://groups.google.com/d/optout. > > > > > > > > -- > > You received this message because you are subscribed to a topic in the Google Groups "ODK Developers" group. > > To unsubscribe from this topic, visit https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe. > > > > > > > > > > > > > > > To unsubscribe from this group and all its topics, send an email to opendatakit-developers+unsubscribe@googlegroups.com. > > For more options, visit https://groups.google.com/d/optout. > > > > > > > > > > -- > > You received this message because you are subscribed to the Google Groups "ODK Developers" group. > > To unsubscribe from this group and stop receiving emails from it, send an email to opendatakit-developers+unsubscribe@googlegroups.com. > > > > > > > > > > > > > > For more options, visit https://groups.google.com/d/optout. > > > > > > > > -- > > You received this message because you are subscribed to a topic in the Google Groups "ODK Developers" group. > > To unsubscribe from this topic, visit https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe. > > > > > > > > > > > > To unsubscribe from this group and all its topics, send an email to opendatakit-developers+unsubscribe@googlegroups.com. > > For more options, visit https://groups.google.com/d/optout. > > > > > > > > > > > > -- > > You received this message because you are subscribed to the Google Groups "ODK Developers" group. > > To unsubscribe from this group and stop receiving emails from it, send an email to opendatakit-developers+unsubscribe@googlegroups.com. > > > > > > > > > > For more options, visit https://groups.google.com/d/optout. > > > > > > > > -- > > You received this message because you are subscribed to a topic in the Google Groups "ODK Developers" group. > > To unsubscribe from this topic, visit https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe. > > > > > > > > To unsubscribe from this group and all its topics, send an email to opendatakit-developers+unsubscribe@googlegroups.com. > > For more options, visit https://groups.google.com/d/optout. > > > > > > > > > > -- > > You received this message because you are subscribed to the Google Groups "ODK Developers" group. > > To unsubscribe from this group and stop receiving emails from it, send an email to opendatakit-developers+unsubscribe@googlegroups.com. > > > > > > > For more options, visit https://groups.google.com/d/optout. > > > > > -- > Mitch Sundt > Software Engineer > University of Washington > mitche...@gmail.com > > > > > > > > -- > > You received this message because you are subscribed to a topic in the Google Groups "ODK Developers" group. > > To unsubscribe from this topic, visit https://groups.google.com/d/topic/opendatakit-developers/7b3FohKkmRs/unsubscribe. > > > > > > To unsubscribe from this group and all its topics, send an email to opendatakit-developers+unsubscribe@googlegroups.com. > > For more options, visit https://groups.google.com/d/optout.