This question has been flagged
3 Replies
7557 Views

Hello.

The scenario is: ODOO community 11.0

The requirement is: Having two custom fields in a model, StartDate and EndDate, how to validate that EndDate can´t be smaller than StartDate. 

Constraint (How to accomplish the task?): Without creating an extension to module or any new module. Just modifying the model directly from Setting->Database Structure -> Models.

Any idea?

Thanks for help.

Avatar
Discard
Best Answer

I have the exact same question and the answer didn't help. We don't want to compute a field, juste test is the date is after another field date.

Avatar
Discard
Author Best Answer

Thanks for you answer. But I could not did settle how to place there a validation instead a computed result value.

Avatar
Discard
Best Answer

 Setting->Database Structure -> Fields (Search your EndDate) -> Advance Properties, you will see Dependencies and Compute field, there is a little help text in there:

 Computed fields are defined with the fields Dependencies and Compute.

The field Dependencies lists the fields that the current field depends on. It is a comma-separated list of field names, like name, size. You can also refer to fields accessible through other relational fields, for instance partner_id.company_id.name.

The field Compute is the Python code to compute the value of the field on a set of records. The value of the field must be assigned to each record with a dictionary-like assignment.

    for record in self:
        record['size'] = len(record.name)

You can use this to compute constraint checking your StartDate and achieve the goal.

Avatar
Discard