You can’t perform calculations in a form because none of the data gets submitted to the table until you click on submit. I recommend creating a custom form that would allow you to do this.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| How can I make a calculated field on a form, which depends on the value of another field on the same form? | 1 | 301 | November 1, 2023 | |
| Displaying Calculating value | 3 | 811 | March 7, 2022 | |
| About Math Column | 6 | 434 | March 7, 2023 | |
| Formula in a form? | 1 | 172 | February 8, 2024 | |
| I need to calculate the total amount before submitting the data | 3 | 118 | June 6, 2024 |