I'm struggling to figure out a solution for scaling views. I currently have a view for each of our districts (which gives me approximately 90 views). They all have identical data/fields with a filter to only see the pieces tagged in that district.
I set these up as views specifically because I need the shareable URL for users viewing that don't have an account. I am using that URL in some email automations - use case, district updates. So each month, an automated email to that manager saying "here's your highlights" (all dynamic fields) with a link to "view your detailed breakdown here" (dynamic field to insert the URL of their view).
Hopefully this makes sense so far.
My problem is how poorly this scales. I just improved the view with a few other columns/groupings etc. But now I have to make that manual change across each of the 90 views and hope I don't miss any ..... is there any way at all to scale this?
The views are all identical except for the district filter. But I can't just duplicate and remake the view since I've already saved those URLs for the email automation.
Any help is appreciated!