So you can now create a relation out of thin air? [image]

What are the types of use cases?

Hm… :thinking: Maybe @Mark or @JackVaughan an chime in here. First thing that comes to mind is to display a random post/add/challenge/etc. to the user on your homepage:

I think this will be very useful in cases where we want to set up a details view for users but also need to display data from another sheet which could be like the “homepage” That way, without having to create new columns/components in the user profile sheet, we should be able to display the data from other sheets in the same details screen

Ah. Agreed. Yes, a homepage that has many columns but only one row would be a good use case. Each user would then be “related” to that whole row. Keep 'em coming all! More use cases!

I still don’t understand the best use of this. @Robert_Petitto Did you get any response from Glideapps team?

Single value-whole row complements the “independent screen config per item” option that you have on View Detail actions for inline lists. Another layer of flexibility - you can bring with you elements that are independent of sheets/lists and plop them where you want. If you have a catch-all sheet that’s not bound to a tab and you set column A to be an INDEX of sorts, using that column in a single value-whole row context is a calling card. It starts to act more like a relation column and you can look up other columns on that sheet instead of constantly setting up single value columns. Hope this helps.

Bringing this post back to life. It’s now been a year since we’ve had Single Value > Whole Row. Who’s using it and for what purpose?

Me, I use and it is very practical. Recall a one row element with singlevalue / whole row, then I use it as a relation to do lookups.

It would be a killer combination if we had inline lookups. [image] Select values from relations just like "User >" (Inline Lookups) Feature Requests Just like we can choose a value from a user profile sheet during if/then/else columns, template columns, filtering/visibility conditions, etc, would love to be able to do the same via relations. It would cut down on SO MUCH app bloat. @david @mark @tristan Here’s a mockup: [Screen Shot 2021-04-27 at 10.03.32 AM] @mark @jason

🆕 Single value now supports "whole row" as a value

Ask for Help

Robert_Petitto July 11, 2021, 3:46pm 10

It would be a killer combination if we had inline lookups.

@mark @jason

Topic		Replies	Views
Mastering the Mighty Single Value → WHOLE ROW Community Resources tutorial	19	1366	October 19, 2024
🔧 Single Value Column Updates General	14	881	October 6, 2020
Expected behavior for Relations Ask for Help	2	260	September 21, 2020
Using and displaying relation's column data without copying them Feature Requests	4	657	May 2, 2020
Adding a new row based on values of a relation Feature Requests	1	460	May 30, 2022

🆕 Single value now supports "whole row" as a value

Related topics