Sisipkan dan tautkan ke data Odoo¶
Beberapa elemen dari database Odoo Anda dapat disisipkan ke dalam spreadsheet Odoo, yaitu:
pivot tables, i.e., data from a pivot view
charts, i.e., data from a graph view
Each time a list, pivot table, or chart is inserted, a data source is created, directly connecting the spreadsheet to the underlying data.
Catatan
Daftar, tabel pivot, dan bagan dari berbagai aplikasi dan model dapat disisipkan ke dalam spreadsheet yang sama.
It is also possible to insert a pivot table that retrieves Odoo data directly from an Odoo spreadsheet.
Tip
Jika Anda berniat menggunakan filter global untuk memfilter data Odoo secara dinamis dalam spreadsheet atau dashboard, jangan gunakan kondisi yang sama untuk membuat daftar awal, tabel pivot, atau grafik di database Anda.
Anda juga dapat:
add clickable links to Odoo menu items, to other sheets of the same spreadsheet, or to external URLs
insert financial data from your Odoo database using Odoo-specific spreadsheet functions
Sumber data¶
When you insert a list or chart from an Odoo list or chart view into an Odoo spreadsheet, or insert a pivot table referencing Odoo data from an Odoo pivot view or directly from a spreadsheet, the spreadsheet is automatically connected to the underlying data thanks to a unique 'data source.'
This connection ensures that the data in the spreadsheet is updated when the corresponding data in your database changes, and allows you to access the underlying data.
Catatan
Data in a list, pivot table, or chart linked to an Odoo model is refreshed every time the spreadsheet is opened or the browser page is reloaded. It is also possible to manually refresh data by clicking from the menu bar.
Inserting a pivot table from a range of data also creates a data source that connects the pivot table to the underlying spreadsheet range.
Each data source is identified by a unique ID, with each source type (i.e., list, pivot table, or chart) numbered separately, and each new list, pivot table, or chart numbered sequentially, e.g., List #1, List #2, Pivot #1, etc.
The properties of a data source can be accessed via the Data menu, where they are identified by their respective (pivot table), (list) or (chart) icon, followed by their ID and name, e.g., (#1) Sales Analysis by Product.
Mengklik sumber data akan membuka properti terkait dalam panel di sebelah kanan spreadsheet.
Catatan
Deleting an inserted list or pivot table, or deleting the sheet into which it was inserted, does not delete the underlying data source; this can only be deleted via the data source's properties. Deleting an inserted chart, however, also deletes the underlying data source.
If an inserted list or pivot table is deleted, but not its data source, a warning appears beside the data source in the Data menu indicating that the data is not currently being used in the spreadsheet.
Tip
Panel properti juga dapat dibuka dengan mengklik kanan sel mana pun dari daftar atau tabel pivot yang disisipkan, lalu mengklik Lihat properti daftar atau Lihat properti pivot, atau dengan mengklik ikon (menu) di kanan atas bagan yang disisipkan, lalu mengklik Edit.
Setelah properti sumber data tertentu dibuka, properti tersebut akan tetap terbuka bahkan saat berpindah antar tab spreadsheet. Untuk menutup panel properti, klik ikon (tutup) di kanan atas panel.
To collapse the properties panel, click the (double chevron) icon at the top of the panel.
To pin the properties panel and allow another panel, such as the global filters panel, to open beside it, click the (pin) icon at the top of the panel.
Mengakses data yang mendasari¶
Data yang mendasari daftar yang disisipkan, tabel pivot, atau grafik dapat diakses kapan saja. Untuk melihat:
catatan individual dari daftar yang disisipkan, klik kanan sel mana pun dari baris yang relevan, lalu pilih Lihat catatan
daftar catatan yang direferensikan oleh sel individual dari tabel pivot yang disisipkan, klik kanan sel tersebut, lalu pilih Lihat catatan
daftar catatan yang diwakili oleh titik data dari grafik yang disisipkan, klik titik data tersebut.
Tip
Gunakan tombol tengah mouse atau Ctrl + klik kiri (Microsoft/Linux), atau Command + klik kiri (Mac OS) untuk membuka hasil di tab browser baru.
Untuk kembali ke spreadsheet setelah melihat data yang mendasari, klik nama spreadsheet di breadcrumb di bagian atas halaman.