Skip to Content
Menu
This question has been flagged
2 Replies
1304 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
3521
1
Jan 23
1674
0
Jun 22
1073
1
May 22
3117
0
Nov 21
21