Computed Columns are not updated for Show Form and Edit Form screens

[Maxim_KM]

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.

[Jeff_Hager]

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?

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 and Relations Enforcing mandatory input items The use of visibility conditions and user specific booleans to control user flow There is nothing particula…

[Maxim_KM]

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.)

[ThinhDinh]

Recategorizing this as this is not a bug.

[Jeff_Hager]

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.

[rayo]

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?

[ThinhDinh]

No, the only way to have live calculation is a custom form.

How do I create a custom form?

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 and Relations Enforcing mandatory input items The use of visibility conditions and user specific booleans to control user flow There is nothing particula…