Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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 entry 2 int he 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? Thanks

click to hide/show revision 2
No.2 Revision

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: table.

Example: I have a table with three fields: fields:

  • FIELD 1 (INTEGER): First Quantity
  • FIELD 2 (INTEGER): Second Quantity Quantity
  • FIELD 3 (INTEGER): Result Result

So imagine the table, I am there... I entry 2 int he enter 2 in the first field (First Quantity), and now in the next field (Second Quantity) I type 2... 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 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? Thanks