Maybe some of you can me out here.
I have data in one structure but would like it in another structure that would help me use the data for an inline list. The inline list should be put on the different companies - and contain the information relevant for the company - like Telephone, Email etc.
Data source Company Telephone Email
a1 123456 1@email.dk
b2 234567 2@email.dk
@ThinhDinh thanks a lot for not only providing an answer to the question but also suggesting another solution to the problem at hand
I actually did go with the other suggestion to use dynamically link. The concept is pretty hard to grasp - and when I first read the
Post before my own post I couldn’t see a need for it. But it is really clever I must say.
I personally would rather have 3 items in a list which are all links instead of 4 items where one item when clicked just tells that the user doesn’t have an email.
I just made a visibility condition to filter out items that do not have a dynamically link.
One major drawback with the dynamically link approach was that I had to do the compound action 6 times as detailed screen I was using was “called” from different lists. Cannot wait till mid January where it should be possible to reuse actions.
The inline list with the dynamic links turned out to look like this
You suggested that we might have a better way to do this soon. Is there a way to do this easily now or are the suggestions you provided the only way to transpose data from columns to rows?
What is the Whole-Row relation you have in the video tutorial? Can you share how it is setup and using which columns in which sheets?
@ThinhDinh You suggested that we might have a better way to do this soon. Is there a way to do this easily now or are the suggestions you provided the only way to transpose data from columns to rows?
What is the Whole-Row relation you have in the video tutorial? Can you share how it is setup and using which columns in which sheets?
The other issue I’m having is that when I try to set columns the only option it offers is This Row. I see you have the option to select Rel 1, Rel 2, Rel 3 as your rows. I’m not able to understand what I’m doing wrong.
There’s still no way to do this easily solely in Glide now. For this specific type of request I usually have 2 options:
If it’s only the signed-in user viewing that data, I use an if then else column to transpose it. Let’s say you want to transpose Data A and Data B (different columns in the user profiles sheet) to 2 rows, I would create a new Glide Table with 2 rows named Data A and Data B, then an If Then Else column: If Row Name is Data A then Signed-in User’s Data A, if Row Name is Data B then Signed-in User’s Data B.
If anyone can view those then I use the set column approach above.
It is a single value column pointing to an entire row that can act as a pathway to that row, the same way as a relation. Let me know if you need more help with this.
Thankyou. I ended up using the first option. Am not at the level where I can wrap my head around that dynamic link solution. But it is very cool. Thanks so much. I really appreciate you walking me through the steps.
I also want to say sorry I cleared that app off the dashboard a while ago so the example isn’t available anymore. If you really need that I will re-build it in my free time.
