Hii,

I have a custom app with a header and line tables. There is a workflow on it that goes for approvals from different departments. 

User select product and its fields and enter new value for the field, when the workflow is approved, system updates product value with new value user entered.

The requirement is to add the product in the line and then in the next column select a field from in the dropdown list. 

In this dropdown list all fields of product_template model should appear. User select a field and in the next column its value should appear. 

Following is the line table.

Product                     |   Field                 |  Value                   | New Value

Wooden Chair               Name                   Wooden Chair       Wooden Chair (362eer)

Wooden Chair               Barcode               WC005                  WCD005

Office Table                  Product Type       Service                 Storable Product

Office Table                  Tracking               No Tracking          By Lots

How we can achieve it?

Odoo 12EE