# How to combine responses from multiple choice inputs into a single view

**URL:** https://community.glideapps.com/t/how-to-combine-responses-from-multiple-choice-inputs-into-a-single-view/10440
**Category:** Ask for Help
**Created:** [June 7, 2020, 12:47pm UTC](https://community.glideapps.com/t/how-to-combine-responses-from-multiple-choice-inputs-into-a-single-view/10440 "2020-06-07T12:47:12Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Praveen\_Kumar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/praveen_kumar/32/8748_2.png) [@Praveen\_Kumar](https://community.glideapps.com/u/Praveen_Kumar)
#### Post date: [June 7, 2020, 12:47pm UTC](https://community.glideapps.com/t/how-to-combine-responses-from-multiple-choice-inputs-into-a-single-view/10440/1 "2020-06-07T12:47:12Z")

</div>

Hi All,

I’m working on a medical app to do the following stuff:

1. Create new patients record (basic demographics)- Done
2. Record their diagnosis- Done (via a choice component of pre-decided diseases)
3. Input Prescription like Medicine Name (e.g. Paracetamol), Dose Quantity (e.g. 1 tab), Dose Timings (e.g. Morning only OR Morning + Evening) - Done (via 3 choice components for each medicine)

Let’s say, I allow a max of 5 medicines to be prescribed. So, there are 5 \* 3 (1 each for medicine name, dose quantity and dose timing) = 15 choice components required and hence 15 columns to store these values.

All of these data can be added while creating a new patient’s record (i.e. Basic demo + Diagnosis + Prescription). All this is working fine so far.

What’s the Problem?  
How can I see all this prescription values info as a single readable text box or a table? Is there any way to combine all the values from these choice components. Something like this-

Prescription (Title)

1. Med-1 | Quantity | Timing
2. Med-2 | Quantity | Timing  
…and so on…

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 7, 2020, 12:56pm UTC](https://community.glideapps.com/t/how-to-combine-responses-from-multiple-choice-inputs-into-a-single-view/10440/2 "2020-06-07T12:56:57Z")

</div>

Have a template column to do that for you, and add some HTML format to make it readable, I think.

E.g: In the template column type

```
Med-1 | Quantity1 | Timing1 <BR>
Med-2 | Quantity2 | Timing2 <BR>

```

And replace the Med-1, … by their respective columns. `<BR>` is for a new line.

Then display it in a rich text component.

---

<div class="post-metadata">

### Author: ![Praveen\_Kumar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/praveen_kumar/32/8748_2.png) [@Praveen\_Kumar](https://community.glideapps.com/u/Praveen_Kumar)
#### Post date: [June 7, 2020, 1:33pm UTC](https://community.glideapps.com/t/how-to-combine-responses-from-multiple-choice-inputs-into-a-single-view/10440/3 "2020-06-07T13:33:58Z")

</div>

Thanks! Yes, It worked in a crude way. One problem is the numeric values for quantity like 0.5, 1, 1.5 are appearing in date-time form i.e. 1899-12-31T00:00:00.000Z

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 7, 2020, 1:36pm UTC](https://community.glideapps.com/t/how-to-combine-responses-from-multiple-choice-inputs-into-a-single-view/10440/4 "2020-06-07T13:36:24Z")

</div>

Make sure in your editor it is storing as a number column. Can you verify it, do you accidentally store it as a datetime column?
