Hi everyone, I was watching a video of building booking app in glide as I wanted to use that feature. The video is about building a barber booking app and in the database of the app there were set of table out of which 2 of them were about Barber table and the other one was service table. So, in the app what he does is, he makes a column in service table with the query that only those barbers will show up who provides this service and are available. And in the Barber’s table he makes a column of naming “Service List” so that against each barber service can be put up in the cell.
My doubt and question is that what if a Barber has multiple services then how multiple services against a single barber will show up in a single cell? Can anyone help me with this?
For reference I’ve added the screenshots of the tables below:
Hello, I’m not familiar with the video. From the screenshots, the Services/List column is a basic text, from this one might assume that the cell will hold a comma-separated list of services of that barber. This value is a single value, but if there indeed is a list, then it is possible with a split column to isolate the individual values between the separators (I assume a comma or pipe).
So, that’s a normal text column that “services list” column. And I’m making something similar to this feature and I want to add services in one of my table against a user and then show up that users who are offering a particular service in the service table but I’m not sure how to add multiple services in a single cell against a single user. I’m following up the video and there’s no explanation of how the data will be stored in the “Services List” column if the barber has multiple services.
No, he made simple text column and nothing else. If we leave this video, Can you tell like how I put up multiple services name or id against a user so that in the service table I can show up multiple users against a particular service who are offering that service?
Okay, thanks a lot for tagging him. And answering my doubt. But how to use choice component? I’m on the free version so is this component available to me?
Okay, So let me give you brief again. It’s the data for the barber booking app and out of multiple tables there are 2 tables i.e. The Barber table and the Service Table. In the Service Table he is pulling all the barber through a query that offers that particular row service and are available as well, to show the users basically and in The barber table he added a Service Column under which the services can be entered against each barber. My question was that: A barber can have multiple service then how multiple service can be entered in simple text column named “Service List” in the Barbers Table.
Yeah, I searched for it but I don’t think it can solve my problem. This will only let barbers to select one of the service and not multiple.
I wanted to have a method under which I can enter multiple services against a single barber. So that he can choose multiple service while creating an account he can offer.
Choice allows you to select multiple.
When you enable multiple selection, it will write a comma separated list of the selected options.
You can then convert that to an array with a split text column, and relate the array to other tables.
Thanks a lot it worked. I didn’t applied the array I just made one more column and made that split text which is separating the text entered in the Service List column and it solved my problem. If there’s a need of creating an array of that then let me know. Thanks again.
