Hello,
I think you can explore two solutions.
One would be to synchronise the required tables from the different databases to a single base and to build the global interface on this synchronised base.
Another solution would be to insert butons in the global interface that allow to navigate from global interface to "local" interface (by passing the URL).
The issue with this solution is that you would also need to insert a button "go back to global" in each local interface, button that will be seen by all users even if they do not have the rights to access the global interface.
Regards,
Pascal
Hello,
I think you can explore two solutions.
One would be to synchronise the required tables from the different databases to a single base and to build the global interface on this synchronised base.
Another solution would be to insert butons in the global interface that allow to navigate from global interface to "local" interface (by passing the URL).
The issue with this solution is that you would also need to insert a button "go back to global" in each local interface, button that will be seen by all users even if they do not have the rights to access the global interface.
Regards,
Pascal
Pascal -- Thanks for your input! Any tips how to synchronise the required tables from the different bases? What mechanism would we use for this?
Hello,
Firstly, you need to create a new database, lets call it "Global view".
Once you have donethis, go on one of the tables that you want to synchronyse and do the following:
Click on "Share and Sync":
Select the option "Sync data to another Base":
Activate option "Allow data in this view to be synced with other bases":
Click "Sync this view":
Select the workspace and the destination database:
This way, data from the source database will be synced into the "Global view" database.
Depending on your data structure, you can sync your different databases into a single table.
Regards,
Pascal
