My case is as follows:
I have created a Real Estate module through Odoo Studio inside of the module are two models as follows:
1) RREMS Projects
2) RREMS Shops
RREMS Projects
Inside of RREMS Projects there is a field called vacancies this is an integer field
RREMS Shops
Inside of RREMS Shops there is a selection field to show shop status as rented or not rented
What I would like to achieve
The vacancies field in RREMS Projects is supposed to have the total number of the shops that have not been rented (Shop Status: not rented). If the sales person changes the shops status in RREMS Shops to rented the vacancies field will decrease by one and the opposite is true, if the shop status changes to not rented the vacancies field will increase by one.
So, the vacancies field in the RREMS Projects model will be updated by the Shop status field in RREMS Shops model.
Note: RREMS Projects has a one2many field to display the shops as part of the RREMS Projects model. Also note this has been created entierly in Odoo Studio
Can I acheive the above though Odoo studio or is there any other way I can do that?