I need to create a table in a new Odoo Studio module. A new line should be added to calculate the cost of employee meals. I'm trying to make it so when I select the type of meal, the cost changes.
Cette question a été signalée
1
Répondre
1103
Vues
Hi,
1. Create the Meal Line model
New Model → Meal Line (this will be the table rows). Add fields:
meal_type_id → Many2one → Meal Type
cost → Float (readonly)
employee_id → Many2one → Employee
date → Date
quantity → Integer
2. Auto-fill cost when meal type is selected
In Studio, select the cost field → set a Default Value using a related field: meal_type_id.cost. This makes cost populate automatically when a meal type is chosen.
3. Add the table to a form
Open the parent form (e.g. Employee) in Studio → drag a Lines (One2many) widget onto the form → point it to Meal Line → add the columns: Date, Meal Type, Quantity, Cost.
4. Add a total
On the parent form, add a Float field → set it as Computed with the formula summing meal_line_ids.cost * quantity.
5. Make cost read-only in the table
In the Lines widget column settings, mark cost as readonly so users can only change it by selecting a different meal type.
The key point is step 3 — Studio doesn't support onchange directly, so the trick is using a related field (meal_type_id.cost) as the default, or if they need true dynamic behavior, they'll need a small custom module with @api.onchange('meal_type_id') to copy the cost over.
Hope it helps
Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !
Créez un compte dès aujourd'hui pour profiter de fonctionnalités exclusives et échanger avec notre formidable communauté !
S'inscrire| Publications associées | Réponses | Vues | Activité | |
|---|---|---|---|---|
|
unbild decimail place
Résolu
|
|
1
mai 26
|
2686 | |
|
0
août 23
|
3879 | ||
|
|
0
juil. 23
|
2412 | ||
|
|
1
juil. 23
|
3820 | ||
|
Remove (studio) custom field
Résolu
|
|
1
mars 23
|
8032 |
"result" is a local variable so outside the method the value is not available.
You need to assign result to a field, like record['amount'] = result
You also need to loop through all records to support multi editing.
Review the documentation and other forum posts for examples.