Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 11 Dec 2013 15:52:34 +0100Can we have calculated fields in LibreOffice Base?https://ask.libreoffice.org/en/question/27032/can-we-have-calculated-fields-in-libreoffice-base/Hello
I'd like to know if can we have calculated fields in LibreOffice Base.
Please, realize I do not mean about getting the calculated fields when performing a query.
I mean, to get the calculated field during the entry data process whilst you are in the table.
Example: I have a table with three fields:
- FIELD 1 (INTEGER): First Quantity
- FIELD 2 (INTEGER): Second Quantity
- FIELD 3 (INTEGER): Result
So imagine the table, I am there... I enter 2 in the first field (First Quantity), and now in the next field (Second Quantity) I type 2 ... and now, what I want to see in the third field (Result) is the sum of First Quantity + Second Quantity, that is 2 + 2 = 4
May I have that whilst I am introducing data in the table, and get a field with calculated results?
Or the only way to get calculated results is when performing a query?
ThanksmrmisterWed, 11 Dec 2013 15:52:34 +0100https://ask.libreoffice.org/en/question/27032/