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

Within a form, I ask the user how much of the product wants (red square). The next field (green square) must calculate the amount obtained from the value that user writes, multiplied by another value that I can obtain from the table or simply multiply it by a predefined value.

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:

1 Like