Learn to master the Single Value → WHOLE ROW feature Use this feature to easily link to the details screen of a: :backhand_index_pointing_right: home screen… :backhand_index_pointing_right: sign up form… :backhand_index_pointing_right: about page… :backhand_index_pointing_right: …and more! …

Never occurred to me to add those sv->whole row columns to the User Profile table, but it’s so obvious when you say it. I’ve been in the habit of adding one to every table where I need to use it. Time to change habits :slight_smile:

Very nice Bob. Instructional, clear, and eye-opening as always.

[image] Darren_Murphy: Never occurred to me to add those sv->whole row columns to the User Profile table Collaboration!

[image] Darren_Murphy: I’ve been in the habit of adding one to every table where I need to use it. Likewise. :man_facepalming: Didn’t cross my mind to use the user table. I’m already in the single row table (tab source table) when I trigger Add mode in my custom form. I only needed a singl…

Great video, as always. I do have a single record “control file” which contains various information used elsewhere. As always, I seem to push the limits of Glide. I tried “whole row”, but unfortunately, the new field does not appear everywhere i’d used the individual fields. In a custom action, …

As long as the source sheet for the screen is the one that has the single value, it should work. Again, life will be easier if the single value → whole row is in the user’s table: [CleanShot 2023-01-24 at 13.59.51]

Yes to both. The value is in the Users table and the source for the screen is in the users table. [image] [image] On the Add Row action, I can choose other values from the User table, but *Control does not appear in the list. [image]

Looks like Control is referencing a whole row. If you want to use a column from that row in an action, you’d need a lookup on top of it to fetch the column value. Bob mentions that in his video.

Hi Darren, I think what Bob just said about selecting values from relations is the issue – because in my “add row” action, I don’t even see it as a relation, and it does not show up when I select “User Profile”: [image]

Mastering the Mighty Single Value → WHOLE ROW

Community Resources

Robert_Petitto January 24, 2023, 8:04pm 10

Right… whole row = relation. If ever Glide allows us to have inline lookups (vote here: Select values from relations just like "User >" (Inline Lookups)), then what you’re describing would be possible, theoretically.

Topic		Replies	Views
🆕 Single value now supports "whole row" as a value Ask for Help	9	1645	July 11, 2021
🔧 Single Value Column Updates General	14	802	October 6, 2020
A weird situation, how to find out the Custom form that I created? Ask for Help	3	70	April 10, 2024
Need help in fetching user specific column value Ask for Help	25	112	July 29, 2024
I can't pull first choice for a single value column Ask for Help	4	38	June 11, 2025

Mastering the Mighty Single Value → WHOLE ROW

Related topics