Under Contract Table, Currently I am adding only one car to a single contract. Meaning a single contract is linked to single car while a single car is linked can be linked to multiple contract but not at the same time.
A car changes status only once from any of Active Rental, Rent to Own Active, AA Auckland to Returned or Swapped Cars & Bond Transferred.
This should not work if I change Contract status from returned to swapped or swapped to returned.
I’m sorry for the extra day it has taken me to get back to you. Life happened.
I’m not sure what you meant by this, however, I think my solution has this covered.
I’m sharing my test base with you so you can see what I’ve done better than from images alone. You can copy it and then explore.
Any field starting with :gear: fills a formula or automation function, but can be hidden away from view.
Any field with :white_check_mark: in their name helps determine what contract is the latest in instances where the car has more than one contract linked. I’d built the solution before my break and I find it a good idea to build this in from start, rather than to have to add it at a later date and to have to correct automations doing their job, but not what you now need them to, manually. So, I left that part in the test base.