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

Gerelateerde posts	Antwoorden	Weergaven
V9 - Enable a currency when installing a module Opgelost data update currency	1 jan. 16	6493
How to update all addons of a database (-u all) WITHOUT restoring all XML data also? data addons update website	1 feb. 16	6025
Can I combine data from two different document types / models with Odoo Spreadsheets? Opgelost view data pivot spreadsheet combine	1 dec. 20	8393
How implement a user query dialog "use init data yes or no" during module installation and update? installation module data update init	0 mrt. 15	5849
How do you handle Excel data corruption before an Odoo import? import data csv implementation dataerror spreadsheet	1 mei 26	543

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!