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.
Since you don’t have an API, the upside of having the data maintained in the Sheet is we can drive smarts using so many other platforms that work with Sheet docs.
At a minimum please also mirror the App: Logins as a log,
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 read through this and still cannot figure out how to access the favorites data for a user ? If a user favorites a set of pages how does she get to all of those ?
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.