Survey123 - Trying to pull data of previous answer

Question

Hello,

I was building a survey and wondered if I could do the following:

I have a select_one which determiens a type of object I will be capturing information from

* if I select object_1, then I'll be collecting some info with items such as object_1_characteristic_1, object_1_characteristic_2, object_1_characteristic_3, etc
* if I select object_2, then I'll be collecting some info with items such as object_2_characteristic_1, object_2_characteristic_2, object_2_characteristic_3, etc

There is a relevant ${object} = 'object_1' for example, so that only the relevant question and answers for each object appear.

My question is, is there a way to have a note at the bottom, that will capture a different data captured earlier?

Ideally, I wanted to have something like $(TYPE_OF_OBJECT_characteristic_1), where the TYPE_OF_OBJECT is a variable (object_1, object_2...). However, it seems that these placeholder values after a dollar sign do not accept a variable string inside, only a hardcoded one.

Do you think is there a way I could have a sort of $(VARIABLE_DATA_HERE) type of placeholder, where the data is selected based on a previous select_one question?

Thanks a lot,

dougbrowning · Answer

You could try to put the concat in its own field then use that field in the pulldata.  But I am not sure you can pulldata on a form you have open.

Another idea is to make the labels dynamic instead.  So you have field_1, 2, 3 for the name column then put a calc in label to show the user what name you want to show the user.  I think you can put ${field} in a label.

constellationshire · Answer

Here is an example of what I want to achieve:

Let's say I have this survey:

And my choices:

And the extra .csv to look what the actual questions are, since I cannot query the labels or hints with a formula:

The way this would work, is that I choose what type of component I want, and depending on that a series of attributes for each component will appear.

All of the "text" fields have a "null" bind::esri:fieldType so that they do not get captured on the survey.

I want, however, to capture the responses using a calculation.

1. Regarding the questions, it's easy because I can make a database and then run a pulldata based on a variable input (which changes based on the select_component)

2. Regarding, the answer, I cannot make something like ${VALUED IS BASED IN ${PREVIOUS VARIABLE}} type of field.

The workaround is to concatenate all the answers, each answer from a different component, what will result in the concantenation of empty strings and the string I want.

The reason I was looking at this approach is that I have a very large databse of objects and characteristics and I am running into the approximately 500 column limit, but a given component usually has 10-20 attributes to be recorded. If I can reconstruct the  questions and answer with a calculation, that would be great.

EDIT: wrong pics posted

dougbrowning · Answer

No a field name cannot be dynamic like that in almost all programming languages.

Only idea is to use if.  Something like if(object_1 selected, use object1, if(object_2, use object 2, etc.  You could put this is a calculate type field then use that field for the rest of the form.

So your form would have a new field like "DataToUse" and it has the if calc above.  That way it always has the data you want in it.  Then just use this "DataToUse" for the rest of the form.

Hope that works