Can I update data in an Odoo Spreadsheet and have it update the source Odoo data?

Question

I would rather manage my Budget in a spreadsheet, but if I could update the Odoo data from updates in the Odoo Spreadsheet I could use that instead.

Ray Carnes (ray) · Accepted Answer

All Odoo Spreadsheets are bidirectional, meaning you can get back to the source data.
For a cell linked to an editable field (in this case the budget would be in draft) you just right click it and access the *See Record(s)* option from the Context Menu.
image [1]

You are then returned to the Odoo backend where you can edit the data:
image [2]

The Odoo Spreadsheet will refresh the next time you open it, or you can trigger this manually:
image [3]

[1] /web/image/81237224-1ca9fbd9/image.png?acc

相关帖文	回复	查看
V9 - Enable a currency when installing a module 已解决 data update currency	1 1月 16	4628
How to update all addons of a database (-u all) WITHOUT restoring all XML data also? data addons update website	1 2月 16	4495
Can I combine data from two different document types / models with Odoo Spreadsheets? 已解决 view data pivot spreadsheet combine	1 12月 20	6465
How implement a user query dialog "use init data yes or no" during module installation and update? installation module data update init	0 3月 15	4362
How to export odoo spreadsheet's raw file and import into another database spreadsheet	0 5月 24	5

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！