Need assistance matching data

Ask for Help
1

Having issues matching up data. Anyone available for hire?

Working in a Camoe clone.

2

Hello if you still need help maybe i can help you :wink:

3

Hello Stanislas

Thank you. That would be amazing.

Iā€™m having issue linking reviews and requests to match up with correct performer.

What is the easiest way for us to proceed?

Should I give you user/pass for Glide?

Thank you again.

Tom

4

Hi Stanislas

Any chance you might have a few moments to take a look at the app?

5

Hello, yes with pleasure. You can give me access to your doc ā€œvew and commentā€ is enough to explore your sheet ;Ć )
my mail is stanislasverjus@gmail.com

6

Thank you Stanislas

I am trying to follow this tutorial. I am having trouble figuring out how to match up review and request to individual performers. I believe he is using a ā€˜Requests=Requests:Name:Multipleā€™ but I canā€™t figure out how to use this command.

I will email log in for Glide.

I will send money via paypal for your time.

Thank you.

7

Iā€™m guessing the two of you are working on this privately, but the ā€˜Requests=Requests:Name:Multipleā€™ is what you put in the header to establish a relation column. It works like this ā€˜ColumnName=RemoteSheet:RemoteSheetColumnName:Multipleā€™. The multiple just indicates that you are expecting multiple matches in the remote sheet. If you only expect a single match, then you would not include ā€˜:Multipleā€™ in the heading.

Itā€™s much easier to establish these relations by adding a relation column within the data tab of the builder.

1 Like
8

Iā€™m having this same issue with reviews showing for all users instead of the ones being viewed. Did anyone solve this? Thanks

9

@ResearchLLC Do you have any more information on what you are trying to accomplish. Depending on what you want, you would use either a relation or filter by signed in user.

10

So imagine you are leaving a review for a particular restaurant. Right now all the reviews are showing up for all the restaurants instead of just the relevant reviews. I canā€™t figure out how to fix that.

Thanks!

11

Create a relation column linking the restaurant name or ID in the Restaurant sheet to the restaurant name or ID in Reviews sheet. Then create an inline list on the restaurant detail page that uses the relation column for the source data. It will only show the reviews for that restaurant.

12

Thanks Jeff!

I am also trying to fix two other issues:

  1. I have three tabs at the bottom of the app. the 2nd tab is ā€œrequestsā€, which should show the users order requests from restaurants for example. I want to filter by signed in user, but it only gives me the option to filter by signed in user for the restaurant emailā€“not the customer email address. any ideas?

  2. similar issue where the 3rd tab is for ā€œreviewsā€ that the customer has left across all restaurants. However, I canā€™t select sort by signed in user email address for this eitherā€“just the restaurant email address.

any help is much appreciated thanks!

13

Do you have emails in the user email column for those tabs? Is probably need a screenshot of the data tab and what you see in the filter to fully understand.

14

Hey Jeff! Can I ask if there is any reason to set up relations by changing the header names, vs the creation of a relationship column within the spreadsheet in Glideā€™s data section?

15

@Amanda_Schulze Changing the header was the only way to set up relations before we had the data editor and the ability to create columns within Glide. That changed several months ago. Now that we have those features, I would recommend against setting them up in the sheet unless you had some specific reasoning behind it. Itā€™s just a lot of unnecessary overhead to do it the old way.

1 Like
16

Agreed! SOOOO much easier now than before.

1 Like
17

Im currently facing the same issue with matching data and have been trying to set up a relation. When an order goes through for a specific celeb, only that celeb should be able to see it in their admin page. I also need to do this for reviews. The tutorial linked is outdated, is there any possible way you have an updated way to do this?

18

The videos in the tutorial may be showing an outdated interface, but the data editor in glide should be very similar. The process for setting up relations hasnā€™t changed. For a relation to work, you need to select a column in the table that will have a matching column with the same value in another table. If the values match, then you have a related row.

19

Hope this isnā€™t a dumb question but does this work for rows too or only columns?

20

Iā€™m not sure I understand the question. To build a relation, you need a key value that is the same in both sheets. A relation returns matching rows based on that key value matching in both sheets. A relation does not return individual columns. If you need a specific column from that relation, then you can use a Lookup column that points to that relation.

1 Like