Concatenation help: Concatenate multiple choices into a single word

List of choices then concatenation of the different choices selected

Hello, I would like from a list of multiple choices, select the type of crops (speculation) that have been associated with a main crop, then for each of them, define the production, and finally calculate the yield.

After selecting the crop types, I would like to know how to concatenate the different choices, i.e. A+B+C
A= Main crop
B= Secondary crop associated with main crop “A”
C= 2nd secondary culture associated with culture “A”

Sample quiz:
I- MAIN CULTURE
A- What main crop was grown? (Single Choice)
1- lowland rice
2- upland rice
3- corn
4- cassava
B- What is the production of the selected crop?
C- What is the area (Length) of the selected crop?
D- What is the area (Width) of the selected crop?
E- Calculation of the total area of ​​the plot on which the main crop was developed (in Ha)
(LengthXWidth)/10.000
F- What is the yield of the main culture developed?

II- ASSOCIATED CULTURE (SECONDARY)
A- What associated (secondary) culture was carried out? (Multiple choice)
1- Peanut
2 - Green soy
3 - Bean
4 -Other, specify

B- What is the production of the selected crop(s)?
Nb: for each crop, enter the production in Kg

F- What is the yield of the selected crop(s)?
G- Are you satisfied with each of your productions?

III- CONCATENATION
innovative and agro-ecological practices is: Choice of main crop + choice of secondary crop (1+2+3)
example: Upland rice - Groundnut - Green soybean
culture association essay.xlsx (11.1 KB)

List of choices then concatenation of the different choices selected

Hello, I would like from a list of multiple choices, select the type of crops (speculation) that have been associated with a main crop, then for each of them, define the production, and finally calculate the yield.

After selecting the crop types, I would like to know how to concatenate the different choices, i.e. A+B+C
A= Main crop
B= Secondary crop associated with main crop “A”
C= 2nd secondary culture associated with culture “A”

Sample quiz:
I- MAIN CULTURE
A- What main crop was grown? (Single Choice)
1- lowland rice
2- upland rice
3- corn
4- cassava
B- What is the production of the selected crop?
C- What is the area (Length) of the selected crop?
D- What is the area (Width) of the selected crop?
E- Calculation of the total area of ​​the plot on which the main crop was developed (in Ha)
(LengthXWidth)/10.000
F- What is the yield of the main culture developed?

II- ASSOCIATED CULTURE (SECONDARY)
A- What associated (secondary) culture was carried out? (Multiple choice)
1- Peanut
2 - Green soy
3 - Bean
4 -Other, specify

B- What is the production of the selected crop(s)?
Nb: for each crop, enter the production in Kg

F- What is the yield of the selected crop(s)?
G- Are you satisfied with each of your productions?

III- CONCATENATION
innovative and agro-ecological practices is: Choice of main crop + choice of secondary crop (1+2+3)
example: Upland rice - Groundnut - Green soybean

List of choices then concatenation of the different choices selected

Hello, I would like from a list of multiple choices, select the type of crops (speculation) that have been associated with a main crop, then for each of them, define the production, and finally calculate the yield.

After selecting the crop types, I would like to know how to concatenate the different choices, i.e. A+B+C
A= Main crop
B= Secondary crop associated with main crop “A”
C= 2nd secondary culture associated with culture “A”

Sample quiz:
I- MAIN CULTURE
A- What main crop was grown? (Single Choice)
1- lowland rice
2- upland rice
3- corn
4- cassava
B- What is the production of the selected crop?
C- What is the area (Length) of the selected crop?
D- What is the area (Width) of the selected crop?
E- Calculation of the total area of ​​the plot on which the main crop was developed (in Ha)
(LengthXWidth)/10.000
F- What is the yield of the main culture developed?

II- ASSOCIATED CULTURE (SECONDARY)
A- What associated (secondary) culture was carried out? (Multiple choice)
1- Peanut
2 - Green soy
3 - Bean
4 -Other, specify

B- What is the production of the selected crop(s)?
Nb: for each crop, enter the production in Kg

F- What is the yield of the selected crop(s)?
G- Are you satisfied with each of your productions?

III- CONCATENATION
innovative and agro-ecological practices is: Choice of main crop + choice of secondary crop (1+2+3)
example: Upland rice - Groundnut - Green soybean
culture association essay.xlsx (11.1 KB)

Maybe you could handle this much better with a matrix quesation.

Okay! Could you please guide me more on this possibility? how should I go about it based on the example I provided? Please ??

OK, your first section is simple and can be created normally without any issue.

Regarding your second section, II - ASSOCIATED CULTURE (SECONDARY) you will need to use the matrix question to design your survey form more easily. Maybe our support article Question Matrix Response Type should help you design your survey form in a matrix design. But please note that this is only supported with web forms and you will not be able to use the same in a `Collect android app`.