# Using a Form to add a value to table

**URL:** https://community.glideapps.com/t/using-a-form-to-add-a-value-to-table/41143
**Category:** Ask for Help
**Created:** [April 23, 2022, 7:37pm UTC](https://community.glideapps.com/t/using-a-form-to-add-a-value-to-table/41143 "2022-04-23T19:37:52Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Francisco\_Marmolejo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/francisco_marmolejo/32/41552_2.png) [@Francisco\_Marmolejo](https://community.glideapps.com/u/Francisco_Marmolejo)
#### Post date: [April 23, 2022, 7:37pm UTC](https://community.glideapps.com/t/using-a-form-to-add-a-value-to-table/41143/1 "2022-04-23T19:37:52Z")

</div>

I am trying to make a checkout system that can have multiple items of the same type that can be checkedout and returned. For example: A user can checkout or return 3 HDMI cables.

I need to find a way to tie in a check out and return button with the user, and having the value of how many items are checked out or returned to reflect the change on the Item sheet.

 ![Screen Shot 2022-04-23 at 12.19.27 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/7/576028eb7a18574a21d52a6cd0f4e741098261a1.png)

I made a form that a user can enter information and it captures it on a sheet, the only thing that I need help is writing the formulas or columns to refelect the items entered and having it change how many items available or in stock that are on a different sheet.  
Anyone have any thoughts?

---

<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: [April 24, 2022, 3:14am UTC](https://community.glideapps.com/t/using-a-form-to-add-a-value-to-table/41143/2 "2022-04-24T03:14:53Z")

</div>

I think you can set up a relation to the table/row you want to make the increment/decrement and use an on-submit action to make the needed change.

Another option is to use a rollup on all checkin/checkout quantities and use a math column to derive the final number to show to the user.