How to transpose data

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

Transformed data:
Company Datatype Datavalue
a1 Telephone 123456
a1 Email 1@email.dk
b1 Telephone 234567
b1 Email 2@email.dk

The inline list should look like what is shown on the app in this post:

Apologies for the long formula but I wanna cover the empty cases as well.

4 Likes

Not sure if it helps but you can have a look here as well.

1 Like

@ThinhDinh thanks a lot for not only providing an answer to the question but also suggesting another solution to the problem at hand :+1:

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

4 Likes

That looks pretty nice! Hopefully we can have a better way to do this very soon.

1 Like

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?

@Food2Soil the idea is the the post by thinh

1 Like

@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.

Thankyou. I saw the post and video by thinh. my question was related to the whole_row relation he has set up in his video. Thankyou for your response.

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.

1 Like

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.

@ThinhDinh @Food2Soil i have used the dynamic link idea in the Business directory app which is in the template store so Thinh make take the time off :stuck_out_tongue_winking_eye:

2 Likes

Great to hear hehe. Here’s the link for anyone interested.

1 Like