Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Boekhouding
Voorraad
PoS
Project
MRP

All apps

Alle posts Personen Badges

Labels (Bekijk alle)

odoo accounting v14 pos v15

Over dit forum

Help

Manually create/delete lines in a form in a one to many field (Survey module)

survey one2many id insert onchange

1 Beantwoorden

6833 Weergaven

Mauricio Leon

I'm trying to create a line in a one to many field every time a checkbox button is clicked.

I added this button to the survey form view (from the Survey module) called nominative

The model is as folows

class survey_survey(models.Model):
_inherit = 'survey.survey'
nominative = fields.Boolean(string="Nominative survey", default=False)

And this is the view

<record id="survey.survey_form2" model="ir.ui.view" >
    <field name="name">survey_form2</field>
    <field name="model">survey.survey</field>
    <field name="inherit_id" ref="survey.survey_form"/>
        <field name="arch" type="xml">
            <field name="quizz_mode" position="after">
            <field name="nominative" />
        </field>
</field>
</record>

What I want to happen is that every time the "Nominative" checkbox is selected, a page with some questions gets loaded in the form, and every time the checkbox is unselected, that page gets popped out of the list of pages in the form.

Right now my nearest approach to do this is by creating a new object and append it to the page_id collection

@api.onchange('nominative')
def _toogle_extra_page(self):
    cr = self.env.cr
    uid = self.env.uid
    page_obj = self.pool.get('survey.page')
    page = page_obj.create(cr,uid,{
        "survey_id": self.id,
        "name": "Extra Page",
        "title": "Extra Page"
    }, context=None)
    self.page_ids.append(page)

But when I hit the checkbox, the "self.id" value is set to "NULL" in the SQL command

INSERT INTO "survey_page" ("id", "survey_id", "sequence", "title", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval('survey_page_id_seq'), NULL, 10, 'Pagina de Contacto', 1, 1, (now() at time zone 'UTC'), (now() at time zone 'UTC')) RETURNING id

And also it is not showing in the form view as "Extra Page"

How can I manually insert/remove pages when that specific event occurs?

Mauricio Leon

Auteur

I have managed to add a new element to the list of pages with the following code

@api.onchange('nominative')
def _toogle_info_page(self):
    cr = self.env.cr
    uid = self.env.uid
    pages = []
    pages.append({
        "name":"Contact Page",
        "title":"Contact Page",
        "sequence": 1,
        "description": "Contact info Page"
    })

    self.update({"page_ids": pages})

With this I was able to update the list of pages I had in my survey, but it removed all previous pages inserted. So, in order to solve this, I used the following code

@api.onchange('nominative')
def _toogle_info_page(self):
    page = self.env['survey.page'].new({
        "name":"Contact Page",
	"title":"Contact Page",
	"sequence": 1,
	"description": "Contact info for tracking"
    })

    self.page_ids += page

With this, I don´t need to know the current survey ID to insert a new page in the list of pages.

I still can´t get the questions inside the pages though (no method described above worked), but I´ll open a new thread on the blog for this doubt.

Hope it helps.

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

Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!

Aanmelden

Gerelateerde posts	Antwoorden	Weergaven
How to update two levels o2m fileds relation one2many onchange	0 sep. 20	3786
Several levels of One2many one2many onchange	0 apr. 16	3913
One2many onchange in ODOO Opgelost one2many onchange	3 mrt. 16	14983
How to Import one2many field record from one model to one2many field in another model one2many onchange	1 mrt. 15	13340
Insert values to one2many on specific record one2many insert odoo	2 sep. 23	225

Deze vraag is gerapporteerd

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