Skip to Content
This question has been flagged
1 Reply
709 Views
Avatar
Pascal MORMIN

Hi,

In my organisation, site interventions need worksheet. Actually this is an Excel sheet witch is printed, once, twice, ... as needed. The number of lines is not exhaustive and I want to computerize this with Odoo.

I tried to make a worksheet template with all the fields (column in excel) that correspond to one line in Excel sheet. 

Thats work but it is equivalent to only one line in my Excel. I didn't found a way to add a new set of those fields (a new line in Excel sheet) like a button thats add a new line. 


I dont know how to generate a dynamic worksheet, so i am open to any solution or alternative solution to get a working worksheet. 


Sorry for bad english, hope you understand.

Thank you.


 


Avatar
Discard
Pascal MORMIN
Author

Thank you very much, you helped me a lot. 

Avatar
Ray Carnes (ray)
Best Answer

First, create a new Field Services Worksheet Template.

Next, using Odoo Studio, create a new model "Worksheet Lines" and add to it a many2one field that relates to your new Worksheet Template.

Back on the Worksheet Template, click DESIGN TEMPLATE and add a new one2many field to your Worksheet Lines model.

You will now have a way to add as many lines as you want to a Worksheet using the new Worksheet Template.

Avatar
Discard