[14.0] Using value from Odoo Spreadsheet in Pivot report

Question

Hello
I know that it is possible to show value from pivot report in Odoo Spreadsheet, but is it possible to show value from Odoo Spreadsheet in pivot report?

Bertus Kruger · Answer

Yes....
I answered how to get values from a spreadsheet here:  https://www.odoo.com/forum/help-1/how-can-i-get-the-value-of-a-spreadsheet-from-python-or-javascript-201329 [1]
The missing step for you is to have a stored computed field on your model that gets the value from the spreadsheet and then you use the stored field on your pivot table.

[1] https://www.odoo.com/forum/help-1/how-can-i-get-the-value-of-a-spreadsheet-from-python-or-javascript-201329

İlgili Gönderiler	Cevaplar	Görünümler
Odoo Community v14 Slow on High-End Servers, Fast on i5/i7 PCs v14	0 Ağu 25	94
How to Managing Birthdate and Age in Odoo v14	1 Ağu 25	2041
Odoo14 alternative for Automated Translations through Gengo API module v14	1 Tem 25	2571
Update Initial Stock of Product using XMLRPC API [Odoo14] Çözüldü v14	2 Tem 25	8006
"AttributeError: 'NoneType' object has no attribute 'CompileError'" configuring document Layout - Odoo 14 v14	2 Tem 25	4457

Bu soru işaretlendi

Enjoying the discussion? Don't just read, join in!