Siirry sisältöön
Menu
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Tämä kysymys on merkitty
2 Vastaukset
2612 Näkymät

I am not a programmer and i use studio and automations to customize my database. This question concerns an automation that i want to input text to a field. 

If a field in sales order line is empty a short text is inserted to the field. I have everything set except the correct python expression. Anyone have an idea what syntax to achieve this?


Thanks!


Avatar
Hylkää
Tekijä Paras vastaus

Thanks MML,


i had to go with a different solution this time since i didn´t have acces to the default field in the sales order line. 


Peter

Avatar
Hylkää
Paras vastaus

You can use the following python expression in the "Default Value" field of the field in the sales order line to insert a short text if the field is empty:

if not self.field_name:
self.field_name = 'Short Text'

Here, field_name is the name of the field you want to set the default value for. You can replace 'Short Text' with the desired text. This expression will check if the field is empty (i.e. its value is False), and if so, set its value to the specified text.

You can use this expression in the default_get method of the sales order line model to set the default value for the field when a new sales order line is created. For example:

ef default_get(self, fields):
res = super(SaleOrderLine, self).default_get(fields)
if 'field_name' in fields:
if not res.get('field_name'):
res['field_name'] = 'Short Text'
return res

Here, SaleOrderLine is the name of your sales order line model.

MML

Avatar
Hylkää
Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
2
tammik. 22
5058
1
helmik. 25
1196
1
tammik. 23
2814
0
kesäk. 22
1976
1
toukok. 22
4433