Skip to Content
Menu
This question has been flagged
2 Replies
1996 Views

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
Discard
Author 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
Discard
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
Discard
Related Posts Replies Views Activity
2
Jan 22
4376
1
Feb 25
572
1
Jan 23
2296
0
Jun 22
1584
1
May 22
3854