mapa, thank you for your patience in reading my long posts.
First:
It seems like you have shared with us 2 different cases: the first one - geofences should be bonded with the day of the week and the units
I just shared this for better understanding of situation. This problem is easy to solve as we can use time limitation feature in report template and create a report template for each day of week. Seven report template is acceptable.
Could you please share what kind of business is that? Why there is a need in a geofence for each day of the week for each unit?
Big factories that distribute their products themselves, they have hundreds of vehicles and has set something like this:
Zones for truck A:
Sa >>> Zones 1, 2,3
Su >>> Zones 4,5,6
Mo >>> Zones 7,8,9,1,2,3
Tu >>> Zones 10,11,12,4,5,6
We >>> Zones 13,14,15
Th >>> Zones 16,17,18,4,5,6
Fr >>> Zones 19,20,21
They have set these zones for each vehicle as they know how much goods they should deliver to each zone because they have customers or warehouses there.
To export 3500 reports client will need to create 3500 geofences. Has the client created them already?
They have all these geofences for whole country in their sales software and we can import them.
Also, as you know, you could insert several tables for each report. For example, create a table for each unit and its 7 geofences. Have you tried that? If no, why that solution does not suit you? It is time consuming, but you need to create a template of the report only once.
Creating even 3500 report templates is not hard for us but executing 500 of them each day is not acceptable for customer. Adding more than one table won't work. We are going to create a report template on Units Group with hundreds of units. Let's think we are creating this report template only for Sat, so we use time limitation and set it to Sat only for each table. Now you tell me how we should add tables to this report template to reach what we need? Consider we want to add Geofence table 500 times in this report template, which option or feature will cause reaching the result we are talking about?
How many times per month does the client need those reports?
Every day