Getting user specific data in a column in the users table

Ask for Help
1

Hi. I need some help and will really appreciate support from seniors and glide experts.

I have two tables. One is a user table.

The other contains two columns. Item name and Favorite status (boolean) which is a user specific column. The use case is the user logs in to the app, and adds the items they like to their favorites.

What I want to get is in the user table, against the name of the user, it should show a list of items that the person has favorited. So the output that I want is like this:

User 1 - Apples, Bananas, Oranges
User 2 - Apples
User 3 - Oranges, Pineapples

I have gone through some posts but unable to find a way to do this. Please assist!

2

You would need to use an action that does two things:

  • Set column values on the boolean
  • Set column values on the column in the user profile row, adding the selected item to the list.

Search the forum for Trebuchet method, you can use that.

3 Likes
3
2 Likes
4

Thanks you so much. I was able to implement this. One quick question. Because I’m using solely Glide native tables and using these actions (set column values, etc.), would they be consuming updates? If no, I think I have done possibly the best thing that I could have done at work this whole year :slight_smile:

1 Like
5

It depends which plan you have.
If you have any sort of legacy plan, then yes they would count as updates.
Otherwise, no.

6

Annual Maker plan started in Aug 2024. It had only one published app then.

7

Okay, so that would be a legacy plan, but thinking more about it I’m not sure if updates on native tables would be counted or not. You can test it easily enough - just make some updates and check your usage counter before and after,

2 Likes
8

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.