# 🤔 How to: Efficiently get real time calculation sum while from text entry components (w/ pic) **URL:** \ **Category:** Ask for Help\ **Created:** [July 8, 2023, 10:15pm UTC](https://community.glideapps.com/t/how-to-efficiently-get-real-time-calculation-sum-while-from-text-entry-components-w-pic/63684 "2023-07-08T22:15:27Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![JamieErvin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jamieervin/32/57900_2.png) [@JamieErvin](https://community.glideapps.com/u/JamieErvin)\ **Post date:** [July 8, 2023, 10:15pm UTC](https://community.glideapps.com/t/how-to-efficiently-get-real-time-calculation-sum-while-from-text-entry-components-w-pic/63684/1 "2023-07-08T22:15:27Z")
Hello! I have a numbers column that the user needs to update and see the calculation result in real time. Currently from the Edit screen (if that part correct) I have to input the number, hit submit and go back into the row. Is there a more efficient way accomplish this? Thanks. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/9/b9b4714e577601c1ded98ee93f9f11673d030158.png) ---
**Author:** ![Hassan\_Nadeem](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hassan_nadeem/32/72956_2.png) [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)\ **Post date:** [July 8, 2023, 11:55pm UTC](https://community.glideapps.com/t/how-to-efficiently-get-real-time-calculation-sum-while-from-text-entry-components-w-pic/63684/2 "2023-07-08T23:55:17Z")
Instead of showing the edit screen, set the action to “Show new screen” and add all these components on the new screen. You will be able to see the results in real time. ---
**Author:** ![JamieErvin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jamieervin/32/57900_2.png) [@JamieErvin](https://community.glideapps.com/u/JamieErvin)\ **Post date:** [July 9, 2023, 12:40am UTC](https://community.glideapps.com/t/how-to-efficiently-get-real-time-calculation-sum-while-from-text-entry-components-w-pic/63684/3 "2023-07-09T00:40:29Z")
> [@Hassan\_Nadeem](#): > > Instead of showing the edit screen Thanks for the response. Can you clarify “showing” with that reply? In this pic the components are in a Form Container. Doesn’t “Show new screen” come into play after creating an action first? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [July 9, 2023, 1:15am UTC](https://community.glideapps.com/t/how-to-efficiently-get-real-time-calculation-sum-while-from-text-entry-components-w-pic/63684/4 "2023-07-09T01:15:36Z")
You said you are viewing an Edit Screen. Which action did you use to get to that screen? Computed columns don’t work on Add/Edit screens because data isn’t written to the table until after you submit the form. However, Detail/New screens write data to the table in real time as you type, so computed columns should work. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [July 9, 2023, 1:17am UTC](https://community.glideapps.com/t/how-to-efficiently-get-real-time-calculation-sum-while-from-text-entry-components-w-pic/63684/5 "2023-07-09T01:17:28Z")
Perhaps a “hybrid form” could work here depending on how many calculations you’re wanting to display? > [@Radar Address Complete in Form](https://community.glideapps.com/t/radar-address-complete-in-form/63658/8): > > Here’s one example of a “Hybrid Form” in Glide: Kind of a combination of a [form screen](https://www.glideapps.com/docs/guides/other/forms) and a [custom form](https://community.glideapps.com/t/how-do-i-create-a-custom-form/25014). The setup: Helper Table for the form Show New Screen → Helper Table (Or Show Detail Screen → Single Value → Helper Table → Whole Row ) Entry components → User Specific columns for any entry that needs live relations/lookups/calculations Form Container to finish off the form experience After Submit Action → Close Overlay/Show Notification/Etc. ---
**Author:** ![JamieErvin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jamieervin/32/57900_2.png) [@JamieErvin](https://community.glideapps.com/u/JamieErvin)\ **Post date:** [July 9, 2023, 3:16am UTC](https://community.glideapps.com/t/how-to-efficiently-get-real-time-calculation-sum-while-from-text-entry-components-w-pic/63684/6 "2023-07-09T03:16:31Z")
Thanks for the reply. I keep reading the phrase “Helper Table” but I don’t see that as a component. Where do I find that? ---
**Author:** ![JamieErvin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jamieervin/32/57900_2.png) [@JamieErvin](https://community.glideapps.com/u/JamieErvin)\ **Post date:** [July 9, 2023, 3:20am UTC](https://community.glideapps.com/t/how-to-efficiently-get-real-time-calculation-sum-while-from-text-entry-components-w-pic/63684/7 "2023-07-09T03:20:06Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/a/1ae240665328632977cdcc88b3761f2d0106dd93.png) Got it. I have a Custom Screen with a Collection Table. I click on the three dots and that gives me the Edit screen that takes me to the view of my previous picture. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [July 9, 2023, 4:09am UTC](https://community.glideapps.com/t/how-to-efficiently-get-real-time-calculation-sum-while-from-text-entry-components-w-pic/63684/8 "2023-07-09T04:09:19Z")
> [@JamieErvin](#): > > Helper Table A helper table is nothing more than a regular data table. The only difference is that it really isn’t meant to store data long term. It can be a single row used for a custom form, or it can be multiple rows that dynamically calculate based on some input from the user. Personally, I call them work tables because they are meant to do work as opposed to storing data. It’s a way to execute code in a no-code environment. > [@JamieErvin](#): > > click on the three dots and that gives me the Edit screen Yeah like I said, if you are inside an Add/Edit/Form as opposed to a detail screen, then computed columns won’t give results until the form is submitted. ---
**Author:** ![JamieErvin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jamieervin/32/57900_2.png) [@JamieErvin](https://community.glideapps.com/u/JamieErvin)\ **Post date:** [July 10, 2023, 3:00am UTC](https://community.glideapps.com/t/how-to-efficiently-get-real-time-calculation-sum-while-from-text-entry-components-w-pic/63684/9 "2023-07-10T03:00:53Z")
Roger that! So to set up the Helper Table for me to calculate what are the steps for that? Starting with a container on the left side and adding a table from the Style on the right side? Sorry for all the questions, just getting into GlideApps. ---
**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:** [July 10, 2023, 3:04am UTC](https://community.glideapps.com/t/how-to-efficiently-get-real-time-calculation-sum-while-from-text-entry-components-w-pic/63684/10 "2023-07-10T03:04:14Z")
A Helper Table is something you create in the Data Editor, not the Layout. Go to the Data Editor, click the `+` to create a new table, and go from there… ![CleanShot 2023-07-10 at 11.02.21@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/f/af12b711c47a606bb5bc39858a02cd2e27390f60.png) ---
**Author:** ![JamieErvin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jamieervin/32/57900_2.png) [@JamieErvin](https://community.glideapps.com/u/JamieErvin)\ **Post date:** [July 10, 2023, 3:16am UTC](https://community.glideapps.com/t/how-to-efficiently-get-real-time-calculation-sum-while-from-text-entry-components-w-pic/63684/11 "2023-07-10T03:16:24Z")
Thanks a million for the follow up. Seeing “Table” on the right side is what was throwing me off. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/7/f7df50f1204450d905f7546ddd73fbae7cdc5b5c.png) Totally appreciate the help, sir!