Mathematical formulas in collections


Hi,
Is it possible to add a mathematical formula to the collections to automatically calculate the amount between the initial balance and the final balance? I want my employees to check if their final balance matches the one in the application.that is, after they enter the initial balance and the final balance, their final balance will be automatically calculated.

Yes, it’s really easy when your values are on the same row which looks like they would be base on the form you are showing. It would just be a simple subtraction in a Math column I assume.

I have a math column in data editor, but i need it to be in collection and I don t know how to do that… can you show me pls?

I don’t know what you mean by a collection. You can show the value from a math column in a collection, so I must be missing something.


In this screenshot you can see that I entered values ​​for the initial balance and the final balance, I want the sum of them to be automatically calculated here (where it says total balance) so that the employee can see it directly when he enters, but I don’t know if it’s possible… .

OK, that looks like a form, not a collection. Also, you weren’t showing the total balance field in your first screenshot and mentioned that you wanted to calculate the final balance…not the total balance. So, I was a little confused by your question.

First of all, can you confirm that the screen you are showing is a Form or an Edit screen? Are you adding a new row or editing an existing row? Does it have Submit/Cancel buttons at the bottom? If it is a form, you can’t perform calculations in real time because the calculations only occur once the row is added to the table. That only happens when you click on Submit. Also, you will not be able to show a computed value in an entry component, because the entry component is meant for user entry…not for displaying computed values…so you would need a regular text component.

If you want to calculate values in a form in real time, you will need to use a custom form, but it will cost you additional updates.

Screenshots that show the entire screen are a lot more useful that cropped images because there is a lot of sub context that I can obtain from other parts of your screenshot that you may not realize are important.

2 Likes

Thank you, I understand… I’m sorry if I misled you, but I’m new here and still learning. :sweat_smile:

1 Like