Customer survey: best way to create form?

Need help App Organization
1

I need to create a simple customer survey form. Actually it is a drop down or radio bullet type, where the customer has to give a score ranging from 1 to 10.

However, I am trying to use this lay out:

image
image1107×161 16.1 KB

This makes it some more complex.
So the customer clicks his/her score, which becomes highlighted. Of course when he changes his mind, another score can be selected, and the previous selected one becomes unselected.
In the end I need to fill a (external SQL) table with the scores.

My questions:

  • what is a good way to unselect a score, when the customer changes its mind? The only thing I can come up with is a workflow per number, which unselects all other 9 numbers except itself. This seems a bit overkill.

  • how to send the selected score(s) to the table? If I were to use a simple dropdown menu with numbers 1-10 to select from, it would be easy . I can then just create a button and add a workflow that sends the input from the dropdown to the table. However, when using the preferred lay out, the selected number does not have an actual value. Or does it? Where do I “get” the number from?

2

Hi @cobee , Use repeating group and custom state to achieve this functionality.

  1. Create an option set called “score” with values 1-10. Keep this as the data source of the RG which will show numbers (1-10).
  2. Create a custom state called “selected_score”. When user clicks on a cell, update the custom state value with current cell’s score.
  3. Keep a condition on cell (number) to highlight if the current cell score is custom state’s score.
  4. When Form Submit is clicked, pass the custom states value to your DB.
3

Thanks, I had not come up with custom states for this problem. Will try it!