How to strip (remove white spaces) inputs of forms before adding to database?

database form

1 Vastaa

13675 Näkymät

Rizan Zaky

I want to strip the input data to remove leading and trailing spaces.

I tried this, but didn't work...

class Test(models.Model):
    _name = 'test.mymodel'
    device_id = fields.Char(string="ID", required=True).strip()

and this too didn't work...

class Test(models.Model):
    _name = 'test.mymodel'
    device_id_strp = fields.Char(string="ID", required=True)
    device_id = device_id_strp.strip()

please help me with a solution...

Jerome Guerriat

I don't know if this solution is the most efficient, but you could add an onchange method to the field.
In this onchange, strip the white spaces.

edit:

@api.onchange("device_id")
def onchange_device_id(self):
self.device_id = self.device_id.strip()

Rizan Zaky

Tekijä

hello Jerome... isn't there a way to do this in the back end?

Yenthe Van Ginneken (Mainframe Monkey)

+1, this is the behaviour that should probably be used. And Rizan when you trigger an on_change it will trigger the Python which is your back-end in essence. Another way is to remove all whitespaces the moment you hit the save button.

Jerome Guerriat

It is backend if you declare a method in your model. Not a javascript onchange :) in your model, do something like: @api.onchange("device_id") def onchange_device_id(self): self.device_id = self.device_id.strip()

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

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Where do we find database of Form that was created on ODOO database form	1 toukok. 24	5340
Getting data from user form Ratkaistu database form data	3 syysk. 23	6438
In Odoo, what is the purpose of the PostgreSQL database, and how does Odoo use it? database	0 toukok. 26	6
Can i use the same Database for a company with different Department database	0 toukok. 26	61
Can i create multiple forms for a single model using studio ? Ratkaistu form	2 syysk. 25	3020

Tämä kysymys on merkitty

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