In a new reservation model I have defined two dates: start_date and end_date.

When creating a new reservation, I want a field "available" thats says if dates are ok as compared to other reservations already registered and if there is no conflicting reservations I want to update the field called "available" as ok, or not_ok.

With odoo studio, I have been trying to put code in advanced properties with some @api.onchange code found on blogs but with no luck I get run time errors with bad opcode or lambda errors. It is unclear if I should go to pycharm for this.

Is there a way to solve this with odoo studio? thanks!