# Some math realtime when adding or editing row not in the Users table **URL:** \ **Category:** Ask for Help\ **Created:** [July 23, 2022, 5:07am UTC](https://community.glideapps.com/t/some-math-realtime-when-adding-or-editing-row-not-in-the-users-table/45066 "2022-07-23T05:07:42Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Garik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/garik/32/44224_2.png) [@Garik](https://community.glideapps.com/u/Garik)\ **Post date:** [July 23, 2022, 5:07am UTC](https://community.glideapps.com/t/some-math-realtime-when-adding-or-editing-row-not-in-the-users-table/45066/1 "2022-07-23T05:07:42Z")
Hi! You know, I’m making site for freelancers. I wanna do some calculation realtime when freelancer entering price for a new service. When he choose in select component 1000 I wanna show him final price 1250 in the text field below. The current table I edit is Services (not Users). Is it possible to do? ---
**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 23, 2022, 5:31am UTC](https://community.glideapps.com/t/some-math-realtime-when-adding-or-editing-row-not-in-the-users-table/45066/2 "2022-07-23T05:31:39Z")
Is this when adding a new service? You would need to use a custom form. - Write your service choice to a user specific column - Relate that choice to your list of services - Use a lookup to fetch the price - Use a math column to perform whatever the calculation is When a user submits, because it’s a custom form you would need to use an Add Row action to create the new row. ---
**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 23, 2022, 5:33am UTC](https://community.glideapps.com/t/some-math-realtime-when-adding-or-editing-row-not-in-the-users-table/45066/3 "2022-07-23T05:33:29Z")
Might help to see some screenshots. It’s definitely possible, but it depends which screen you are trying to do it on. ---
**Author:** ![Garik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/garik/32/44224_2.png) [@Garik](https://community.glideapps.com/u/Garik)\ **Post date:** [July 23, 2022, 5:36am UTC](https://community.glideapps.com/t/some-math-realtime-when-adding-or-editing-row-not-in-the-users-table/45066/4 "2022-07-23T05:36:03Z")
Thank you Darren. I will try it. ---
**Author:** ![Garik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/garik/32/44224_2.png) [@Garik](https://community.glideapps.com/u/Garik)\ **Post date:** [July 23, 2022, 5:38am UTC](https://community.glideapps.com/t/some-math-realtime-when-adding-or-editing-row-not-in-the-users-table/45066/5 "2022-07-23T05:38:12Z")
Thanks, Jeff. Darren is right. It’s possible if we are adding new Service from User’s table. ---
**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 23, 2022, 5:38am UTC](https://community.glideapps.com/t/some-math-realtime-when-adding-or-editing-row-not-in-the-users-table/45066/6 "2022-07-23T05:38:32Z")
Actually, just re-reading what you wrote - the price is being entered. So there is no need for the relation + lookup. All you need to do is write the entered price to a user specific column, and then do the math directly. The key is the user specific column, because the values are written as soon as they are entered, which means you can use them to perform calculations. With a native add form, you can’t do this because the new row isn’t created until the form is submitted. ---
**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:** [July 24, 2022, 5:39am UTC](https://community.glideapps.com/t/some-math-realtime-when-adding-or-editing-row-not-in-the-users-table/45066/7 "2022-07-24T05:39:23Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.