Learn to master the Single Value → WHOLE ROW feature
Use this feature to easily link to the details screen of a:
home screen…
sign up form…
about page…
…and more!
Thanks to @Darren_Murphy for one of the ideas presented in this video!
Use this feature to easily link to the details screen of a:
home screen…
sign up form…
about page…
…and more!
Thanks to @Darren_Murphy for one of the ideas presented in this video!
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
Very nice Bob. Instructional, clear, and eye-opening as always.
Collaboration!
Likewise. 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 single value → Whole Row when I open the custom form in Edit mode. So I guess I didn’t waste too much time. But good to know if I need to call the form from more places.
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, I cannot set the column value using that field. It doesn’t show up.
I cannot set “*control → App Price” for example:
That new field is not in the list:
Hmm, strange I also don’t see it when setting properties on an image component (the image or any of its properties).
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:
Yes to both. The value is in the Users table and the source for the screen is in the users table.
On the Add Row action, I can choose other values from the User table, but *Control does not appear in the list.
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.
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.
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”:
Yes, Bob said the same thing as me - using different words
You’re looking for functionality that doesn’t exist. (We all wish it did).
Seeiing is believing! Now I understand it better than ever! Thanks @Robert_Petitto !
Glad it helped!
Love it but just find myself avoiding custom forms wherever possible because of update fear
In the contact us example, how many updates would that use?
I do the same. This is just one use case. To answer your questions, I guess it would depend on how many fields they needed to fill out.
Just to chime in. I use a custom form because I have a particular use case.
In some cases, I also allow the user to enter a custom rate.
So in my case, a custom form is the only viable option, since I can’t achieve the same functionality with a native form. It also allows for some more robust validation before allowing the user to submit a form.
Fortunately for me, this app has about 1.5 users, so going over usage limits is not a big concern, but I understand where it can be something to consider. There are use cases for custom forms, but if they can be avoided, I do agree that a native form is the way to go.
Not sure if it’s mentioned somewhere and sorry if its something obvious, I’m really new here. It took me quite some time to understand why this wouldn’t work for me and here is my observations.
I have Table A and Table B, in Table A I use a Single Value column to get the whole first row of Table B. When setting up a custom action for Table A I was able to set custom values for Table B through the Single Value column ONLY when Table B had at least one not-user specific column.
I originally had only a row-id and some user specific columns and when I would select Table B’s whole first row through the single value column of Table A it would very briefly show the value fields of Table A and then quickly change to “this item” values. Just by adding a not-user specific column to Table B it worked as I was expecting.
That does sound like a bug to me, but I have setup a lot of helper tables that way and I don’t think I ever had to add a basic column for it to work. Maybe a recent bug?
That’s possible. This is why I add a row ID column to every table i create.