How best to do a User Favorite Column in Pages with changing data

[ThinhDinh]

With an external table, you can achieve it. It should be the same as below. Just replace the Places ID by the item ID (not rowID, since you’re replacing rows everyday).

How to send email to a list of user using Zapier in Glide?

I think you just stick to this extra table. Create a relation from the Places table to the Favorites table, and return all the emails through a joined list column. For favoriting/unfavorting: Favoriting: Add a row to the Favorites sheet, containing the signed-in user’s email and the Places ID. Unfavoriting: Add a template column in the Places table containing the email of the signed-in user and the Places ID. Let’s say it would look like: a@gmail.com - ID. Add a template column in the…

However, I would think of another way to “import” your data everyday. Maybe you can find a way to extract just “new” rows in your original database and add it to the end of your Sheet. Changing the item ID everyday makes it prone to error.