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

database form

1 Svar

13722 Visninger

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

Forfatter

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

Kan du lide at diskutere? Læs ikke bare med, deltag aktivt i debatten!

Opret en konto i dag for at få glæde af eksklusive funktioner, og bliv en del af vores skønne fællesskab!

Tilmeld dig

Relaterede indlæg	Besvarelser	Visninger
Where do we find database of Form that was created on ODOO database form	1 maj 24	5360
Getting data from user form Løst database form data	3 sep. 23	6511
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	3100

Dette spørgsmål er blevet anmeldt

Kan du lide at diskutere? Læs ikke bare med, deltag aktivt i debatten!