# Insert multiple value

**URL:** https://community.glideapps.com/t/insert-multiple-value/72685
**Category:** Ask for Help
**Created:** [April 18, 2024, 7:59am UTC](https://community.glideapps.com/t/insert-multiple-value/72685 "2024-04-18T07:59:26Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![mgalihm](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mgalihm/32/73257_2.png) [@mgalihm](https://community.glideapps.com/u/mgalihm)
#### Post date: [April 18, 2024, 7:59am UTC](https://community.glideapps.com/t/insert-multiple-value/72685/1 "2024-04-18T07:59:26Z")

</div>

I have component, let say entry number. How can I insert multiple value from one component to one column everytime I input the number? or I use action on the button?

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [April 18, 2024, 8:06am UTC](https://community.glideapps.com/t/insert-multiple-value/72685/2 "2024-04-18T08:06:51Z")

</div>

Can you explain what you mean by multiple values in this case?  
Do you want to create an array?  
A joined list?  
Something else?  
Let’s say I am the user, and I enter the number 7.  
What should be saved in the column?

---

<div class="post-metadata">

### Author: ![mgalihm](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mgalihm/32/73257_2.png) [@mgalihm](https://community.glideapps.com/u/mgalihm)
#### Post date: [April 18, 2024, 8:12am UTC](https://community.glideapps.com/t/insert-multiple-value/72685/3 "2024-04-18T08:12:48Z")

</div>

if the user entered 7, it saved 7 in the column. But when the user enter again 8, the value saved in the column will change to 8. I want to when the user enter the number, it will plus the number entered before

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [April 18, 2024, 8:18am UTC](https://community.glideapps.com/t/insert-multiple-value/72685/4 "2024-04-18T08:18:57Z")

</div>

I see. So every time the user enters a number you want it added to the current value to produce a new result.

So start by entering 7, result is 7.  
Then enter 8, new result is 15.  
Enter 8 again, new result is 23.

Yes?

---

<div class="post-metadata">

### Author: ![mgalihm](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mgalihm/32/73257_2.png) [@mgalihm](https://community.glideapps.com/u/mgalihm)
#### Post date: [April 18, 2024, 8:28am UTC](https://community.glideapps.com/t/insert-multiple-value/72685/5 "2024-04-18T08:28:26Z")

</div>

Absolutely yes

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [April 18, 2024, 8:42am UTC](https://community.glideapps.com/t/insert-multiple-value/72685/6 "2024-04-18T08:42:12Z")

</div>

Okay, sure.

You will need 3 columns in your table:

- A number column, to hold the result
- Another number column, to hold the entered value. This one should be user specific.
- A math column, to add the two number columns together.

On your screen, add your number input component and target it at the user specific number column.  
Then add a button for submitting the value, and configure a custom action with two steps:

- The first step should be a Set Column Values action. It should take the result of the math column and write it to the first number column.
- The second step will also be a Set Column Values action, but this one should clear the value in the user specific column, so it is ready for the next input.

---

<div class="post-metadata">

### Author: ![mgalihm](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mgalihm/32/73257_2.png) [@mgalihm](https://community.glideapps.com/u/mgalihm)
#### Post date: [April 18, 2024, 8:53am UTC](https://community.glideapps.com/t/insert-multiple-value/72685/7 "2024-04-18T08:53:59Z")

</div>

Thanks for your help

---

<div class="post-metadata">

### Author: ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)
#### Post date: [April 25, 2024, 8:54am UTC](https://community.glideapps.com/t/insert-multiple-value/72685/8 "2024-04-25T08:54:58Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
