How to use conditions (if) in concat() function?

Support
1

Hello everybody,

I have a formula with a repeat select1 question.
I use indexed-repeat function to collect the answers and it works well.
At the end of the process i want to concat all the answers in a text field
in read only, to show the user a summary of his answers before the
validation.

I concat well all my indexed-repeat but i have 1 to 20 answers and i don't
know how to concat only the not blank answers.
Can i use If, or my count af answers in repeat to concat only real answers ?
Can you give a syntax example ?

In advance thanks for all your ideas.
Thanks t the team for this incredible tool,

Rémy

2

Hi,
I can help you if you share with me a piece of your work.

··· On Mar 18, 2015 3:51 PM, "Rémy CLEMENT" wrote:

Hello everybody,

I have a formula with a repeat select1 question.
I use indexed-repeat function to collect the answers and it works well.
At the end of the process i want to concat all the answers in a text field
in read only, to show the user a summary of his answers before the
validation.

I concat well all my indexed-repeat but i have 1 to 20 answers and i don't
know how to concat only the not blank answers.
Can i use If, or my count af answers in repeat to concat only real answers
?
Can you give a syntax example ?

In advance thanks for all your ideas.
Thanks t the team for this incredible tool,

Rémy

--

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

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

3

Hello,
Thanks for your answer, I put my file here to show you.
In order :

  • Select1 repeat (with text search but we don't care here)
  • indexed_repeat to catch all the input values
  • text to show a synthetic liste of the inputs with ther numeric order.

I don't know how to resolve this final step
In advance thanks for your help,
Rémy

concatonindexedrepeat.xls (49.5 KB)

··· Le vendredi 20 mars 2015 04:01:47 UTC+1, Legarraudien a écrit : > > Hi, > I can help you if you share with me a piece of your work. > On Mar 18, 2015 3:51 PM, "Rémy CLEMENT" <enrcl...@gmail.com > wrote: > >> Hello everybody, >> >> I have a formula with a repeat select1 question. >> I use indexed-repeat function to collect the answers and it works well. >> At the end of the process i want to concat all the answers in a text >> field in read only, to show the user a summary of his answers before the >> validation. >> >> I concat well all my indexed-repeat but i have 1 to 20 answers and i >> don't know how to concat only the not blank answers. >> Can i use If, or my count af answers in repeat to concat only real >> answers ? >> Can you give a syntax example ? >> >> In advance thanks for all your ideas. >> Thanks t the team for this incredible tool, >> >> Rémy >> >> -- >> -- >> Post: opend...@googlegroups.com >> Unsubscribe: opendatakit...@googlegroups.com >> Options: http://groups.google.com/group/opendatakit?hl=en >> >> --- >> You received this message because you are subscribed to the Google Groups >> "ODK Community" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to opendatakit...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> >
4

Hi Clement,
I think that your problem can be solved by using the variable filter.

  1. Add a variable (var) before the repeat group that indicates the
    number of species or you can use a boolean variable in the repeat group in
    order to calculate the number of species. If the variable has been added
    before the repeat group, you have to put the number of repeat equal to the
    variable added
  2. In the coloumn choice_filter , put in each line in your calculated
    variable especei, filter<=${var}
  3. And you will concat only the not blank line of species.

Try this and let me know

I speak french and tyou write me coments in my personnal email.

Pierre

··· 2015-03-20 4:10 GMT-07:00 Rémy CLEMENT :

Hello,
Thanks for your answer, I put my file here to show you.
In order :

  • Select1 repeat (with text search but we don't care here)
  • indexed_repeat to catch all the input values
  • text to show a synthetic liste of the inputs with ther numeric order.

I don't know how to resolve this final step
In advance thanks for your help,
Rémy

Le vendredi 20 mars 2015 04:01:47 UTC+1, Legarraudien a écrit :

Hi,
I can help you if you share with me a piece of your work.
On Mar 18, 2015 3:51 PM, "Rémy CLEMENT" enrcl...@gmail.com wrote:

Hello everybody,

I have a formula with a repeat select1 question.
I use indexed-repeat function to collect the answers and it works well.
At the end of the process i want to concat all the answers in a text
field in read only, to show the user a summary of his answers before the
validation.

I concat well all my indexed-repeat but i have 1 to 20 answers and i
don't know how to concat only the not blank answers.
Can i use If, or my count af answers in repeat to concat only real
answers ?
Can you give a syntax example ?

In advance thanks for all your ideas.
Thanks t the team for this incredible tool,

Rémy

--

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

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

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

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