LIST Relation Question

[mayahalom]

Hi,
I have a google sheet with over 20 tabs.
The main tab which is a list of items (proffessions) and it is displayed in the main screen - the only tab that is displayed.
I wish that every time i enter the main page looking for a specific proffesion, i’d be able to click on it, see the component List relation.
But for every proffesion - every listing, the relation is different.
So for the Accountent i link it to the accountent tab
And for the Architect i can link it to the architect tab

What happens now is when i change one- it changes all the links.

Can it be done?

[George_B]

You already asked this question. If you need to reword something to make it clearer please use the original thread. Thanks.

Connect between tabs

Hello, I have a big spreadsheets which has many tabs, The first tab is a list of work fields - index And all the other tabs are the business owners in that field For example Tab 1 INDEX- long list of different professions Tab 2 named architect list of different architects with the name phone site etc Tab 3 long list of Restuarants with a restauran name phone site etc’ and so on… I wish to connect the tabs to the index. so when clicking on an index item- the tab with that name opens…

[mayahalom]

Its a different question, since i failed with the relations i tried another solution with lins relation component
but i could not change the list relation between items in the main tab- every change affected all the other listings.
where i wish to connect between A2 to Tab 2 and A3 to Tab3 and so on .

[George_B]

If you want to do it this way then you need to have only 2 rows on your INDEX sheet. Row one obviously the column titles and row two you would have the links to those other sheets. The values in row two would be “Accountant” “Architect” etc. You would then set up the relationships in the Data area within Glide.

[Jeff_Hager]

Connect between tabs

For starters, I would probably change your INDEX to list everything from Top to Bottom instead of right to left. Second, I don’t think there is a way to have one list of INDEX item pointing to several different sheets. I tried setting up a combined column array of relations, just the see if I can use one relation key to link to multiple sheets. It didn’t work and I could only add a list by each individual relation key. I think it mostly will not work because so much in Glide is tied to each…