Geotechnical Boring

GilHamilton

I'm looking to create a line of questioning in survey123 for geotechnical borings. 

1. Depth of Sample

 This is reported in a range (4-8 feet). Is it possible to have a slider that allows for a min and max value? Alternatively, a drop-down question could be used - values to be selected could be calculated based on total depth of the boring divided by the depth of each unit. This is not preferable as majority of borings are divided into 4-foot sections and typically don't terminate at depth that's divisible by 4. 

Ideally this data would then prompt a series of questions afterwards so that each Sample (4-foot segment) has a data attributed to it.

 2. Subsurface characteristics

This is pretty straightforward content wise. This is a whole line of questioning, but it needs to be prompted by and linked to the first answer. What's the best way of linking the original question to this line of questioning?

Finally, what's the best way of getting and saving separate responses for the first question and subsequent line of questioning? 

The end goal of this to be able to produce boring logs automatically. In my mind the first question would create a row, and the subsequent questions would fill out the columns. 

Any and all advice, ideas, solutions, or workflows is greatly appreciated. I'm currently working in survey123, and I think it's time to make the jump to connect.

 

 

abureaux

Tried this, but didn't have nearly enough time. Days are way too busy now. Also, field staff decided they absolutely needed to see BH logs in the field. As a result, we are exploring other software for BH logs. That said, I have looked into this before, and the data collection portion isn't much more complicated than a standard project type.

From your description, sounds like you are asking about showing content conditionally, and repeats.

Is it possible to have a slider that allows for a min and max value?

Do you mean a single slider for both min and max? No.

As for sliders in general: select_multiple (type) with the rank appearance could work since you have such a small range. Or range (type) with some formatting in the body::esri:style (e.g., startColor=White endColor=Orange color=#FF6347) and parameters (e.g., start=60 end=140 step=5) columns

I'd probably keep it simple and use decimal (type) and numbers (appearance).

Ideally this data would then prompt a series of questions afterwards so that each Sample (4-foot segment) has a data attributed to it.

You can conditionally show content using the relevant or body::esri:visible columns. They work the exact same, except body::esri:visible content is invisible, which preserves question content, whereas relevant becomes null and essentially disappears from the survey, which clears question content. Both have their advantages. body::esri:visible is really good when you have field techs accidentally hitting buttons, but then you need to deal with non-null content in the output.

What's the best way of linking the original question to this line of questioning?

See paragraph above. Alternatively, repeats. Honestly, not 100% sure on your requirement here.

what's the best way of getting and saving separate responses for the first question and subsequent line of questioning?

Repeats.

The end goal of this to be able to produce boring logs automatically. In my mind the first question would create a row, and the subsequent questions would fill out the columns.

Depending on your complexity, this could work. Good luck.