Skip to Content
Menu
This question has been flagged
2 Replies
1889 Zobrazenia

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
Zrušiť
Autor Best Answer

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
Zrušiť
Best Answer

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
Zrušiť
Related Posts Replies Zobrazenia Aktivita
2
jan 22
4238
1
feb 25
451
1
jan 23
2218
0
jún 22
1542
1
máj 22
3768