# Computed Columns are not updated for Show Form and Edit Form screens **URL:** \ **Category:** Ask for Help\ **Created:** [August 6, 2021, 1:53pm UTC](https://community.glideapps.com/t/computed-columns-are-not-updated-for-show-form-and-edit-form-screens/30105 "2021-08-06T13:53:04Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Maxim\_KM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxim_km/32/29274_2.png) [@Maxim\_KM](https://community.glideapps.com/u/Maxim_KM)\ **Post date:** [August 6, 2021, 1:53pm UTC](https://community.glideapps.com/t/computed-columns-are-not-updated-for-show-form-and-edit-form-screens/30105/1 "2021-08-06T13:53:04Z")
I have Template, IF-ELSE, Experimental Code columns in my table. None of them are refreshing in GUI. I mean I have “Create form” and when I am setting basic columns - it doesn’t update dependent controls. One example: I have 2 Choice controls “Hours” and “Minutes”, and a Template column that joins texts to “Start Time - HH:MM”. When I change Hours or minutes, Text control with Template value is not updated. Same when I edit row with Edit Form Screen. ---
**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:** [August 6, 2021, 1:57pm UTC](https://community.glideapps.com/t/computed-columns-are-not-updated-for-show-form-and-edit-form-screens/30105/2 "2021-08-06T13:57:47Z")
That’s because a form does not write any data to the table until you submit. It will not work in a form. You would be better off creating a custom form if you want to do calculations in real time. > [@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:** ![Maxim\_KM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxim_km/32/29274_2.png) [@Maxim\_KM](https://community.glideapps.com/u/Maxim_KM)\ **Post date:** [August 6, 2021, 2:12pm UTC](https://community.glideapps.com/t/computed-columns-are-not-updated-for-show-form-and-edit-form-screens/30105/3 "2021-08-06T14:12:48Z")
Yes, sad that computed columns are not computing in a state of limbo. Custom Forms will require doing a lot of things manually(such as controlling Required fields, no Cancel/Done buttons, etc.) ---
**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:** [August 6, 2021, 2:20pm UTC](https://community.glideapps.com/t/computed-columns-are-not-updated-for-show-form-and-edit-form-screens/30105/4 "2021-08-06T14:20:02Z")
Recategorizing this as this is not a bug. ---
**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:** [August 6, 2021, 3:08pm UTC](https://community.glideapps.com/t/computed-columns-are-not-updated-for-show-form-and-edit-form-screens/30105/5 "2021-08-06T15:08:18Z")
Yes, custom forms are more work, but provide a lot more functionality. If done correctly, you can still have a cancel or done button, and those buttons could be set to show only when all required values are filled. ---
**Author:** ![rayo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rayo/32/91372_2.png) [@rayo](https://community.glideapps.com/u/rayo)\ **Post date:** [December 14, 2022, 12:50pm UTC](https://community.glideapps.com/t/computed-columns-are-not-updated-for-show-form-and-edit-form-screens/30105/6 "2022-12-14T12:50:56Z")
can we show the form input somewhere else on the form before its is submit? Before the value is put into the column, is there any way we can call that value to make computations and show the user what he is about to do on submit? ---
**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:** [December 15, 2022, 12:23am UTC](https://community.glideapps.com/t/computed-columns-are-not-updated-for-show-form-and-edit-form-screens/30105/7 "2022-12-15T00:23:23Z")
No, the only way to have live calculation is a custom form. > [@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…