Vehicle Registration tracking required

We have a Liberty Create application that allows members of the public who have vans or trailers to book slots for them to bring items for disposal to one of our Recycling Centres. Initially the system was set up to enable the tracking of booked slots so that we could limit the number of visits from someone at a certain address to 12 per year. However, we now have an additional requirement which is to try to limit or at least be aware of the no. of booked slots made using the same vehicle in a certain time period.
I’ve tried creating a Vehicle object separate to our case object and created a subset to compare the Registration property in both, but I only ever seem to get all of the cases or none, not a filter, which is what I’m trying to achieve. Can you suggest anything please?

Hi, did you manage to come up with a solution for this in the end? I would be interested to know what your solution looked like and how you configured it, if you are willing to share.

Did you stick with the subset route? What was the “aha!” moment that got it working? Or did you find another solution altogether?

Questions like this might seem straight forward to builders who have been using the product for some time, but seeing answers, and importantly different potential options, to solving these questions on this forum I believe is invaluable to relative newbies still trying to figure out how everything works.

Hi Jared. We found that subsets didn’t really provide a solution, though logically you would expect them to. We ended up using Code Studio and it initially seemed to be working but during testing found there were scenarios where the figures were coming out wrong. So we don’t have a final solution to this yet.