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

database form

1 Besvara

13680 Vyer

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

Författare

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()

Njuter du av diskussionen? Läs inte bara, delta också!

Skapa ett konto idag för att ta del av exklusiva funktioner och engagera dig i vår fantastiska community!

Registrera dig

Relaterade inlägg	Svar	Vyer
Where do we find database of Form that was created on ODOO database form	1 maj 24	5341
Getting data from user form Löst database form data	3 sep. 23	6441
In Odoo, what is the purpose of the PostgreSQL database, and how does Odoo use it? database	0 maj 26	6
Can i use the same Database for a company with different Department database	0 maj 26	61
Can i create multiple forms for a single model using studio ? Löst form	2 sep. 25	3026

Denna fråga har flaggats

Njuter du av diskussionen? Läs inte bara, delta också!