Sub-Questions Survey 123

Question

Hello,

I'm designing a vegetation survey form and I want to collect data on the percent cover by species. I want to create a form where the surveyor types a species that auto-populates from an excel list and can choose the correct species. Then I want a question to appear that asks for the percent cover of that species. I would like the surveyor to be able to add as few or as many species as they find to the list. So the questions would look like:

Species:
(Multiple Choice box - Drop down list of species from excel file) - + (add another species)

For every species listed a numeric question is created - Species name % cover

(Numeric box)

So it would look like this example

Species name

Dodonaea lobulata

Callitris glaucophylla

% Cover Dodonaea lobulata

8

% Cover Callitris glaucophylla

10

I greatly appreciate any help on this.

Thank you so much

Camill

LaurenceTait · Answer

I agree completely. This is exactly what repeats are intended for.

As a poor second choice, if you have a limited number of species at each site/quadrat, you could achieve this with a lot of conditions and calculations (see attached), but you will will likely have multiple blank fields at most sites. That will be less of a pain to process than what DougBrowning  was thinking, but much more difficult (and error prone) to construct than simply using a repeat.

Form 6.xlsx

select.GIF

dougbrowning · Answer

You would want to use a repeat for this.  I would not use a select multiple as the data is so hard to peal apart later.  Plus no real way to match up the cover.

I have a species form now that does this and checks for dups.  The list lets you pick common name, scientific name, or code also.  I can share them out but heading out for the week.  If you want it send me a message.  Lists can handle 60,000 or more.  If you list is small there are some other options.