How can I make a calculated field on a form, which depends on the value of another field on the same form?

[nathanaelb]

You will need a custom form for that. The reason is, in a native form, the data you input in an entry field isn’t in the table until the users submits the form, it’s as if the data didn’t exist yet in your table, so you cannot work with it or run it through any computed columns.

Try custom forms:

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…