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

database form

1 Beantwoorden

13626 Weergaven

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

Auteur

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

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
Where do we find database of Form that was created on ODOO database form	1 mei 24	5336
Getting data from user form Opgelost database form data	3 sep. 23	6410
In Odoo, what is the purpose of the PostgreSQL database, and how does Odoo use it? database	0 mei 26	6
Can i use the same Database for a company with different Department database	0 mei 26	61
Can i create multiple forms for a single model using studio ? Opgelost form	2 sep. 25	2951

Deze vraag is gerapporteerd

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