Spreadsheet Custom Data v17

Question

Hi. I have exported to spreadsheets customer data according to a specific tag. So if i add extra customer with the tag it is automatically added to spreadsheets. Now in spreadsheets i want to add columns that is not in odoo. So lets say the column that i add i name it gift. Next the the customer i then say yes or no if they received a gift or not. Now when i add new customer the information added does not move with the clients row.

How to keep the manual data linked to the data imported from odoo.

How to keep the manual data linked to the data imported from od

Matt Shanks · Answer

There are 2 ways to do this:
Keep the gift column and customer column on a different sheet, then use XLOOKUP function in the spreadsheet to match it to the customer list Add a custom field to the model

Angel Lozano · Answer

I'm having the same issue. The spreasheet allow to add custom fixed data columns, but it's not linked to the row you text but "fixed" position. It would be very useful if this data is linked to the data row where it's written.

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Can pivots from different models coexist in the same spreadsheet? spreadsheets	1 lokak. 25	2756
How do I build a Dashboard from a Spreadsheet? spreadsheets	2 syysk. 25	1256
Dashboard & Spreadsheet spreadsheets	1 syysk. 25	2413
Can I resize the data area of an Odoo Spreadsheet? I don't want to whole window smaller. Ratkaistu spreadsheets	1 huhtik. 25	2227
Insert into spreadsheet record limit Ratkaistu spreadsheets	4 maalisk. 25	5381

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!