How can I get access to the Favorites data from within a spreadsheet? I’d love to be able to do some spreadsheet magic with that data on a per user basis. For example, I’d love to be able to populate another sheet with all of the favorited items and build functionality on top of that.
Lots of progress. We will soon have a way for you to implement a feature like Favorites on your own, and access the data. Although the data will not write back to your sheet – it will be accessible in the Glide data editor and for reuse in your app.
Will that Favorites data increase the amount of records in any App if it uses that data to do other process/calculations?
If so, it will bring an indirect problem by accident. I mean, if 30 customers select 10 products as Favorite in 1 day, the App will have 300 additional rows very quick and its perfomance could be affected in few days.
In another user preference sheet, that contains a localuser’s email column, create a Relation column that links to the favorite options sheet, cross referencing the user’s email field created in Step 1. Now you have an array column that shows all the favorited options. If it’s looking up all the favorited item’s Row ID, then go to Step 3
Create a lookup column inside the user preference sheet, use the relation created in Step 2 and choose the name column (or equivalent) to show the favorited item’s name list
I want every user to be able to see what they have favorited. So basically what a user favorites. As a developer I don’t care much about what others have favorited. I’m assuming that I can “Preview As” to test it.