How do I have Glide only "examine" only one row?

Ask for Help
1

Hey guys,

I have a table with data on people and want to have analytics done on one person.

It looks sth like this:

Person A: Data point A1, Data point A2, Data point A3, Data point A1 + A2 + A3
Person B: Data point B1, Data point B2, Data point B3, Data point B1 + B2 + B3
Person C: Data point C1, Data point C2, Data point C3, Data point C1 + C2 + C3
Person D: Data point D1, Data point D2, Data point D3, Data point D1 + D2 + D3

Asking ChatGPT about the entire table to look for insights looks great.

What I want to do is ask ChatGPT to have a look at one specific row. Let’s say the user clicks on Person C. I want to be able to show a chart that is Data point C1 / Data point C1 + C2 + C3 and have ChatGPT give a short explanation of the data of that one person not of the entire table*.

Ofc I have much more data and I have found that with the right instructions and context ChatGPT can give a nice explanation on it, but I can’t get it to only take one row into consideration.

Any ideas?

Thanks in advance!

*Ideally comparing that one row to the entire table as well but one step at a time :sweat_smile:

2

I think glide AI would work here. You’d have two AI columns (C1 and C1+C2+C3), and then you’d prompt it.
Unless you don’t want to use this, use GPT integration instead. Then, you’d send the data, and chatgpt would respond.

3

but the columns wouldn’t be c1 and c1+c2+c3, they would be 1 and 1+2+3. If I would tell GlideAI or ChatGPT to take a look at those columns, it would look at the columns for Person A, B, D as well

4

Yes, it looks at it by rows. Since each person is a row. Then if it’s the whole table you could have a lookup column

5

I’m not sure if I understand this fully, but what would your inputs be? A column of c1, and a column that is the calculation of c1+c2+c3, then you want to compare that to the same numbers in other rows?

1 Like
6

Let’s say I have a table like this:

Name Height in cm Weight in kg Weight/Height Ratio
John 179 78 0,44
Ben 170 72 0,42
Maria 162 56 0,35
Tim 191 84 0,44

Now I want that when people click on John’s profile I can prompt AI to look at only the data on Jim, and maybe compare that to the scores of other maybe not. But the most important thing would be to have ChatGPT or Glide AI look at Jim’s weight, height, and the ratio and maybe compare it to others.

I want the same thing to happen for Ben, Maria and Tim when the user goes to their page and presses the button to ask ChatGPT on it.

Imagine that there will be hundreds of people with tens of columns so a manual solution wouldn’t be feasible.

7

Yes what you are asking for is for users to see the rows in a page.

If they click on John - they see John’s height and weight right?

If they click on Tim - they see Tim’s height and weight.

Along with their Weight/height ratio

You have a collection component that points to the table then ‘this row’

Then if you want to compare the height and weight with others use a query to filter the rows, of that whole column, have a roll up and compare it.

Infact for this specific use case a template column would work perfectly and you wouldn’t need ChatGPT or GlideAI - just some math column and a few others

8

I guess I am being very unclear. I don’t want them to only see the height and weight. I have already done that. I want for them to be able to click on a button and have ChatGPT explain to them what the height and weight mean. I want to ask ChatGPT sth like:

Analyze the data of John in a short and concise manner comparing him to the others as well as talking about what these numbers show about him. Don’t go on for two long just 2-3 sentences.

And it would say sth like:

John, at 179 cm and 78 kg, has a Weight/Height Ratio of 0.44, which is on par with Tim, the tallest in the group. His ratio is higher than Ben and Maria, indicating he carries more weight for his height compared to them. This suggests that John has a balanced physique similar to Tim, but slightly heavier relative to his height when compared to Ben and Maria.

So the users would have a short description of the data and what it shows about John. This would come in handy considering that there will be hundreds of people and they may want to compare John to the others.

Edit: Just found a solution that made me feel kinda stupid. I can use a Template and have sth like PERSON_NAME in the question and replace that with the person name in the column. Seems like kind of a workaround and I don’t get why you cannot reference a row inside of Glide.

1 Like
9

Ohh this is what you meant I can provide you with different solutions as to how this would work.

Let’s start:
Using AI | Glide AI or chat gpt

After getting the columns
Name - height and weight
Create a template column that follows this:
Micheal - 180cm - 15kg - 0.035 ratio

Then have a lookup of that Column so the new column each cell would be
Micheal - 180cm - 15kg…
John - 120cm - 12 kg…
Jim - 155cm - 23 kg

Basically all the people data
Then have your AI collect the data of the person and the data of the group.

Then you can compare it using your prompt

Just know if a row is added or updated you use an update

Glide works mainly on rows - so what we did here was get all the data in a row

The second way would be using a template column this would be more complex because the rows in the table can vary and the people data isn’t standard.

If you’re following this path do you plan on including all the people in the output or just a few that meets a certain criteria. Because this might get complex

So you would need to create different columns (e.g math, templates etc)
You’d have a column for “on par” that finds a case that a person matches Micheal data.

And you’d just work on the others the same way

10

It’s not a workaround, it’s the standard way to do it because you have to kind of specify what type of information you want to feed to Glide AI/ChatGPT. There can be a lot inside a row, and using too much would lead to you being over the limit for a “question”.