# Automatic Number Calculation
**URL:** https://community.glideapps.com/t/automatic-number-calculation/36374
**Category:** Ask for Help
**Created:** [December 27, 2021, 2:20am UTC](https://community.glideapps.com/t/automatic-number-calculation/36374 "2021-12-27T02:20:50Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@reninair](https://community.glideapps.com/u/reninair)
#### Post date: [December 27, 2021, 2:20am UTC](https://community.glideapps.com/t/automatic-number-calculation/36374/1 "2021-12-27T02:20:51Z")
I am building a lead generation app based on points system. So, for every leads purchased by the agents, their points will be deducted from their existing points that will be appointed to them every month. All of these are tabulated and solved. What I want to do next is,
Goal:
For the section with the form, I want to ensure that once the categories are filled up, the points redeemed will be auto-tabulated and displayed below to show the users the total points redeemed. How do I go about it?
Thank you.
---
### Author:  [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)
#### Post date: [December 27, 2021, 2:24am UTC](https://community.glideapps.com/t/automatic-number-calculation/36374/2 "2021-12-27T02:24:13Z")
Hola @reninair
Welcome to the community!!!
Search for @Robert_Petitto’s gamified app tutorial and you’ll find your answer.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [December 27, 2021, 2:30am UTC](https://community.glideapps.com/t/automatic-number-calculation/36374/3 "2021-12-27T02:30:03Z")
> [@reninair](#):
>
> For the section with the form, I want to ensure that once the categories are filled up, the points redeemed will be auto-tabulated and displayed below to show the users the total points redeemed. How do I go about it?
Do you need these tabulated results to be displayed _before_ the form is submitted, or after?
---
### Author:  [@reninair](https://community.glideapps.com/u/reninair)
#### Post date: [December 27, 2021, 2:32am UTC](https://community.glideapps.com/t/automatic-number-calculation/36374/4 "2021-12-27T02:32:00Z")
before the form is submitted, because I want the users to know how much of points they are using.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [December 27, 2021, 2:39am UTC](https://community.glideapps.com/t/automatic-number-calculation/36374/5 "2021-12-27T02:39:42Z")
Okay, in that case you will need to use a [Custom Form](https://community.glideapps.com/t/how-do-i-create-a-custom-form/25014).
The problem with native forms is that the input values are only written to the underlying table when the form is submitted, so you cannot access them to perform any calculations prior to that. With a custom form, the input values are written to user specific columns as they are entered, and so you can “do stuff” with them.
The general approach:
- Create a details screen, and add whatever input components are required
- Target each of the input components at a user specific column
- Use those columns to do your calculations, and display the results
- When the form is submitted (you’ll need to add your own submit button), take the values in the user specific columns and use them to create a new row using an Add Row action.
---
### Author:  [@reninair](https://community.glideapps.com/u/reninair)
#### Post date: [December 27, 2021, 3:50am UTC](https://community.glideapps.com/t/automatic-number-calculation/36374/6 "2021-12-27T03:50:24Z")
I tried doing this but I’m not sure if I am doing it right, because, I am not able to see any auto tabulation before submitting the form.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [December 27, 2021, 3:53am UTC](https://community.glideapps.com/t/automatic-number-calculation/36374/7 "2021-12-27T03:53:16Z")
Okay. If you want help troubleshooting you’ll need to share some details - screen shots or a video that show how you’ve set it up.
---
### Author:  [@reninair](https://community.glideapps.com/u/reninair)
#### Post date: [December 27, 2021, 6:29am UTC](https://community.glideapps.com/t/automatic-number-calculation/36374/8 "2021-12-27T06:29:03Z")
so, this is the form. I want the total number of points to redeem based on the leads chosen to display below the quantity field, to show the user the amount of points they will redeem once the submission is done.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [December 27, 2021, 6:44am UTC](https://community.glideapps.com/t/automatic-number-calculation/36374/9 "2021-12-27T06:44:26Z")
This…
…tells me that you’re using a native form. As I already explained, that won’t work. You need to use a custom form. See below ⬇
> [@How do I create a custom form?](https://community.glideapps.com/t/how-do-i-create-a-custom-form/25014):
>
> I’m just dropping this here so I have something to refer people to when they ask. This is a simple concept app (copyable), that demonstrates the following techniques: Building custom forms for adding and editing list items (as an alternative to the native forms provided by Glide) Preventing duplicate new entries using [User Specific Columns](https://docs.glideapps.com/all/reference/data-editor/user-specific-columns) and [Relations](https://docs.glideapps.com/all/reference/data-editor/computed-columns/relation-column) Enforcing mandatory input items The use of visibility conditions and user specific booleans to control user flow There is nothing particula…
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [December 28, 2021, 6:47am UTC](https://community.glideapps.com/t/automatic-number-calculation/36374/10 "2021-12-28T06:47:58Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.