I have a client working in Real Estate and they have currently only a Main Office but are planning to open some Agencies managed by Franchise Partners.
The idea is that the Main Office hosts both Front-Office (Portal) and Back-Office where each Partner manages his own properties.
Additionally each Partner has his own Portal using Linked Tables.
The setup up to this point is quite clear to me but am wondering how to prevent the download of all properties on all Partner Portals since these are Public and therefore I might not be able to use Row Owners.
The setup would be something like this:
-Main Portal, showing all properties, partners managing only their own properties.
-Partner Portal (A,B,C etc. each with custom domain) showing only the relevant partner properties.
I am aware that even with filters all data is downloaded but was wondering if there are some solutions which are escaping me!
Is there a reason you don’t combine them all into one app? I take it every time you make a change to the Partner Portals, you would have to do it X times and it’s very hard to maintain.
Thanks, I understand what you are saying but thing is that those Partner Sites are quite static e.g. just listing their own properties, any future updates will be at the Main Website.
They might use a sub-domain or their own domain.
My main question therefore remains: How to avoid downloading of all data to portals which do not belong to that partner?
All the best.
PS What is the current update path going from Glide Tables to Glide Big Tables?
This is an interesting question. It’s the same table of properties so you can’t really have a roles setup, unless you have a column for each of the portal’s names , which is not scalable.
I wonder if that can be a last resort option for you though. Say for Portal A’s app, you use “Portal A” value as the roles/row owner value, same for “Portal B”, “Portal C” etc.