Logic performance and default values with 3 drop options

Fiaoni8

On my form- Field question "Attention Needed" has 3 options, "OK", "NEEDS ATTN", or "Out of service".

I have twelve subsequent fields that have options either "OK" or "NEEDS ATTN".

I am having a problem with the logic and performance of those answers, perhaps I have the structure set up wrong. If field question "attention needed" is "no" , I want the default value (OK) to populate the source sheet for all twelve, thereby stopping the answering of every question. If "Yes" attention is needed, then the default value can be changed to the "Needs ATTN." option.

If "Out of Service" is selected, leaving it blank is fine or having another option is fine.

The goal is to utilize the form as a electronic repository and then dashboard the results.. I do not want to select every question and answer it if I can get around it.

I am wanting the effected field to be influenced from my Attention Needed field question.

Above- if answered no, I want the form to submit all "OK"

Above, if yes, I want to change the value in the field questions

I want to populate the source data populate different.

KPH

To achieve your desired form, I think you might need to set up two duplicate versions of your 12 subsequent questions then use formula in your sheet to populate a 3rd set of subsequent questions using the data from the other columns.

Your columns would be something like this. The ones in bold will be your repository and the others can be hidden.

Field Question

Leaks

Leaks (if yes)

Leaks (if OOS)

Fuel System

Fuel System (if yes)

Fuel System (if OOS)

For your form logic

If field question "attention needed" is "no" you can use the logic to not offer the subsequent questions.

If field question "attention needed" is "yes" you can use the logic to collect data into the set of subsequent questions using the column Leaks (if yes), Field System (if yes), etc. and put "Needs ATTN" as the default.

If field question "attention needed" is "out of service" you can use the logic to collect data into the set of subsequent questions using the columns xxx (if OOS) without a default.

Then in the sheet you can set up formula in the columns you are going to keep: Leaks, Fuel system, etc.

For example in the Leaks column your formula logic would be

If [Field Question] is "No", return "OK".

If not, if "Leaks (if yes)" is blank, return the value in "Leaks (if OOS)"

If not, return the value in "Leaks (if yes)"

Then you have the values from each of the other columns, or "OK" in one column. You can copy this for each of the other 11 subsequent questions (if you have the columns in the right order you can drag the formula to the right and it will update the column names in the formula so you only have to type the formula once).

Make these column formulas.

Hide the other columns.

Hope this helps.

KPH

To achieve your desired form, I think you might need to set up two duplicate versions of your 12 subsequent questions then use formula in your sheet to populate a 3rd set of subsequent questions using the data from the other columns.

Your columns would be something like this. The ones in bold will be your repository and the others can be hidden.

Field Question

Leaks

Leaks (if yes)

Leaks (if OOS)

Fuel System

Fuel System (if yes)

Fuel System (if OOS)

For your form logic

If field question "attention needed" is "no" you can use the logic to not offer the subsequent questions.

If field question "attention needed" is "yes" you can use the logic to collect data into the set of subsequent questions using the column Leaks (if yes), Field System (if yes), etc. and put "Needs ATTN" as the default.

If field question "attention needed" is "out of service" you can use the logic to collect data into the set of subsequent questions using the columns xxx (if OOS) without a default.

Then in the sheet you can set up formula in the columns you are going to keep: Leaks, Fuel system, etc.

For example in the Leaks column your formula logic would be

If [Field Question] is "No", return "OK".

If not, if "Leaks (if yes)" is blank, return the value in "Leaks (if OOS)"

If not, return the value in "Leaks (if yes)"

Then you have the values from each of the other columns, or "OK" in one column. You can copy this for each of the other 11 subsequent questions (if you have the columns in the right order you can drag the formula to the right and it will update the column names in the formula so you only have to type the formula once).

Make these column formulas.

Hide the other columns.

Hope this helps.

Fiaoni8

I did think about the need for duplicates. Thanks for suggesting that, I will try it.

KPH

Good luck!