Glide 101: Relation Column
ฝัง
- เผยแพร่เมื่อ 26 ก.ค. 2024
- 🚀 Creating your very own no code app with @glideapps is easy-get started today: glide.grsm.io/robert
👉 In this video, learn how to link (relate!) data in your app by using a Relation column.
💎Grab a copy of this app by becoming a Glide VIP member!
/ @robertpetittowa
👔 Hire me to build your Glide app: glide.grsm.io/glideexpert
00:00 - Intro
00:32 - Planning out your relations
01:48 - Use case: display topics and lessons in those topics
02:32 - What's a relation anyway?
03:40 - Creating the matching value in the 'child' sheet
04:44 - Add a relation column in the 'parent' sheet
05:27 - Do I match multiple?
06:41 - Relating back to the parent sheet to bring in parent values
08:42 - Recommendation - use Row IDs as the matching values
11:43 - Recap - วิทยาศาสตร์และเทคโนโลยี
Thanks for putting something in here for beginners! I think this video was better than glides on relationships!
Well that’s a compliment for sure. Glad you found it helpful!
@@RobertPetittoWA Gidday Robert. Is there any way that Glide could include your how to videos or at least the URL to the specific video into their documentation so us newbies obtain a clearer understanding please? Honestly their documentation sucks and they heavily rely on text and not everybody learns via reading text. I'm more a visual/auditory/kenetic learner and I've found the Glide documentation simply is not put together in a very practical way and their tagging sucks absolutely big time. 9 times out of 10 I can't even find the required information in their documentation via their search function. Just a thought. You explain things very, very well and show the actual steps which really helps us newbies out absolutely big time.
Thanks for video. Now it’s better to understand ❤
You’re welcome!
Wow, thank you for this video. I was struggling with this. As someone mentioned, it is better and clearer than the video from Glide. One or two weeks ago, I was having problems with something like this, but someone in the Glide community helped me with it. After that, I was still trying to wrap my head around it. But your video made some things clear to me. It also gave me some idea of how I could fix a problem for a new project I am working on. Thank you. 🙂
Glad you found it helpful!
This might be my favorite video about glide! Fantastic and thank you! I think the only thing missing is how you would assign or link a row ID in the app instead of copying and pasting in the tables (something I need to research 😊)
Thanks for the compliment and the feedback! To add a row ID to the destination table in order to form a relation, you can pass it along in an Add Row or Form Screen ("screen column"). You could also allow users to select an id to add using a choice component. My video on registrations should explain this concept:
th-cam.com/video/IWZWB1hn3DU/w-d-xo.html
Robert you are awesome and I appreciate you taking the time, thank you so very much!
Brilliant, thanks for making it so easy to follow along.
You're very welcome!
Great job! You helped me connect the dots on relations. Thanks!!
Appreciate it!
Incredibly helpful nuances with the RowID concepts and relations. Helped me out a lot with a specific workflow I was creating. Thanks!
My pleasure!
This is such a great explanation. Can’t wait for the part 2 💯
Much appreciated!
Thanks!! I like the way you explained and easy to understand and clear pronunciation for English -second language-people like me!!
Glad it was helpful!
I just went a head and liked bunch of your videos. Your content is very helpful and mind blowing for me!
Awesome, thank you!
THANK YOU SOOOOOOOOO MUCH
You’re welcome!
Watching this could have saved me a couple hours banging my head against the desk. Thank you
Glad you found it helpful!
@@RobertPetittoWA I woke up this morning still banging my head. I've created multiple relationships using various tables but the relationships never show up as an option in source.
That was valuable 🎉
Glad it helped!
Thanks Robert great videos! can you do one for a simple taxi meter app? just allow users to type in start and end then calculate the distance and take that to multiply the Rate card for total price per that trip. thanks in advance
Possible, but requires a third part integration for distance because all native distance columns in Glide are “as the crow flies” and doesn’t take into account driving direction distance
how could I build a notification for a user to receive sound when a new item is added
Add a custom action and incorporate a button play sound action at the beginning of the action sequence
Is glide popular in US and how many people use it in theirs projects?
Glide is one of the best no-code app development platforms worldwide.
I make apps in glide and try to sell it to a costumer, but now it hard
Great video. I have a quick question if I may. I am working on a friend's budget app and I've managed to get the computed columns in the main spreadsheet to automatically update once she updates the monthly figure for the specific item in her app. All good so far.
I created a 2nd spreadsheet which I titled Grand Totals (and this spreadsheet includes 3 rows: Budget, Income Source and Savings. With the columns: monthly, fortnightly, annually.
I've also created Row IDs for both spreadsheets and enabled that the computed columns in both spreadsheets are visible in her app. I also created relationship columns in both spreadsheets.
What I'm scratching my head on is that I cannot get seem to get the connection between the budget spreadsheet and the Grand Totals spreadsheet so that when she updates a monthly payment the grand totals spreadsheet is automatically adjusted also, like it does in the budget spreadsheet.
Is there a way of doing this please: Or will my friend have to do this manually please for the Grand Totals spreadsheet please.
Many thanks in advance. Your videos are amazing and I greatly appreciate all help and support you provide.
There’s probably a way, but I’d need to take a closer look. Book a time with me if you’d like to reserve some time:
calendly.com/robert-petitto
Thanks!
@@RobertPetittoWA Gidday Robert. Many thanks for your response. Greatly appreciate this. I did manage with Look Up to get the 2nd sheet to read the main sheet which was great. However, then had a brainwave on how to include the information on the Main sheet and whalla it works well. So my friend will be able to see all the info in her main budget. Thanks heaps for offering to chat to me. Greatly appreciate this.
Do the Comp. columns Excel formulas work for you?
On the homepage of Glide it works but as soon as I try it in my app it doesn't calculate. only simple calculations like A+B work.
I wanted to get the highest value of a range =max(A1,A2,A3) just doesn't work.
would be cool if you could make a tutorail about it too.
by the way your tutorials are the best!
Thanks for the kind words. The math column can do simple calculations.
www.glideapps.com/docs/reference/computed-columns/math-column
If you want to write legit excel formulas in Glide, there is an “Excel formula” column you can leverage.
Max can also be achieved by rolling up a relation/array column and selecting “Maximum”
Robert, I'm testing Glideapps and great videos from your channel! I followed your video and it worked until I renamed the parent column. Renaming the record breaks the relation, for example, from Topic 1 to Topic 500. Is there a workaround this issue?? TIA!
You renamed the column or a value in the column? Renaming the column shouldn’t affect the relation. Renaming a value in the column certainly would.
@@RobertPetittoWA Rename the value yes. No solution for this??
Great video! I do have a question for you (or anybody else who might know). I want to automatically populate the RowID from one table to another. For example: I have a mission ID. Each mission can have multiple participants, so there is a one to many relationship between missions and participants. First I create a mission with some mission specific details. I then want to enter multiple participants with all of their associated mission data for that mission. To associate the participant to the original mission, I'd like to have the mission ID automatically filled in (and not visible to prevent editing) for each participant, therefore automatically associating them with the original mission entry. Thanks and keep up the great work!!
When adding a participant, use a “screen” column -> RowID. This will pass the value to the destination sheet without the user seeing it
@@RobertPetittoWA thanks sir!
I'm trying to copy the Row ID to another table, however, it isn't letting me. I'm using CTRL+C and CTRL+V to paste but nothing happens. How did you copy and past the Row ID? thanks so much!
You might need to double click the row ID in order to copy it before you paste
@@RobertPetittoWA thank you, I'll give that a try
Hi Robert, can I ask why the Computed Columns is unable in my app???
They should be there, but if your base is a Google sheet, then when you go to EDIT a column, you won’t see those columns…it will only be available for NEW columns.
Hey I am Not able to View LookUp Columns in the app any fix for it
Make sure the lookup column is tied to a SINGLE relation column and not one that’s matching multiple.
how can we create a many to many relationshop 1 topic contains X lessons - X lessons are part of X topic ?
1 Topic > Many Lessons is easy. Column with topic in the lessons table and a relation column in the topics table.
Many to many Lessons Topics
Is a bit trickier. Can lessons belong to multiple topics?
hi, do you have a template of this for VIPs?
Message me at r.petitto@gmail.com for assistance.
i have done the same thing, but when im trying to add data to the child table, it is inserting double entries.. how to go about this? :(
I assume you’re using a form screen in Glide to add data to a child table? If so, make sure you don’t have an ”on submit” action of “add row” as the form screen is already adding a row.
why my components doesnt have the inline list :(
Use a collection > list. Inline lists belonged to Classic apps.
Is there a way to write to a related record?
For sure! You can use a set column action and point the source to the relation
@@RobertPetittoWA I see! and where do you recommend storing the multiple temporary values? I was gonna do so in a dedicated table with a single row, but that's the same issue where you can't write to a related table 😅
Really depends on what you’re trying to do
@@RobertPetittoWA I have a collection. When a user clicks on a row, I want to show on the side the values of the current row with the ability to edit them. I don't want the pop-up of a new screen, I want the clean speed of a detail screen so the user can immediately view and edit any record in the collection.
Can glide build an app like Insta stories maker
No, probably not.
@@RobertPetittoWA thanks