Autopopulate Answers

mfroe17

Hello,

I am creating a survey that asks about the use of different facilities and it is possible that some respondents will use the same facility for different things. Is there a way for someone to click that the responses for the first set of questions are the same for the next facility's questions?

I am hoping it would function similar to if someone typed in a Billing Address, they could indicate that it is the same as their Shipping Address and therefore autopopulates the same address.

Thank you in advance!

KPH

You could do this by adding a checkbox to your sheet and duplicating your second set of questions.

Set up form logic so that if the box is checked, the second set of questions does not appear.

Then in your sheet, you need 2 sets of columns for the second set of questions (i.e. two delivery address columns). One set would be populated by the form (and can be hidden). The other would contain a column formula that would use an IF function to return the values from the first set of questions (billing address) if the box is checked, and return the data from the hidden columns if not.

I hope that makes sense.

KPH

You could do this by adding a checkbox to your sheet and duplicating your second set of questions.

Set up form logic so that if the box is checked, the second set of questions does not appear.

Then in your sheet, you need 2 sets of columns for the second set of questions (i.e. two delivery address columns). One set would be populated by the form (and can be hidden). The other would contain a column formula that would use an IF function to return the values from the first set of questions (billing address) if the box is checked, and return the data from the hidden columns if not.

I hope that makes sense.